Oracle Database Discussions

hello,

Working on a legacy database, no backup setup (no rman backup).

when

sql> alter database open;

alter database open

*

ERROR at line 1:

ORA-00399: corrupt change description in redo log

ORA-00353: log corruption near block 3 change 208557127 time 11/05/2015

12:28:42

ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/db9epa/redo02.log'

then do as below .....

shutdown immediate

startup mount

ALTER SYSTEM SET "_allow_resetlogs_corruption"= TRUE SCOPE = SPFILE;

shutdown immediate

startup mount

alter database open resetlogs;

recover database until cancel;

ORA-00279: change 208537113 generated at 11/02/2015 16:56:48 needed for thread
1
ORA-00289: suggestion :
/opt/oracle/fast_recovery_area/DB9EPA/archivelog/2015_11_05/o1_mf_1_8237_%u_.ar
ORA-00280: change 208537113 for thread 1 is in sequence #8237

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/opt/oracle/fast_recovery_area/DB9EPA/archivelog/2015_11_05/o1_mf_1_8237_%u_.a
c'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-10879: error signaled in parallel recovery slave
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: '/db1/oradata/data/db9epa/system01.dbf'

OKay, find there is no archivelog in dir /opt/oracle/fast_recovery_area/DB9EPA/archivelog/2015_11_05

I guess, for unkown reason, it is gone.

try to force start, after shutdown gracefully.

SYS> startup force
ORACLE instance started.

Total System Global Area 1.2694E+10 bytes
Fixed Size                  2238304 bytes
Variable Size            9831450784 bytes
Database Buffers         2852126720 bytes
Redo Buffers                7933952 bytes
Database mounted.
ORA-00399: corrupt change description in redo log
ORA-00353: log corruption near block 3 change 208557127 time 11/05/2015
12:28:42
ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/db9epa/redo02.log'

SYS> ALTER DATABASE CLEAR LOGFILE '/opt/oracle/oradata/db9epa/redo02.log';
ALTER DATABASE CLEAR LOGFILE '/opt/oracle/oradata/db9epa/redo02.log'
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance db9epa (thread 1)
ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/db9epa/redo02.log'

SYS> alter database drop logfile group 2;
alter database drop logfile group 2
*
ERROR at line 1:
ORA-01623: log 2 is current log for instance db9epa (thread 1) - cannot drop
ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/db9epa/redo02.log'

SYS> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open

SYS> ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE
*
ERROR at line 1:
ORA-01109: database not open

SYS> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.

SYS> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

--check logfile;

---------- ---------------------------------------- ---------------- --- ----------

any help?

thank you very much!!!