Refresh dev database from prod using RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Refresh dev database from prod using RMAN

  1. #1
    Join Date
    Jan 2006
    Posts
    21

    Refresh dev database from prod using RMAN

    I have hotbackups, archivelog backup and controlfile back up from prod using RMAN. On another box I already have a dev instance running of this database. How can I refresh dev database using backup files provided. I do not want to use duplicate command. Please help.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    use the restore command then

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Quote Originally Posted by davey23uk
    use the restore command then
    Or clone it with the duplicate command.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    run {
    startup mount pfile=\INIT.ORA;

    allocate channel ch1 type disk;

    restore database;
    recover database;

    release channel ch1;
    }

    I am assuming you have same partitioning for PROD and DEV databases.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by purirb
    On another box I already have a dev instance running of this database.
    You don't want a new instance, you just want to restore your existing db and start a new instance of it.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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