rman recovery error
Date: Tue, 9 Mar 2010 21:41:09 -0600
Message-ID: <effc058d1003091941i39fc780ds4323a0cb4f3b8dac_at_mail.gmail.com>
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.dbfinput 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 09 2010 - 21:41:09 CST