Dataguard - refresh a physical standby dataguard from primary avec RMAN

 

Steps to Refresh a Physical Standby Database with Changes Made to the Primary Database

 

source : https://docs.oracle.com/en/database/oracle/oracle-database/18/spmss/refresh-a-physical-standby-db.html#GUID-828A4953-3F7E-4975-ADA4-5469D6794BB0

 le site inclus les prérequis que l'on oublie souvent:

 

• Oracle Net connectivity is established between the physical standby database and the primary database.

  You can do this by adding an entry corresponding to the primary database in the tnsnames.ora file of the physical standby database.

• The password files on the primary database and the physical standby database are the same.

• The COMPATIBLE parameter in the initialization parameter file of the primary database and physical standby database is set to 12.0.

 

...

4 . (For Active Data Guard only) Perform the following steps to recover redo data and open the physical standby database in read-only mode:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE UNTIL CONSISTENT;

ALTER DATABASE OPEN READ ONLY;

...