Troubleshoot

SOLUTION Please perform the following steps on the physical standby database to resolve the issue. – Please cancel the managed recovery by – Set standby_file_management=manual If the physical standby database …

The primary database is operating in MAXIMUM PROTECTIONor MAXIMUM AVAILABILITY mode, and the standby database doesnot contain any viable standby redo logfiles.ORA-16086: Redo data cannot be written to the standby …

In the following post we’ll go through every possible scenario where we loose REDO, one by one. REDO is the most crucial part when we talk about recovery and contains …

 Incorrect environment. ORACLE_HOME for grid should be pointing to grid directory and ORACLE_SID for ASM should be +ASM. Try this: export ORACLE_HOME=$GRID_HOME export $ORACLE_SID=+ASM export PATH=$GRID_HOME/bin:$PATH

 How to resolve the error   RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause ? Error:Starting Duplicate Db at 9-SEP-14RMAN-00571: ===========================================================RMAN-00569: =============== …

 This error normally occur  because of the INDEX or table structure is in consistent mode. Analyze the index structure and tables.If index structure is failed in analyze , drop the …

 💡 While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view. …

Make sure that your ORACLE_HOME and ORACLE_SID are correct To see the current values in windows, at the command prompt type echo %ORACLE_HOME% Then echo %ORACLE_SID% If the values are …

💡 Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE “XXXX” as connect identifier is “XXXX” maintained as physical; Error: …

 <aside> 💡 The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error “ORA-16795: the …