Today I was checking a new configured RMAN backup job on an ODG standby server in an ODA (X7-2-HA) RAC environment and noticed there was a failure (see below error messages) when doing the autobackup of controlfile and spfile. RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 06/23/2020 13:54:27ORA-00245: control … Continue reading Interesting case with ORA-00245
Month: June 2020
RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy
With RMAN configure controlfile autobackup set to ON, RMAN automatically creates a control file and an SPFILE backup after you run the BACKUP or COPY commands. If you have a daily backup task, you will see autobackup of control file and spfile created every day after your main backup. That is good, huh! They are … Continue reading RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy
ODG — ORA-38760 This database instance failed to turn on flashback
In my last post, I resolved an ODG issue that the primary server IP was wrong on the standby server. I walked away and one hour later, I was told the redo apply was still not working. "Something else is wrong?" I was thinking. So I looked at the system again. I saw the error … Continue reading ODG — ORA-38760 This database instance failed to turn on flashback
ODG — ORA-16854: apply lag could not be determined
An ODG system has been upgraded recently to 19C and redo apply stopped working. I was asked to take a look at it. It is managed by ODG broker. When checking it in dgmgrl using "show configuration;", I saw the error "ORA-16810: multiple errors or warnings detected for the database" on the standby database. Then … Continue reading ODG — ORA-16854: apply lag could not be determined
Things to note in Oracle Initialization Parameter Files
When an Oracle instance starts, it reads initialization parameters from an initialization parameter file. For any initialization parameters not specifically included in the initialization parameter file, the database supplies defaults. The initialization parameter file can be either a read-only text file, or a read/write binary file. The binary file is called a server parameter file. … Continue reading Things to note in Oracle Initialization Parameter Files
JoeLi's TechLife 