ORA-00376: ORA-01110: file 7 cannot be read at this time

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

ORA-01110: data file 7: ‘/u02/oradata/UTF/myrio_data02.dbf’

Solution: Follow following steps to get rid off the above error:

SQL> select ONLINE_STATUS from dba_data_files where file_id=7;



ONLINE_
——-
RECOVER


SQL> recover datafile 7;
ORA-00279: change 248540120 generated at 03/13/2012 16:37:56 needed for thread1
ORA-00289: suggestion : /export/home/oracle/archives/UTF/1_3936_761509767.dbf
ORA-00280: change 248540120 for thread 1 is in sequence #3936


Specify log: {=suggested filename AUTO CANCEL}


/export/home/oracle/archives/UTF/1_3936_761509767.dbf
Log applied.


Media recovery complete.

SQL> alter database datafile 7 online;
Database altered.


SQL> select ONLINE_STATUS from dba_data_files where file_id=7;


ONLINE_
——-
ONLINE

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply