Rman Restore controlfile without Autobackup on
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman Restore controlfile without Autobackup on

  1. #1
    Join Date
    Jan 2001
    Posts
    15

    Rman Restore controlfile without Autobackup on

    I am trying to restore a test if I don't have autobackup turned on during rman backup to tape. Will I be able to restore the database from rman?

    Backup has been done with regular RMAN backup with default values to tape with veritas netbackup software. Looking at rman output log, it has created backupset file and that included the controlfile.

    RMAN> run {
    2> set controlfile autobackup format for device type 'sbt_type' to '%F';
    3> allocate channel t1 device type 'sbt_tape';
    4> restore controlfile from autobackup;
    5> alter database mount;
    6> }

    executing command: SET CONTROLFILE AUTOBACKUP FORMAT

    allocated channel: t1
    channel t1: sid=379 devtype=SBT_TAPE
    channel t1: Veritas NetBackup for Oracle - Release 6.5 (2008052301)

    Starting restore at 03-JUN-09

    channel t1: looking for autobackup on day: 20090603
    channel t1: looking for autobackup on day: 20090602
    channel t1: looking for autobackup on day: 20090601
    channel t1: looking for autobackup on day: 20090531
    channel t1: looking for autobackup on day: 20090530
    channel t1: looking for autobackup on day: 20090529
    channel t1: looking for autobackup on day: 20090528
    channel t1: no autobackup in 7 days found
    released channel: t1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 06/03/2009 11:58:04
    RMAN-06172: no autobackup found or specified handle is not a valid copy or piece



    I guess, it is looking for autobackup on controlfiles. I have tried with
    restore controlfiles from tag 'backupsettagname' and I was not success..

    Any other idea, I can try or is it not possible to restore the database with that limitation?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    was the control file backed up? if not - make a new one

  3. #3
    Join Date
    Apr 2006
    Posts
    377
    If the log shows which backup piece the controlfile was backed up to, simply do the following:

    Code:
    restore controlfile from '<backup_piece_name>';

  4. #4
    Join Date
    Jan 2001
    Posts
    15
    thanks davey23uk and ebrian for reply.

    restore controlfile from '' worked.

    I used restore controlfile from '/cntrl_29_1_688498299'.

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