Saturday, May 16, 2020

AUTOMATIC PDB OPENING

Automatically keep PDBs State after CDB STARTUP:


SQL> ALTER PLUGGABLE DATABASE PDB1 SAVE STATE;
SQL> ALTER PLUGGABLE DATABASE ALL SAVE STATE;
SQL> ALTER PLUGGABLE DATABASE PDB1,PDB3,PDB6 SAVE STATE;

Automatically keep PDBs State after CDB STARTUP:


SQL> ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;
SQL> ALTER PLUGGABLE DATABASE ALL DISCARD STATE;
SQL> ALTER PLUGGABLE DATABASE PDB1,PDB3,PDB6 DISCARD STATE;

No comments:

Post a Comment

student guide Dataguard: GLOBAL_DBNAME = <dbuniquename>_DGMGRL.example.com  Example: listener.ora on Primary Hosts Static listener ent...