======================================
Note: Oracle hidden parameters are undocumented and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before placing them in your production environment.
Parameter Name Description
----------------------------------------- --------------------------------------------------------
_allow_error_simulation Allow error simulation for testing
_allow_read_only_corruption allow read-only open even if database is corrupt
_allow_resetlogs_corruption allow resetlogs even if it will cause corruption
_allow_terminal_recovery_corruption Finish terminal recovery even if it may cause corruption
_corrupted_rollback_segments corrupted undo segment list
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2010_09_21\O1_MF_1_10_69JBT2QG_.ARC
SQL> select GROUP#,THREAD#, SEQUENCE#,members,status from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1 1 11 1 CURRENT
2 1 9 1 INACTIVE
3 1 9 1 INACTIVE
SQL> ALTER DATABASE DROP LOGFILE GROUP 3;
Database altered.
SQL> select GROUP#,THREAD#, SEQUENCE#,members,status from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1 1 11 1 CURRENT
2 1 9 1 INACTIVE
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 1
*
ERROR at line 1:
ORA-01623: log 1 is current log for instance test (thread 1) - cannot drop
ORA-00312: online log 1 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\REDO01.LOG'
SQL> select GROUP#,THREAD#, SEQUENCE#,members,status from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1 1 11 1 CURRENT
2 1 9 1 INACTIVE
SQL> shut immediate
ORA-03113: end-of-file on communication channel
SQL> shut immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> select name,open_mode from v$database;
ERROR:
ORA-03114: not connected to ORACLE
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
D:\Documents and Settings\vzc00m>sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 21 10:47:40 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> exit
Disconnected
D:\Documents and Settings\vzc00m>sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 21 11:00:55 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 222301180 bytes
Database Buffers 360710144 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00316: log 1 of thread 1, type 0 in header is not log file
ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\REDO01.LOG'
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
D:\Documents and Settings\vzc00m>sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 21 11:07:32 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> startup pfile='D:\oracle\product\10.2.0\admin\test\pfile\init.ora.8152010234343' mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shut abort
ORACLE instance shut down.
SQL> startup pfile='D:\oracle\product\10.2.0\admin\test\pfile\init.ora.8152010234343' mount;
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 163580924 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00316: log 1 of thread 1, type 0 in header is not log file
ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\REDO01.LOG'
SQL> shut abort
ORACLE instance shut down.
SQL> startup pfile='D:\oracle\product\10.2.0\admin\test\pfile\init.ora.8152010234343';
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 163580924 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-00316: log 1 of thread 1, type 0 in header is not log file
ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\REDO01.LOG'
SQL> startup pfile='D:\oracle\product\10.2.0\admin\test\pfile\init.ora.8152010234343' mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL>
SQL> shut abort
ORACLE instance shut down.
SQL> startup pfile='D:\oracle\product\10.2.0\admin\test\pfile\init.ora.8152010234343' mount;
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 163580924 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database until cancel;
ORA-00279: change 815808 generated at 09/21/2010 09:19:17 needed for thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2010_09_21\O1_MF_1_11_%U_.ARC
ORA-00280: change 815808 for thread 1 is in sequence #11
Specify log: {
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL> recover database until cancel USING BACKUP CONTROL FILE;
ORA-00905: missing keyword
SQL> recover database until cancel;
ORA-00279: change 815808 generated at 09/21/2010 09:19:17 needed for thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2010_09_21\O1_MF_1_11_%U_.ARC
ORA-00280: change 815808 for thread 1 is in sequence #11
Specify log: {
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2010_09_21\O1_MF_1_10_69JBT2QG_.ARC
ORA-00310: archived log contains sequence 10; sequence 11 required
ORA-00334: archived log:
'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2010_09_21\O1_MF_1_10_69JBT2QG_.ARC'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSTEM01.DBF'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> select name,open_mode from v$database;
ERROR:
ORA-03114: not connected to ORACLE
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
D:\Documents and Settings\vzc00m>sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 21 11:34:52 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 222301180 bytes
Database Buffers 360710144 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL>
2nd time also faced the same issue, I did the same, and followed the above commands/ all cmds
SQL> startup
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 167775228 bytes
Database Buffers 415236096 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\BUS\SYSTEM01.DBF'
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select group#,thread#,members,status from v$log;
GROUP# THREAD# MEMBERS STATUS
---------- ---------- ---------- ----------------
1 1 1 CURRENT
2 1 1 UNUSED
3 1 1 INACTIVE
SQL> shut abort
ORACLE instance shut down.
Removed the Hidden parameter which I was included the Init file -- _ALLOW_RESETLOGS_CORRUPTION=true
SQL> startup pfile='D:\oracle\product\10.2.0\admin\bus\pfile\init.ora.8212010154717';
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 163580924 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
SQL> shut abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 1250308 bytes
Variable Size 171969532 bytes
Database Buffers 411041792 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEBUS.ORA
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
D:\Documents and Settings\vzc00m>
Regards,
Ravi P
No comments:
Post a Comment