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

2 comments

  1. What’s Happening i’m new to this, I stumbled upon this I’ve found It positively helpful and it has helped me out loads.
    I hope to contribute & assist different users like its aided
    me. Good job.

  2. i exec in sys prompt insert into scott.salgrade select * from scott.salgrade;
    get ora000376 how to solve this bug

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: