删除test03 pdb的数据库目录
[oracle@master2 orclstdydb]$ rm -rf test3/
[oracle@master2 orclstdydb]$ ls
control01.ctl pdbseed redo03.log standby_redo03.log system01.dbf test2
control02.ctl redo01.log standby_redo01.log standby_redo04.log temp01.dbf undotbs01.dbf
orclpdb redo02.log standby_redo02.log sysaux01.dbf test users01.dbf
[oracle@master2 orclstdydb]$ clear
[oracle@master2 orclstdydb]$
[oracle@master2 orclstdydb]$
[oracle@master2 orclstdydb]$ ls
control01.ctl pdbseed redo03.log standby_redo03.log system01.dbf test2
control02.ctl redo01.log standby_redo01.log standby_redo04.log temp01.dbf undotbs01.dbf
orclpdb redo02.log standby_redo02.log sysaux01.dbf test users01.dbf
[oracle@master2 orclstdydb]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 25 01:40:48 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB MOUNTED
4 TEST MOUNTED
5 TEST2 MOUNTED
SQL> alter system set enabled_PDBs_on_standby='*';
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 318767104 bytes
Fixed Size 8792152 bytes
Variable Size 251660200 bytes
Database Buffers 50331648 bytes
Redo Buffers 7983104 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB MOUNTED
4 TEST MOUNTED
5 TEST2 MOUNTED
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> show pdbs;