Dear Readers, Trust you are doing well!!! Today I am going to write about interesting feature being introduced in Oracle version 12.2 & widely used in 19c. Multi-Instance Redo Apply(MIRA) Basically Oracle has different ways to apply redo on standby site. SIRA: Single Instance Redo Apply ==> Wherein MRP runs […]
Dear Readers, Trust you are doing well, Today I am writing this post related to recent issue which we faced on one of the critical database post switchover to standby site. When I was checking AWR comparison reports to do some sanity checks, I found write IO statistics were increased […]
Dear Readers, Trust you are doing well!! Today I am going to write about issue I recently faced during running TFA for collecting SRDC regarding the performance issue I was working on. These TFA files were requested by Oracle global support for investigation purpose. I used below command for collecting […]
Dear Readers, It happened many times, when I need to search a document MOS/Metalink Oracle support, which I referred in past but unable to find now. So thought of writing a Master Note which will have all MOS/Oracle Metalink documents you should have it handy when working on Exadata. Hope […]
Recently I was doing fresh Grid Infrastructure(GI) 12.2 install on one of our UAT boxes, wherein I was facing strange issue. Both “root.sh” & “./roothas.sh -postpatch” exiting with below error/warning: CLSRSC-400: A system reboot is required to continue installing. test-server01:/u01/app/12.2.0.1/grid/bin # cd $ORACLE_HOME/crs/install test-server01:/u01/app/12.2.0.1/grid/crs/install # ./roothas.sh -postpatch Using configuration parameter […]
Yesterday I was trying to start DB services using SRVCTL on one of the new environment. I was able to start individual database instances using sqlplus, but it was giving issues for SRVCTL, I was able to start one of the two instances using SRVCTL, but not both, it was […]
From last two days, I have been getting “ORA-27054: NFS file system not mounted with correct options” error while running an RMAN backup to a Sun ZFS Storage Appliance. This error have been observed particularly, while taking controlfile backups. RMAN datafile or archivelog backups without controlfile were running fine. RMAN-08132: WARNING: […]
Few days back, I was working on a issue where in Clusterware was not coming up on UAT environment. Daemon ora.crsd was OFFLINE. I tried to start ora.crsd daemon using command “crsctl start res ora.crsd -init”, but failed giving following error: I tried searching about error on metalink and google […]
Adityanath's Oracle Blog 