This discussion is archived
9 Replies Latest reply: Aug 29, 2013 7:09 AM by Rocketdog RSS

RMAN controlfile recovery without autobackup

Rocketdog Newbie
Currently Being Moderated


Hi there

 

     I'm trying to restore a customer database from RMAN backups to the same instance name and DBID but a different server with a different directory structure .

 

This is from a full RMAN backup, but the log shows that the controlfile is only backed up via backup current controlfile, not with autobackup.

 

I have built the standard bdump directories and created a datafile directory, amended a copy of the init.ora to reflect the correct locations for the dump file, archive logs and controlfiles and also added in db_file_name_convert and log_file_name_convert params to map from the original directory structure noted in the rman backup to the new locations.

 

I understand you can't restore the controlfile from autobackup but was under the impression that you could set the format and restore the controlfile but am not having any luck with this -

 

[oracle@el64dev03 dbs]$ echo $ORACLE_SID
EUMSIPSP
[oracle@el64dev03 dbs]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Aug 28 16:05:37 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area     524288000 bytes

Fixed Size                     2085256 bytes
Variable Size                285216376 bytes
Database Buffers             230686720 bytes
Redo Buffers                   6299648 bytes

RMAN> set dbid 1887849233;   (this is the backed up database id)

executing command: SET DBID

RMAN> restore controlfile from '/oradata2/10.2.0/CUST-EUMSIPSP/BAK_98723_d3ohkisi.CTL'; (this is the backup piece noted in the RMAN backup)

Starting restore at 28-AUG-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=430 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/28/2013 16:06:24
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> run {
2> allocate channel d1 type disk format '/oradata2/10.2.0/CUST-EUMSIPSP/BAK_%s_%u.CTL';
3> restore controlfile to '/oradata2/10.2.0/EUMSIPSP/' from '/oradata2/10.2.0/CUST-EUMSIPSP/';
4> }

released channel: ORA_DISK_1
allocated channel: d1
channel d1: sid=430 devtype=DISK

Starting restore at 28-AUG-13

released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/28/2013 16:09:01
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> exit

 

RMAN BACKUP log -

...

connected to target database: EUMSIPSP (DBID=1887849233)
using target database control file instead of recovery catalog

RMAN> run {
2> allocate channel d1 type disk;
3> setlimit channel d1 readrate 2000;
4> sql 'alter database backup controlfile to trace';
5> backup
6> filesperset 1
7> format '/oracle/RMAN/eumsipsp/backups/full/BAK_%s_%u.CTL'
8> (current controlfilE);
9> }
10>
allocated channel: d1
channel d1: sid=425 devtype=DISK


sql statement: alter database backup controlfile to trace

Starting backup at 18-AUG-13
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
including current control file in backupset
channel d1: starting piece 1 at 18-AUG-13
channel d1: finished piece 1 at 18-AUG-13
piece handle=/oracle/RMAN/eumsipsp/backups/full/BAK_98723_d3ohkisi.CTL tag=TAG20130818T191425 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-AUG-13
released channel: d1

...

 

Copied Backup files info -

[oracle@el64dev03 CUST-EUMSIPSP]$ pwd

/oradata2/10.2.0/CUST-EUMSIPSP

[oracle@el64dev03 CUST-EUMSIPSP]$ ls -lt *log

-rw-r--r-- 1 oracle oinstall 22139 Aug 23 14:25 rman_full_eumsipsp_20130818190000.log

[oracle@el64dev03 CUST-EUMSIPSP]$ ls -lt *CTL

-rw-r--r-- 1 oracle oinstall 11927552 Aug 28 11:08 BAK_98723_d3ohkisi.CTL

 

Is it possible to recover the controlfile at all (as in a disaster situation) so that the database can then be recovered.

 

Any advice most welcomed

Regards

Lesley

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points