restore to another machine using bkp files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: restore to another machine using bkp files

  1. #1
    Join Date
    Jul 2005
    Posts
    43

    restore to another machine using bkp files

    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

  2. #2
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    dead link?

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by mrchrispy
    dead link?
    http://www.orafusion.com/art_rman3.htm

  4. #4
    Join Date
    Jul 2005
    Posts
    43
    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.

  5. #5
    Join Date
    Oct 2005
    Posts
    10
    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';

  6. #6
    Join Date
    Jul 2005
    Posts
    43
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width