DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Create TEST Database Using Hot Backup and Archive Logs

    What I am trying to accomplish is to create a TEST database on a different server. This TEST database will be a copy of the PROD database, which is in ARCHIVE log mode. We don't shutdown the PROD database to take a backup so we do a HOT backup.

    My question is what are the steps to create this TEST database? I have done the same for other databases but when I have a cold backup of a database, I don't run into the 'media needs recovery" error message when attempting to open the database.

    This is what I have done so far:

    1) Copy over all of the.dbf files from the PROD database HOT backup to the TEST server.
    2) Copy over the init.ora file and made necessary changes to the pathing.
    3) Installed Oracle binary (Oracle8i on TEST server and applied the same patch as in the PROD database.
    4) Recreate the controlfiles, which was successful.
    5) When I attempt to open the database, I get an error saying that the system_s01.dbf needs media recovery.

    What should I do? Do I need to copy over the archive files when we did the HOT backup. I still have them.

    Please help!

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    You should also move the archive logs that have been generated during the hot backup (the archive logs which contain the redo information from the moment you've put the first tablespace into backup mode until the moment you've put the last tablespace back in normal mode). Then you would need to create an incomplete recovery and open the database with resetlogs option.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.