How we do convert the physical standby pdb database into snapshot standby

 

Below are the step-by-step procedures to convert a Physical Standby PDB (in an Oracle Multitenant Data Guard environment) into a Snapshot Standby, and then convert it back.

Important Notes

·       Snapshot standby conversion is done at the CDB level, not at the PDB level.

·       When you convert a standby to snapshot standby, all PDBs in that standby CDB become writable.

·       You cannot convert only a single PDB to snapshot mode.

·       Your Data Guard configuration must be valid, and redo apply must be STOPPED before conversion.

 

Run these commands on the standby database (CDB-level).

SQL> show pdbs

SQL> CON_ID CON_NAME    OPEN_MODE  RESTRICTED

        --------- -------------        ----------------   ------------------

         2       PDB$SEED     READ ONLY  NO

         3       myfirst_pdb     READ ONLY  NO

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> alter session set container=myfist_pdb ;

SQL>shutdown immediate

SQL>exit

Sqlplus /  as sysdba

SQL> shutdown immediate

SQL> show pdbs

SQL> CON_ID CON_NAME    OPEN_MODE  RESTRICTED

        --------- -------------        ----------------   ------------------

         2       PDB$SEED     MOUNTED     NO

         3       myfirst_pdb     MOUNTED     NO

 

SQL> alter database convert to snapshot standby ;

SQL> select name,open_mode,data_role from v$database ;

      NAME   OPEN_MODE     DATABASE_ROLE

----------------   ------------------     ---------------------------

Myfin          MOUNTED       SNAPSHOT STANDBY

SQL> Alter database open ;

SQL>Show Pdbs

SQL> CON_ID CON_NAME    OPEN_MODE  RESTRICTED

        --------- -------------        ----------------   ------------------

         2       PDB$SEED     READ ONLY       NO

         3       myfirst_pdb     MOUNTED       NO

SQL> alter session set container=myfirst_pdb ;

SQL> alter database open ;

SQL> CON_ID CON_NAME    OPEN_MODE  RESTRICTED

        --------- -------------        ----------------   ----------------

         3       myfirst_pdb     READ WRITE       NO

Thank you to All ....

Thank you for giving your valuable time to read the above information.