Deleting alert log files, Trace Files Automated in Oracle Database
[oracle@localhost ~]$ adrci
ADRCI: Release 220.127.116.11.0 - Production on Tue Mar 7 10:42:16 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/grid"
adrci> show homes
adrci> show h
… Read more
ACFS Oracle ASM Cluster File System is cluster file system service used for High availability services.
Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS for goldengate relate files.
In this article, we will show how to create a ACFS file system in oracle RAC using command line.
ORACLE GRID VERSION – 18.104.22.168
NODES – NODE3 , NODE4
OS – Linux OEL
1.Create an ASM DISKGROUP( ON NODE 3)
sqlplus / as sysasm
SQL> CREATE DISKGROUP ACFSPOC EXTERNAL REDUNDANCY
… Read more
oracle clean up trace, alert, aud, listener and other log files
The path of each log file of the database
The method of viewing various Oracle logs: if it is rac, the query method under the asm instance is the same
1.View the diagnostic log:
The new diagnostic information structure of 11g and above versions, view v$diag_info information, display log directory:
show parameter diag;
select * from v$diag_info
The output example is as follows:
1 ADR Base
1 ADR Home
1 Diag Trace
… Read more
1. Check all services are up and running from 11gR2 GRID_HOME
2. Perform backup of OCR, voting disk and Database.
3. Create new directory for installing 12C software on both RAC nodes.
4. Run “runcluvfy.sh” to verify errors.
5. Install and upgrade GRID from 11gR2 to 12cR1
6. Verify upgrade version
1. Backup the database before the upgrade
2. Database upgrade Pre-check
Creating Stage for 12c database software
Creating directory for 12c oracle home
Check the pre upgrade status.
3.Unzip 12c database software in stage
4Install the 22.214.171.124 using the … Read more
Logminer is a utility provided with the Oracle database server which mines the redologs or Archivelogs and data dictionary information to build the SQL statements and keeps the contents of the redolog file in the fixed view called ” V$logmnr_contents “.
LogMiner tool can help the DBA to the find changed records in redo log files by using a set of PL/SQL procedures and functions .
Internally Oracle uses the Log Miner technology for several other features,such as Flashback Transaction Backout,Streams, and Logical Standby Databases .Most often LogMiner is used for recovery purpo… Read more
In the pervious article we have explained the Upgrade Grid Infrastructure 12c To 19c Oracle Now We will explain the steps for downgrade oracle 19c 2 node GRID to oracle 126.96.36.199 GRID.
2 NODES – localhost1 and localhost2
Grid owner – oracle
19C ORACLE_HOME(current) – > /sharearea/crs/grid19c
12C ORACLE_HOME (old) -> /crs/app/oracle/product/grid12c
1. Check the current grid version:( check on both the nodes)
oracle@localhost1:/$ crsctl query crs softwareversion
Oracle Clusterware version on node [dbhost1] is [188.8.131.52.0]
… Read more
The latest oracle version is oracle 19C . In the below article we will explain the steps for upgrading grid infrastructure to 19c from oracle 12c . The upgrade will be done in rolling mode.
Current configuration – >
No of nodes – 2 node
current version – 184.108.40.206
os platform – Linux
grid owner – oracle
Check software version :
oracle@node1~$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [220.127.116.11.0]
oracle@node2~$ crsctl query crs softwareversion
Oracle Clusterware version on node node1 is [18.104.22.168.0]
2. Download the software and unzip on your first … Read more