Cannot read datafile after successful recovery
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Feb 2005 21:08:42 -0500
Environment: 9i RAC , 2 Node veritas cluster
One of the datafile got corrupted in test environment and restored
form RMAN backup.
However even after recovery it gave me "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 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=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_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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Cannot read datafile after successful recovery
