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 the database_role of STANDBY sql> SELECT database_role FROM v$database; DATABASE_ROLE —————- PRIMARY Convert to standby database sql> Alter database convert to physical standby; Now mount again: sql> […]

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 altered. — Error in alert log of standby database File #5 added to control file as ‘UNNAMED00005’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file […]

    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 primary database on maximum performance mode: SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE; 2. Remove below parameters from spfile of primary database: […]

    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 is lost:   1. start the standby database in mount stage:[ STANDBY] shut immediate; startup mount; 2. Check the […]

           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 below steps for renaming datafile in standby environment: For renaming datafile in oracle 12c – Refer 1. Make standby_file_management parameter to MANUAL [ […]

        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 of dataguard 12c .    DEMO: PRIMDB – Primary database STYDB – Standby database Check status of primary and […]

                                  There can be situation , in dataguard setup, where archive logs are missing from primary , before it was being shipped to standby  . Till 11g , we can make standby db sync with primary by taking an incremental […]

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, we have to make sure that the existing standby setup is fine and the archives are getting shipped and applied properly on standby. […]

                 To apply psu patch on  physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.  Download patch from oracle support. 1.Check the database_role for both dbs PRIMARY> select database_role from v$database; DATABASE_ROLE —————- PRIMARY STANDBY> select database_role […]

      Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human error, the archives has been deleted from primary. So without those archives, standby can’t be in sync with primary.   In […]