ORACLE12C_ADG删除pdb

背景：Oracle12.2搭建ADG，在主库创建pdb时发现备库告警ora-600。DBCA删除主库的pdb后，备库pdb没有自动删除，故手动删除备库的pdb

创新互联公司成立于2013年，是专业互联网技术服务公司，拥有项目网站制作、做网站网站策划，项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命，1280元平顺做网站,已为上家服务,为平顺各地企业和个人服务,联系电话:13518219792

备库：

[oracle@master2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 25 01:29:10 2017

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 READ ONLY NO

4 TEST READ ONLY NO

5 TEST2 READ ONLY NO

6 TEST3 MOUNTED

SQL> alter system set enabled_PDBs_on_standby=ORCLPDB,TEST,TEST2 ;

System altered.

SQL> show parameter enabled_PDBs_on_standby;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

enabled_PDBs_on_standby string ORCLPDB, TEST, TEST2

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> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 ORCLPDB MOUNTED

4 TEST MOUNTED

5 TEST2 MOUNTED

6 TEST3 MOUNTED

SQL> show parameter ENABLED_PDBS_ON_STANDBY

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

enabled_PDBs_on_standby string ORCLPDB, TEST, TEST2

SQL>

SQL> alter database recover managed standby database using current logfile disconnect;

alter database recover managed standby database using current logfile disconnect

ERROR at line 1:

ORA-01153: an incompatible media recovery is active

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> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@master2 ~]$ cd

[oracle@master2 ~]$ cd /u01/

[oracle@master2 u01]$ ls

app arch

[oracle@master2 u01]$ d app/oracle/oradata/

-bash: d: command not found

[oracle@master2 u01]$ ls

app arch

[oracle@master2 u01]$ cd app/oracle/

[oracle@master2 oracle]$ ls

admin cfgtoollogs checkpoints diag oradata product tfa

[oracle@master2 oracle]$ cd oradata/

[oracle@master2 oradata]$ ls

orclstdydb

[oracle@master2 oradata]$ cd orclstdydb/

[oracle@master2 orclstdydb]$ ls

control01.ctl pdbseed redo03.log standby_redo03.log system01.dbf test2 users01.dbf

control02.ctl redo01.log standby_redo01.log standby_redo04.log temp01.dbf test3

orclpdb redo02.log standby_redo02.log sysaux01.dbf test undotbs01.dbf

删除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]$ 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

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;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 ORCLPDB READ ONLY NO

4 TEST READ ONLY NO

5 TEST2 READ ONLY NO

本文名称：ORACLE12C_ADG删除pdb
转载来于：http://myzitong.com/article/goppcp.html

ORACLE12C_ADG删除pdb

其他资讯