Below are the steps for recreating physical standby controlfile. 1. Get the controlfile location [STANDBY] SQL> show parameter control_files NAME TYPE VALUE --------------------------------...
dataguard
ORA-01665: control file is not a standby control file
PROBLEM: After restoring standby database from RMAN backup, got below error, while mounting standby database,getting below error. ORA-01665: control file is not a standby control file SOLUTION: Check ...
ORA-01274: cannot add data file that was originally created as
PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database: SQL> alter tablespace prim add datafile size 1g; Tablespace alt...
Remove dataguard configuration from Primary database:
If you wish to remove the dataguard/standby setup from primary database i.e to make the primary database as standalone database without any standby database, then follow below steps. 1.Put prima...
How to open standby database when primary database is lost
If your primary database is not accessible or crashed for any issue, then we can use open the standby database for use. Below are the steps for opening standby database when the primary database...
How to rename datafile in standby setup in 11g
When you rename a in the primary database, the change won’t be reflected on standby database, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO. Follow...
Restore missing datafile in standby database oracle 12c
In oracle 12c, if datafile is missing is standby database, then it can be restored easily from primary database using RESTORE DATAFILE FROM SERVICE command. This is one of the new feature ...
Rolling forward standby database when archives missing in primary in 12c
There can be situation , in dataguard setup, where archive logs are missing from primary , before it was being shipped to standby . Till 11g , we ...
Switch over in physical standby database
In dataguard setup, we can make primary database as physical standby database and standby as primary . This is known as switch over. STEPS: TEST1 – Primary TEST2- STANDBY Before doing switchover...
Convert physical standby to snapshot standby database
What is snapshot standby: Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot ...