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