rman recovery error

From: Ram Raman <veeeraman_at_gmail.com>
Date: Tue, 9 Mar 2010 21:41:09 -0600
Message-ID: <effc058d1003091941i39fc780ds4323a0cb4f3b8dac_at_mail.gmail.com>


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

*$ORACLE_HOME/bin/rman <<_EOF_*
*connect target;*

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';

   as compressed backupset
   tag 'bk_f9dmo_$today'

   database plus archivelog delete input ;
sql 'alter system switch logfile';

    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'; }

  • End script

I renamed the directory dec02_2009 to dec02_2009_f9dmo_base_bkup.

Here is the log for the run:

  • Log

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
Recovery Manager complete.
  • ENd Log

I am trying to restore the controlfile and I am getting the following error:

Recovery Manager: Release - 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> restore controlfile from
'/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

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


Received on Tue Mar 09 2010 - 21:41:09 CST

Original text of this message