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;
Was the file controlprod.ctl generated with RMAN, or is it a simple copy of your production controlfile?
It is a strange name for a file generated by RMAN.
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;
What is your Oracle version?
Oracle Version 18.104.22.168
Could you go on your production system, and run the following
and post the results?
rman target / show all;
My OS Version is Linux blrdlvremoradb01 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
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
Just want to let you know whether I can restore a production database which is in Sun OS to Linux box??
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 22.214.171.124.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;
I have set the DBID and tried to do the restore operation. But the error persists.. Please suggest.
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.
Did you try what Fran has suggested earlier to you?
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.