dataguard

How to setup dataguard broker configuration (DG broker) in 12c

Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites. In this article, we will see, how to enable dg...

How to add a tempfile in primary database in dataguard

If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database. But will the same valid for tempfile?? Answer is NO...

How to enable active dataguard in physical standby database

Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Below are the benefit of using active dataguard. Reporting queries can b...

How to recreate physical standby controlfile

     Below are the steps for recreating physical standby controlfile. 1. Get the controlfile location [STANDBY] [crayon-5beb1e55bcc4b986195998/] 2. Cancel recovery [STANDBY] [crayon-5beb1e55bcc5256...

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 ...

Page 1 of 212
Skip to toolbar