RMAN Restore database from different location
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN Restore database from different location

  1. #1
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    RMAN Restore database from different location

    I backup to an nfs share "/rman" and I want to restore on another server with the backup pieces in a different directory "/may09"

    I've tried

    run {
    allocate channel d1 device type disk format '/may09/%d_%u_%p';
    restore database;
    release channel d1;
    }

    But it's still looking for the backup pieces in "/rman"

    I know I can restore archivelogs using
    set archivelog destination to '/may09/archivelogs/MYDB';

    I've scoured the manuals and can't figure out how to set the datafile backup piece source.

    -Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Apr 2009
    Posts
    21
    Can you post your init.ora file and directory location of your backup?
    Last edited by revzalot; 05-28-2009 at 07:36 PM.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Connect to the catalog database and then do

    catalog start with '/may09'

    it should tell RMAN that backup pieces are available in that directory and you want to restore from there

    regards
    Hrishy

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Cool... like a needle in a haystack. Thank you!
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Call it conincidence I might have to do the same thing
    in comming few days :-)

    I am lucky to be on 10.2

    regards
    Hrishy

  6. #6
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool Also...

    The other option is to create a symbolic link:

    Code:
    cd /
    ln -s /rman may09
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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