ORACLE12C_ADG刪除pdb

標籤：oracle12c adg pdb

背景：Oracle12.2搭建ADG，在主庫建立pdb時發現備庫警示ora-600。DBCA刪除主庫的pdb後，備庫pdb沒有自動刪除，故手動刪除備庫的pdb

備庫：

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 25 01:29:10 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                        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> 

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

[[email protected] ~]$ cd 

[[email protected] ~]$ cd /u01/

[[email protected] u01]$ ls

app  arch

[[email protected] u01]$  d app/oracle/oradata/

-bash: d: command not found

[[email protected] u01]$ ls

app  arch

[[email protected] u01]$ cd app/oracle/

[[email protected] oracle]$ ls

admin  cfgtoollogs  checkpoints  diag  oradata  product  tfa

[[email protected] oracle]$ cd oradata/

[[email protected] oradata]$ ls

orclstdydb

[[email protected] oradata]$ cd orclstdydb/

[[email protected] 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的資料庫目錄

[[email protected] orclstdydb]$ rm -rf test3/

[[email protected] 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

[[email protected] orclstdydb]$ clear

[[email protected] orclstdydb]$ 

[[email protected] orclstdydb]$ 

[[email protected] 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

[[email protected] 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;

    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

本文出自 “13401870” 部落格，請務必保留此出處http://13411870.blog.51cto.com/13401870/1975771

ORACLE12C_ADG刪除pdb