Printable View
I'm planning on disaster recovery and I'm trying to follow the article on www.orafusion.com/art_man3.htm.
I've gotten everything to work except when I issue the restore database all the I get back is
RMAN-06023: no backup or copy of datafile [#] found to restore
dead link?
http://www.orafusion.com/art_rman3.htmQuote:
Originally Posted by mrchrispy
What I'm trying to do, and I asked this about two months ago, is to reenact what would happen if I totally lost my production machine and the only thing that I have are the Backup Sets.
I have two backup sets. One contains my spfile and control file, the other contains all my datafiles.
I've followed the directions on the http://orafusion.com/art_rman3.htm and everything works until I try to do a restore.
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ========
RMAN-00571: ====================================================
RMAN-03002: failure of restore command at 10/25/2005 16:08:52
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
What am I doing wrong here?
thanks.
Hi all.
It looks like you not turn CONTROLFILE AUTOBACKUP ON.
You're trying to restore controlfile stored with system datafile. This controlfile have no idea of other datafiles' backup.
You should made backup controlfile explicitly byQuote:
RMAN> show all;
using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:\backup\ctl_sp_bak_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'e:\backup\%U.bak' MAXPIECESIZE 4G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'e:\backup\%U.bak' MAXPIECESIZE 4G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFORCL.ORA'; # default
backup current controlfile to '..'
or set up CONTROLFILE AUTOBACKUP ON (preferred)
Having autobackup on will let you get a controlfile (and spfile) backup after
1 backup of any datafile
2 add datafile
And in addition to article
After
set dbid 1507972899
I would
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:\backup\ctl_sp_bak_%F';
so having dbid and AUTOBACKUP FORMAT RMAN could find latest autobackup. and not mention explicit filename.
Quote:
RMAN> restore controlfile from 'e:\backup\CTL_SP_BAK_C-1507972899-20050228-00';
I got it to work the following way.
Did my restore spfile and control file from my autobackup folder.
Is their an easier way of doing this when all you have are your backups from production?
Thanks.