ora-00376: FILE n can’t be read at this time

I was not lucky these days, got following error when trying to logon one of my database,

—————–
ora-00604: error occurred AT recursive SQL LEVEL 1
ora-00376: FILE 7 can’t be read at this time
ora-01110: data FILE 7: ‘G:\ORACLE\ORADATA\RPT03T\RPT03T_AUDIT_DATA01.DBF’
ora-02002: error WHILE writing TO AUDIT trail
ora-00604: error occurred AT recursive SQL LEVEL 1
ora-00376: FILE 7 can’t be read at this time
ora-01110: data FILE 7: ‘G:\ORACLE\ORADATA\RPT03T\RPT03T_AUDIT_DATA01.DBF’
—————–

and I suddenly recalled, I got an email from North Amrican counterpart DBA that driver G: on our database server was crashed last night. so I guess that’s the root cause, but right now I need to find a solution to fix it.

Here are my steps, just keep it for further reference,

Step 1.  check which files need recovery
Select * FROM v$recover_file;

select file#,status from v$datafile where stauts=’RECOVER’;

Step 2: My datafiles are still there, i don’t need to restore my datafile from TSM or other backup tools, i can just perform recover,

Alter DATABASE DATAFILE 7 OFFLINE;

recover   datafile   7;

Alter DATABASE DATAFILE 7 ONLINE;

the result likes,
—————————
SYS@rpt03t>Alter DATABASE DATAFILE 7 OFFLINE;

Database altered.

SYS@rpt03t>recover   datafile   7;
Media recovery complete.
SYS@rpt03t>Alter DATABASE DATAFILE 7 ONLINE;

Database altered.
—————————

and query v$recover_file again, you will find the datafile you recovered just now disappear in this dictionary. that means the datafile was recovered successfully.

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>