Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> "Error identifying datafile" after successful recovery from RMAN

"Error identifying datafile" after successful recovery from RMAN

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 17 Feb 2005 17:10:57 -0500
Message-ID: <f09dd628050217141078627d97@mail.gmail.com> 





Environment: 9i RAC , 2 Node veritas cluster



One of the datafile got corrupted and restored form RMAN backup.
However even after recovery


I used to get "ORA-01187: cannot read from file 7 because it failed
verification tests"



Then I did log switch few times, then it started working.
What could be wrong here?



Thanks in advance.



RMAN> recover database;
 


Starting recover at 17-FEB-05


allocated channel: ORA_DISK_1


channel ORA_DISK_1: sid=26 devtype=DISK


datafile 11 not processed because file is offline

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================


RMAN-03002: failure of recover command at 02/17/2005 16:55:15
RMAN-06094: datafile 7 must be restored
 


RMAN> restore datafile 7;
 


Starting restore at 17-FEB-05
 


using channel ORA_DISK_1


channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /u04/oradata/testa/test02.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/u04/rman/04gd0ac6_1_1 tag=TAG20050217T161710 params=NULL
channel ORA_DISK_1: restore complete


Finished restore at 17-FEB-05
 


RMAN> recover datafile 7;
 


Starting recover at 17-FEB-05


using channel ORA_DISK_1
 


starting media recovery
 


archive log thread 2 sequence 26 is already on disk as file


/u04/archive/2_26.dbf



archive log thread 1 sequence 68 is already on disk as file


/u04/archive/1_68.dbf



archive log thread 2 sequence 27 is already on disk as file


/u04/archive/2_27.dbf



archive log thread 2 sequence 28 is already on disk as file


/u04/archive/2_28.dbf



archive log thread 2 sequence 29 is already on disk as file


/u04/archive/2_29.dbf



archive log thread 1 sequence 69 is already on disk as file


/u04/archive/1_69.dbf



archive log thread 2 sequence 30 is already on disk as file


/u04/archive/2_30.dbf



archive log thread 2 sequence 31 is already on disk as file


/u04/archive/2_31.dbf



archive log thread 2 sequence 32 is already on disk as file


/u04/archive/2_32.dbf



archive log thread 1 sequence 70 is already on disk as file


/u04/archive/1_70.dbf



archive log thread 2 sequence 33 is already on disk as file


/u04/archive/2_33.dbf



archive log thread 2 sequence 34 is already on disk as file


/u04/archive/2_34.dbf



archive log thread 2 sequence 35 is already on disk as file


/u04/archive/2_35.dbf



archive log thread 1 sequence 71 is already on disk as file


/u04/archive/1_71.dbf



archive log thread 2 sequence 36 is already on disk as file


/u04/archive/2_36.dbf



archive log thread 2 sequence 37 is already on disk as file


/u04/archive/2_37.dbf



channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=63


channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=21


channel ORA_DISK_1: restored backup piece 1
piece handle=/u04/rman/05gd0ap7_1_1 tag=TAG20050217T162407 params=NULL
channel ORA_DISK_1: restore complete


archive log filename=/u04/archive/2_21.dbf thread=2 sequence=21
archive log filename=/u04/archive/1_63.dbf thread=1 sequence=63
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=22


channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=64


channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=65


channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=66


channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=23


channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=67


channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=24


channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=25


channel ORA_DISK_1: restored backup piece 1
piece handle=/u04/rman/06gd0bn3_1_1 tag=TAG20050217T164002 params=NULL
channel ORA_DISK_1: restore complete

archive log filename=/u04/archive/2_22.dbf thread=2 sequence=22
archive log filename=/u04/archive/1_64.dbf thread=1 sequence=64
archive log filename=/u04/archive/1_65.dbf thread=1 sequence=65
archive log filename=/u04/archive/1_66.dbf thread=1 sequence=66
archive log filename=/u04/archive/2_23.dbf thread=2 sequence=23
archive log filename=/u04/archive/1_67.dbf thread=1 sequence=67
archive log filename=/u04/archive/2_24.dbf thread=2 sequence=24
archive log filename=/u04/archive/2_25.dbf thread=2 sequence=25
archive log filename=/u04/archive/2_26.dbf thread=2 sequence=26
archive log filename=/u04/archive/1_68.dbf thread=1 sequence=68
archive log filename=/u04/archive/2_27.dbf thread=2 sequence=27
archive log filename=/u04/archive/2_28.dbf thread=2 sequence=28
archive log filename=/u04/archive/2_29.dbf thread=2 sequence=29
archive log filename=/u04/archive/1_69.dbf thread=1 sequence=69
archive log filename=/u04/archive/2_30.dbf thread=2 sequence=30
archive log filename=/u04/archive/2_31.dbf thread=2 sequence=31
archive log filename=/u04/archive/2_32.dbf thread=2 sequence=32
archive log filename=/u04/archive/2_33.dbf thread=2 sequence=33
archive log filename=/u04/archive/2_34.dbf thread=2 sequence=34
archive log filename=/u04/archive/2_35.dbf thread=2 sequence=35


media recovery complete


Finished recover at 17-FEB-05
 


RMAN> sql 'alter tablespace test2 online';
 


sql statement: alter tablespace test2 online
 


RMAN> exit
 
 


Recovery Manager complete.
 


njtstdsmdbc02 oracle testa2 /u04/oradata/testa
$ sqlplus usssd429               
 


SQL*Plus: Release 9.2.0.6.0 - Production on Thu Feb 17 16:58:16 2005
 


Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 


Enter password: 
 


Connected to:


Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data
Mining options


JServer Release 9.2.0.6.0 - Production
 


SQL>  select counT(*) from test2;


 select counT(*) from test2

                      *




ERROR at line 1:


ORA-01187: cannot read from file 7 because it failed verification tests
ORA-01110: data file 7: '/u04/oradata/testa/test02.dbf'




SQL> 



SQL> alter system switch logfile;
 


System altered.
 


SQL> /

 
System altered.
 


SQL> /

 
System altered.
 


SQL> /

 
System altered.
 


SQL>  alter tablespace test2 offline;
 


Tablespace altered.
 


SQL> alter tablespace test2 online;
 


Tablespace altered.
 


SQL>  select counT(*) from usssd429.test2;
 


  COUNT(*)





   6595584
 


SQL>


--
http://www.freelists.org/webpage/oracle-l


Received on Thu Feb 17 2005 - 17:14:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US