Saturday, May 16, 2020

CLOSING A PDBS

CLOSING A PDBS


SQL> CONNEXT / AS SYSDBA;
SQL> ALTER PLUGGABLE DATABASE PDB1 CLOSE IMMEDIATE;
SQL> ALTER PLUGGABLE DATABASEALL EXCEPT  PDB1,PDB3  CLOSE;
SQL> ALTER PLUGGABLE DATABASEALL EXCEPT  ALL  CLOSE;

SQL> CONNECT AS SYS@PDB1 AS SYSDBA
SQL> ALTER PLUGGABLE DATABASE CLOSE;
or
SQL> SHUTDOWN IMMEDIATE;






No comments:

Post a Comment

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