ORA-00376: file 13 cannot be read at this time

ORA-00376: file 3 cannot be read at this time

The other day going through my daily logs, I noticed after an unsuccessful disk move before the weekend, - seemed to have some issues.

ORA-00376: file 3 cannot be read at this time

ORA-01110: data file 3: "/my_path_to/ORACLE_SID/filename.dbf!

i logged myself onto LINUX at the same time to have a look inside v$datafile.

[] sqlplus / as sysdba

SQL> set pages 500

SQL> select * from v$datafile;

My interest in v$datafile is of course status, and status for file 3 was in RECOVER - so its a simple case right ? We need to recover the database.

[] sqlplus / as sysdba

SQL> RECOVER DATABASE;

ORA-00279: change 1306769 generated at 06/11/2007 11:57:12 needed for thread 1

ORA-00289: suggestion : "/my_path_to/ORACLE_SID/filename.arc"

ORA-00280: change 1306769 for thread 1 is in sequence #2245

SQL>

SQL>

sqlplus / as sysdba

SQL> startup mount;

SQL> alter database datafile "/my_path_to/ORACLE_SID/filename.dbs" offline;

SQL> recover datafile "/my_path_toil/ORACLE_SID/filename.dbs";

ORA-00279: change 1306769 generated at 06/11/2007 12:05:42 needed for thread 1

ORA-00289: suggestion : "/my_path_to/ORACLE_SID/filename.arc"

ORA-00280: change 1306769 for thread 1 is in sequence #2245

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

Log applied.

Media recovery complete.

SQL> alter database datafile "/my_path_to/ORACLE_SID/filename.dbs" online;

SQL> alter database open;