ORACLE 12C Redo Exception Recovery test-Patch Restore complete

Patch Information
C:\users\xifenfei>e:\oracle\product\11.2.0\dbhome_1\opatch\opatch lspatches
17977915; WINDOWS DB BUNDLE PATCH 12.1.0.1.3 (64bit): (17977915)

Session 1
Xifenfei_cdb$root@sys> show Con_name;

Con_name
------------------------------
Cdb$root

Xifenfei_cdb$root@sys> CREATE TABLE T_xifenfei as SELECT * from Dba_users;

Table has been created. Www.111cn.net

Xifenfei_cdb$root@sys> Delete from T_xifenfei;

35 rows have been deleted.

Xifenfei_cdb$root@sys>

Session 2
Xifenfei_cdb$root@sys> show Con_name;

Con_name
------------------------------
PDB1
Xifenfei_cdb$root@sys> CREATE TABLE T_xifenfei as SELECT * from Dba_users;

Table has been created.

Xifenfei_cdb$root@sys> Delete from T_xifenfei;

36 rows have been deleted.

Xifenfei_cdb$root@sys>

Session 3
Xifenfei_cdb$root@sys> alter session set CONTAINER=PDB2;

The session has changed.

xifenfei_cdb$root@sys> ALTER DATABASE open;

The database has changed.

Xifenfei_cdb$root@sys> show Con_name;

Con_name
------------------------------
PDB2
Xifenfei_cdb$root@sys>

Session 4
xifenfei_cdb$root@sys> shutdown abort;
The ORACLE routine has been closed.

Delete all redo and start the database
C:\users\xifenfei>sqlplus/as SYSDBA

Sql*plus:release 12.1.0.1.0 Production on Sunday March 30 21:07:55 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

You are connected to an idle routine.

idle> startup Mount;
The ORACLE routine has started.

Total System Global area 400846848 bytes
Fixed Size 2440024 bytes
Variable Size 289408168 bytes
Database buffers 100663296 bytes
Redo buffers 8335360 bytes
Database loading complete.
idle> ALTER DATABASE open;
ALTER DATABASE Open
*
Line 1th Error:
ORA-00313: Unable to open the members of Log Group 3 (for thread 1)
ORA-00312: Online log 3 thread 1: ' E:\APP\XIFENFEI\ORADATA\XIFENFEI\REDO03. LOG '
ORA-27041: Unable to open file
OSD-04002: Unable to open file
O/s-error: (OS 2) The system could not find the specified file.
Trying to recover a database
1
Idle> select status,group# from V$log;

STATUS group#
---------------- ----------
INACTIVE 1
Current 3
INACTIVE 2

idle> recover database until cancel;
ORA-00279: Change 2821739 (generated at 03/30/2014 20:58:39) is required for thread 1
ORA-00289: Suggestions:
E:\APP\XIFENFEI\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2014_03_30\O1_MF_1_36_%U_
. ARC
ORA-00280: Change 2821739 (for thread 1) in the sequence #36


Specify log: { =suggested | filename | AUTO | CANCEL}
Auto
ORA-00308: Unable to open archive log
' E:\APP\XIFENFEI\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2014_03_30\O1_MF_1_36_%U
_. ARC '
ORA-27041: Unable to open file
OSD-04002: Unable to open file
O/s-error: (OS 2) The system could not find the specified file.


ORA-00308: Unable to open archive log
' E:\APP\XIFENFEI\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2014_03_30\O1_MF_1_36_%U
_. ARC '
ORA-27041: Unable to open file
OSD-04002: Unable to open file
O/s-error: (OS 2) The system could not find the specified file.


ORA-01547: Warning: RECOVER successful but OPEN Resetlogs will receive the following error
ORA-01194: File 1 requires more recovery to maintain consistency
ORA-01110: Data file 1: ' E:\APP\XIFENFEI\ORADATA\XIFENFEI\SYSTEM01. DBF '


idle> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
Line 1th Error:
ORA-01194: File 1 requires more recovery to maintain consistency
ORA-01110: Data file 1: ' E:\APP\XIFENFEI\ORADATA\XIFENFEI\SYSTEM01. DBF '

Idle> alter system set "_allow_resetlogs_corruption" =true scope=spfile;

The system has changed.

idle> shutdown Immediate
ORA-01109: Database not open


The database has been unloaded.
The ORACLE routine has been closed.

idle> startup Mount;
The ORACLE routine has started.

Total System Global area 400846848 bytes
Fixed Size 2440024 bytes
Variable Size 289408168 bytes
Database buffers 100663296 bytes
Redo buffers 8335360 bytes
Database loading complete.
idle> recover database until cancel;
ORA-00279: Change 2821739 (generated at 03/30/2014 20:58:39) is required for thread 1
ORA-00289: Suggestions:
E:\APP\XIFENFEI\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2014_03_30\O1_MF_1_36_%U_
. ARC
ORA-00280: Change 2821739 (for thread 1) in the sequence #36


Specify log: { =suggested | filename | AUTO | CANCEL}
Cancel
ORA-01547: Warning: RECOVER successful but OPEN Resetlogs will receive the following error
ORA-01194: File 1 requires more recovery to maintain consistency
ORA-01110: Data file 1: ' E:\APP\XIFENFEI\ORADATA\XIFENFEI\SYSTEM01. DBF '


ORA-01112: Media Recovery not started


idle> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
Line 1th Error:
Ora-01092:oracle instance terminated. Disconnection forced
Ora-00704:bootstrap Process Failure
Ora-00704:bootstrap Process Failure
Ora-00600:internal error code, arguments: [2662], [0], [2821746], [0],
[2822649], [4194545], [], [], [], [], [], []
Process id:6880
Session id:242 Serial Number: 3

idle> startup Mount;
Sp2-0642:sql*plus internal Error state 2133, context 3114:0:0
Continued execution will not be safe
ORA-03114: Not connected to ORACLE

--using bbed to solve dul problems and emerging problems
idle> ALTER DATABASE open;
ALTER DATABASE Open
* Www.111cn.net
Line 1th Error:
Ora-01092:oracle instance terminated. Disconnection forced
Ora-00600:internal error code, arguments: [4194], [61], [4], [], [], [], [],
[], [], [], [], []
Process id:5932
Session id:242 Serial Number: 3

idle> ALTER SYSTEM SET undo_management= ' Manaul ' scope=spfile;

The system has changed.

Idle> SHUTDOWN IMMEDIATE;
ORA-01109: Database not open


The database has been unloaded.
The ORACLE routine has been closed.

idle> startup Mount;
The ORACLE routine has started.

Total System Global area 400846848 bytes
Fixed Size 2440024 bytes
Variable Size 281019560 bytes
Database buffers 109051904 bytes
Redo buffers 8335360 bytes
Database loading complete.
idle> ALTER DATABASE open;

The database has changed.
[/sql
Open PDB
1
Idle> alter session set CONTAINER=PDB1;

The session has changed.

idle> ALTER DATABASE open;

The database has changed.

Idle> alter session set CONTAINER=PDB2;

The session has changed.

idle> ALTER DATABASE open;

The database has changed.

Idle> alter session set CONTAINER=PDB1;

The session has changed.

ORACLE 12C bugs are not expected to be too little, eager to 12C friends, strongly recommend hitting the first patch, less stepping on some thunder

Contact: Mobile Phone (13429648788) QQ (107644445)
Link:http://www.xifenfei.com/5234.html
Author: Xi-FEI