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