Shulou(Shulou.com)06/01 Report--

Background: Oracle12.2 builds ADG, and discovers slave database alarm ora-600 when the main database creates pdb. After DBCA deletes the pdb of the master database, the slave pdb is not deleted automatically, so delete the pdb of the slave database manually.

Prepare the library:

[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

Delete the database directory of 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.