Starting and Stopping Pluggable Databases In 12c
Starting the pdbs:
Check the status of the pdb's
sqlplus '/ as sysdba'
SQL> select name, open_mode from v$pdbs;
SQL> show pdbs
Note: All the PDBs are in MOUNT state.
Start a single pdb
show pdbs
alter pluggable database lub1 open;
Start all pdb's in single command
show pluggable
alter pluggable database all open;
Note: While starting the pdbs database characterset and pluggable database status information will be written in alertlog.
Stopping the pdbs:
Check the status of the pdb's
sqlplus '/ as sysdba'
SQL> select name, open_mode from v$pdbs;
SQL> show pdbs
Note: All the PDBs are in READ WRITE state.
Stop a single pdb
show pdbs
alter pluggable database lub1 close immediate;
Stop all pdb's in single command
show pluggable
alter pluggable database all close immediate;
Note: While closing the pdb's buffer cache will be flushed.
Create a trigger to open all pluggable databases.
sqlplus '/ as sysdba'
CREATE OR REPLACE TRIGGER pdb_startup AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'alter pluggable database all open';
END pdb_startup;
/
No comments:
Post a Comment