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.