restore to another machine using bkp files

[Bogey]

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

[mrchrispy]

dead link?

[davey23uk]

dead link?

http://www.orafusion.com/art_rman3.htm

[Bogey]

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.

[serg1257]

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.

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

You should made backup controlfile explicitly by
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.

RMAN> restore controlfile from 'e:\backup\CTL_SP_BAK_C-1507972899-20050228-00';

[Bogey]

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.