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


connect to Oracle AS SYSDBA
sqlplus / as sysdba


SQL> select * from v$recover_file;

 FILE# status
 43 OFFLINE
SQL> recover datafile 43;

 ORA-00279: change 271477927444 generated at 15/11/2013 10:30:46 needed for thread 1
 ORA-00289: suggestion : /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arcORA-00280: change 271477927444 for thread 1 is in sequence #170675
 Specify log: {=suggested filename AUTO CANCEL}
 AUTO 
 ORA-00308: cannot open archived log '/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc'
 ORA-27037: unable to obtain file status
 SVR4 Error: 2: No such file or directory Additional information: 3
 ORA-00308: cannot open archived log '/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc'ORA-27037: unable to obtain file status
 SVR4Error: 2: No such file or directory Additional information: 3

RMAN will need to load the necessary archivelog s back to the disk from tape

ls /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc
/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc:
 No such file or directory

Connect to rman

rman target /
restore archivelog from logseq 170674 until logseq 170679 ;

 
RMAN
 connect target
 connect anat
 run {
 set command id to "an1";5>
 allocate channel t1 type 'SBT_TAPE'6>
 restore archivelog from logseq 170674 until logseq 170679 ;7> }
connected to target database: ANARTEST (DBID=37.................)connected to recovery catalog databaseexecuting command: SET COMMAND IDallocated channel: t1channel t1: sid=3.. devtype=SBT_TAPEchannel t1:
 NMO v4.2.0.0Starting restore at 15-OCT-13channel t1: starting archive log restore to default destinationchannel t1:
 restoring archive logarchive log thread=1 sequence=170674channel t1: reading from backup piece ANARTEST_arch_ANARTEST_113898_7alsl5l9_1_1channel t1: restored backup piece 1piece handle=ANARTEST_arch_ANARTEST_113898_7alsl5l9_1_1 tag=TAG20101110T103208channel t1: restore complete, elapsed time: 00:00:36channel t1: starting archive log restore to default destinationchannel t1:
 restoring archive logarchive log thread=1 sequence=170675channel t1: reading from backup piece ANARTEST_arch_ANARTEST_113899_7blsl94v_1_1channel t1: restored backup piece 1piece handle=ANARTEST_arch_ANARTEST_113899_7blsl94v_1_1 tag=TAG20101110T113143channel t1: restore complete,
 elapsed time: 00:00:15channel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=170676channel t1:
 restoring archive logarchive log thread=1 sequence=170677channel t1: reading from backup piece ANARTEST_arch_ANARTEST_113900_7clslcn5_1_1channel t1: restored backup piece 1piece handle=ANARTEST_arch_ANARTEST_113900_7clslcn5_1_1 tag=TAG20101110T123236channel t1:
 restore complete, elapsed time: 00:00:16
 Finished restore at 15-OCT-13released channel: t1
 Recovery Manager complete.


sqlplus / as sysdba

SQL> recover datafile 43;
ORA-00279: change 271477927444 generated at 15/11/2013 10:30:46 needed forthread 1
 ORA-00289: suggestion:/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc
 ORA-00280: change 271477927444 for thread 1 is in sequence #170675
 Specify log: {=suggested filename AUTO CANCEL}
 AUTO
 ORA-00279: change 271486453883 generated at 15/11/2013 11:30:39 needed forthread 1
 ORA-00289: suggestion :/export/a01/oradata/ANARTEST/arch/arch_1_170676_526120954.arc
 ORA-00280: change 271486453883 for thread 1 is in sequence #170676
 ORA-00278: log file'/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc' no longerneeded for this recovery
 Log applied.
 Media recovery complete.


SQL> select * from v$recover_file;
 no rows selected

Datafile to bring online:
SQL> select file#,name,status from v$datafile where file# =43;

 FILE# NAME STATUS
 43 /export/c4054/oradata/ANARTEST/indx06.dbf OFFLINE

SQL> alter database datafile 43 ONLINE;
 Database altered.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: