rman recovery error
- From: Ram Raman <veeeraman@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Mar 2010 21:41:09 -0600
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.
Other related posts:
