共计 5361 个字符，预计需要花费 14 分钟才能阅读完成。
背景：Oracle 12.2 搭建 ADG，在主库创建 pdb 时发现备库告警 ORA-600。DBCA 删除主库的 pdb 后，备库 pdb 没有自动删除，故手动删除备库的 PDB。
备库：
[oracle@master2 ~]$ 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
[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]$
[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;
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
更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址 ：http://www.linuxidc.com/Linux/2017-10/147974.htm
