This content has been marked as final. Show 17 replies
you must be sure that rman knows of this backup.
rman> CATALOG START WITH '/.../..../.../your_full_backup';
rman> list backup summary; --check the backup
rman> restore controlfile from '/orabackup/bkp_030113/controlprod.ctl';
also check and set if needed the correct incarnation
rman> list incarnation;
rman> reset database to incarnation 1;
While taking the backup I have mentioned the control name to be like this.. Please check my below backup script:-
allocate channel t1 type disk;
allocate channel t2 type disk;
allocate channel t3 type disk;
allocate channel t4 type disk;
allocate channel t5 type disk;
backup current controlfile format '/orabackup/bkp_030113/controlprod.ctl';
backup database format '/orabackup/bkp_030113/data_%d_%t_%s.dbf';
backup archivelog all format '/orabackup/bkp_030113/arch_%d_%t_%s.dbf';
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RACDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
I have never tried to restore without autobackup for controlfile, but the documentation says that in that case, you should specify DBID.
You can find DBID when you connect to your production database with RMAN. It should display something like that :
Then on your dev system, in RMAN, you type (replace 12345678 with your DBID, of course) :
Recovery Manager: Release 188.8.131.52.0 - Production on Ven. Janv. 4 11:56:20 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connectected to target database : XXXXXX (DBID=12345678)
Then try your restore command.
set DBID 12345678;
If the OS are not the same between dev and prod system, I think this is the cause of your error.
RMAN provides some CONVERT function, however. I have never used them, but here is the link to the documentation :
Hope it will help.
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceCan you check the permission of the backup file after you moved from production to development box?
$ls -ltr /orabackup/bkp_030113/controlprod.ctlAnd ensure you set DBID of production database.
BTW, FRA is configured?
As work around you can try disable and after successful restore, Again you can enable FRA.