Hi, I am trying to recover a database from an RMAN backup in 10R2 with 2n RAC. The backup was taken few months ago and it went well. This is the backup script: --------------------- Begin script ------------------------------------ *export ORACLE_SID=f9dmo1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib* *today=$1* *$ORACLE_HOME/bin/rman <<_EOF_* *connect target;* *run { CONFIGURE DEVICE TYPE DISK PARALLELISM 2; allocate channel ch1 device type disk maxpiecesize 8G; allocate channel ch2 device type disk maxpiecesize 8G; configure CHANNEL device type 'SBT_TAPE' clear; sql 'alter system switch logfile'; backup as compressed backupset tag 'bk_f9dmo_$today' format '/psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009/%d_%I_%T_%U' database plus archivelog delete input ; sql 'alter system switch logfile'; backup tag 'f9dmo_ctrl_$today' current controlfile format '/psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009/bk_f9dmo_ctrl_$today'; backup as copy not backed up archivelog all format '/psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009/arc_cp_%d_%I_seq_%e'; } exit* *_EOF_** * ------------------------------------------------ End script ----------------------------------------------------------------- I renamed the directory dec02_2009 to dec02_2009_f9dmo_base_bkup. Here is the log for the run: ---------------------------------------------------- Log ------------------------------------------------------------- RMAN> connected to target database: F9DMO (DBID=306294986) RMAN> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> using target database control file instead of recovery catalog old RMAN configuration parameters are successfully deleted .. .... ... input datafile fno=00142 name=+FORUPGRD/f9dmo/datafile/psindex.dbf input datafile fno=00056 name=+FORUPGRD/f9dmo/datafile/eoecwrk.dbf input datafile fno=00104 name=+FORUPGRD/f9dmo/datafile/htapp.dbf .. ... sql statement: alter system switch logfile Starting backup at 02-DEC-09 channel ch1: starting full datafile backupset channel ch1: specifying datafile(s) in backupset including current control file in backupset channel ch1: starting piece 1 at 02-DEC-09 channel ch1: finished piece 1 at 02-DEC-09 piece handle=/psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009/ bk_f9dmo_ctrl_02_Dec_09.11:53 tag=F9DMO_CTRL_02_DEC_09.11:53 c omment=NONE channel ch1: backup set complete, elapsed time: 00:00:01 Finished backup at 02-DEC-09 Starting backup at 02-DEC-09 ... ... Finished backup at 02-DEC-09 released channel: ch1 released channel: ch2 RMAN> Recovery Manager complete. ------------------------------------------------------ ENd Log ------------------------------------------------------------------------ I am trying to restore the controlfile and I am getting the following error: Recovery Manager: Release 10.2.0.4.0 - Production on Tue Mar 9 21:32:18 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> set DBID=306294986; executing command: SET DBID RMAN> connect target / connected to target database (not started) RMAN> startup nomount pfile='$ORACLE_HOME/dbs/initf9dmo.ora'; <-- Had an old copy Oracle instance started Total System Global Area 171966464 bytes Fixed Size 2082600 bytes Variable Size 113248472 bytes Database Buffers 50331648 bytes Redo Buffers 6303744 bytes RMAN> RMAN> RMAN> restore controlfile from 2> '/psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009_f9dmo_base_bkup/bk_f9dmo_ctrl_02_Dec_09.11:53'; Starting restore at 09-MAR-10 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=208 devtype=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/09/2010 21:35:23 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece RMAN> --------------------------------------------------------------------------------------------------------------------- The controlfile backup looks like a valid piece to me: server:/home/oracle $ ls -ltr /psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009_f9dmo_base_bkup/bk_f9dmo_ctrl_02_Dec_09.11> -rw-rw---- 1 oracle oinstall 11403264 Dec 02 11:58 /psoft/u02/oracle10g/cds/f9upgrd/f9dmo/backup/dec02_2009_f9dmo_base_bkup/b k_f9dmo_ctrl_02_Dec_09.11:53 Thanks.