Thursday, May 8, 2014

Recover corrupted datafile - step by step.

Hi All ...

Here the step by step how to recover corrupted  datafile.
I got the following error after DB crush:

ORA-01110: data file 12: '/oraprd/prddata/sysaux02.dbf'
ORACLE Instance PRD (pid = 12) - Error 376 encountered while recovering transaction (115, 24) on object 373247.
Errors in file /oraprd/prddb/diag/rdbms/prd/PRD/trace/PRD_smon_21693.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: '/oraprd/prddata/sysaux01.dbf'

Action Plan:

1. alter database datafile '/oraprd/prddata/sysaux01.dbf' offline;
    alter database datafile '/oraprd/prddata/sysaux02.dbf' offline;

2. alter system switch logfile; (do it 10 times to be sure)

3. shutdown abort;
4. startup mount;
5. recover datafile '/oraprd/prddata/sysaux02.dbf';
ORA-00279: change 1306769 generated at 05/05/2014 22:54:48 needed for thread 1
ORA-00289: suggestion : /oraprd/archive/817T001S02245.arc
ORA-00280: change 1306769 for thread 1 is in sequence #2245

Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.
Media recovery complete.
--- Do it for all your corrupted files
6. alter database open;
7. alter database datafile '/oraprd/prddata/sysaux01.dbf' online;
8. select tablespace_name, file_name, status from dba_data_files;
--- All files need to be with AVAILABLE status.

Good Luck ...

No comments:

Post a Comment