"Error identifying datafile" after successful recovery from RMAN
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Feb 2005 17:10:57 -0500
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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » "Error identifying datafile" after successful recovery from RMAN