OPEN AND CLOSE PDBS'S

https://www.youtube.com/watch?v=eh_RLA90SUo&list=PLFIuxLy_v_CVZIDNyLYsO49TGZxcXANil&index=4


ALTER PLUGGABLE DATABASE
Modifying the Settings of a PDB: Example
ALTER PLUGGABLE DATABASE pdb2  STORAGE (MAXSIZE 500M);

Taking the Data Files of a PDB Offline: Example
ALTER PLUGGABLE DATABASE pdb3 DATAFILE ALL OFFLINE;


ALTER PLUGGABLE DATABASE pdb4  OPEN READ ONLY;

run query to check list of PDB's

SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;
 FORCE;
ALTER PLUGGABLE DATABASE pdb4  CLOSE;

ALTER PLUGGABLE DATABASE pdb4 OPEN READ ONLY RESTRICTED;


ALTER PLUGGABLE DATABASE pdb6
  CLOSE RELOCATE TO 'ORCLDB_3';In an Oracle Real Application Clusters environment, the following statement closes PDB pdb6 in the current instance and instructs the database to reopen pdb6 in instance ORCLDB_3:


run query to check list of PDB's

SELECT b.con_id, a.pdb_name, a.status,b.open_mode
from dba_pdbs a, v$pdbs b
where a.pdb_name=b.name
order by b.con_id;

NOTE AFTER CREATION YOU HAVE TO OPEN IN READ WRITE MODE NOT READ ONLY MODE
SQL> ALTER PLUGGABLE DATABASE pdb4 OPEN READ WRITE;
SQL> ALTER PLUGGABLE DATABASE pdb4,pdb3 CLOSE IMMEDIATE;
SQL> ALTER PLUGGABLE DATABASE pdb4,pdb3 OPEN READ WRITE;
SQL> ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;
SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT pdb3 OPEN READ WRITE;
SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT pdb3 CLOSE IMMEDIATE;
SQL> ALTER PLUGGABLE DATABASE pdb4 open resetlogs


YOU CANNOT OPEN OR CLOSE SEED DATABASE;