Jun 6, 2010

Recovery - Media recovery vs Corrupted Recovery

Today I faced a recovery issue with one of my database.
Media Recovery:
Database Name: xxxxxx
OS : SunOs
Alertlog Error Message:
CJQ0: terminating instance due to error 472
Instance terminated by CJQ0, pid = 9963
Step 1 :When manually tried to start the database below error occured.
Cause:
SQL> startup open
ORACLE instance started.
Total System Global Area 338657376 bytes
Fixed Size 729184 bytes
Variable Size 234881024 bytes
Database Buffers 100663296 bytes
Redo Buffers 2383872 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/u02/oradata/xxxxxx/system01.dbf'
Step 2: Verified all the archivelogs are in place and recovered the database.
SQL> recover database;
Media recovery complete.
SQL> alter database open
2 /
NAME OPEN_MODE LOG_MODE
--------- ---------- ------------
xxxxxx READ WRITE ARCHIVELOG

1 comment:

  1. the problem of data corruption in the files of specified format can be fixed by the adobe pdf fixer utility

    ReplyDelete