Ref:( Refreshing Dev with RMAN Cold Backup)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Ref:( Refreshing Dev with RMAN Cold Backup)

  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45

    Ref:( Refreshing Dev with RMAN Cold Backup)

    Hi,

    Could some guide me how to refresh development database with production database cold backup which was done by RMAN.

    I have done following things,

    I have used the following script to take the cold backup of production database.

    run { allocate channel c1 type disk format '/backup/u00/oracle/prod/df_%d_%p_%c'; backup (database); sql 'alter database open'; release channel c1; }

    Developemnt database has the same directory structure as production except init.ora parameters.

    It would be help full if some one give me the script or steps.


    Cheers,

  2. #2
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45
    Can any one reply to above queries please.

    Thanks,

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no, spammer

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by atkinson
    Can any one reply to above queries please.

    Thanks,
    If you have heard the concept of auxiliary databases then read this...

    http://metalink.oracle.com/metalink/...T&p_id=73912.1

    Else RTFM...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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