Cannot read datafile after successful recovery

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 17 Feb 2005 21:08:42 -0500
Message-ID: <f09dd628050217180866e27ca1@mail.gmail.com>

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.

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

Received on Thu Feb 17 2005 - 21:11:39 CST