This discussion is archived
5 Replies Latest reply: Feb 12, 2013 9:41 AM by 880697 RSS

How to restore database using RMAN

880697 Newbie
Currently Being Moderated
Dear DBA,

I have copied RMAN full backup copy from PROD server mount point /rmanbackup to TEST server mount point /backup. Is it possible to restore the database with the full backup copy on test server using RMAN ?



Note : I dont want to mount PROD Mount point here in test server. Because the restore will happen using network bandwidth. so restore will happen slowly.
  • 1. Re: How to restore database using RMAN
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,

    I am not sure about the database version you are using.
    If on 10g or above, then refer this http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/

    If on 11g and want to make use of the feature available in 11g, then refer this http://shivanandarao.wordpress.com/2012/04/28/duplicating-database-without-connecting-to-target-database-or-catalog-database-in-oracle-11g/


    Regards,
    Shivananda
  • 2. Re: How to restore database using RMAN
    880697 Newbie
    Currently Being Moderated
    Hi Shiv,

    Thank you! The duplicatling database post in your blog is very useful. But i renamed the mount point name as /rmanbackup like in PROD server and copied the PROD Rman backup to test server & restored the database.

    Keep writing replies in OTN forum.

    Thanks
    DBA
  • 3. Re: How to restore database using RMAN
    mseberg Guru
    Currently Being Moderated
    Hello;

    This is not an exact match :

    http://www.visi.com/~mseberg/rman/restore_database_without_catalog.html

    However with some minor changes it will work for you.

    Best Regards

    mseberg
  • 4. Re: How to restore database using RMAN
    vlethakula Expert
    Currently Being Moderated
    Scenario is like rman disk to disk cloning.

    summary of steps:

    1)Prepare pfile for target database and start in nomount mode

    2) Restore controlfile from backuppiece present in /rmanbackup

    rman target /

    run
    {
    restore controlfile from '<backuppiece name in /rmanbackup where controlfile is present-----give full path>'
    }

    3)catalog all the backup pieces using CATALOG START WITH '/rmanbackup/*';

    This command will register the new location of backup in CF as /rmanbackup

    4) rman target /

    run
    {
    restore database;
    recover database;
    }

    5)Open the database and rename if you want using NID
  • 5. Re: How to restore database using RMAN
    880697 Newbie
    Currently Being Moderated
    Hi All,

    Already I started the restore process as you mentioned.

    Actually our restoration process is taking more than 10hours. Our DB size is 1.3 TB,
    We have allocated 50 channels in RMAN & restoring.

    RMAN 12 GB
    6cpus.

    Now My question is how to reduce restoration time? It is killing one full day for cloning.


    Thanks
    DBA

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points