DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Recover OS Backup to standby instance w/o archive logs

  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Recover OS Backup to standby instance w/o archive logs

    We do a cold backup of our production database. Because the 'important' data is entirely replaced nightly by importing from our legacy appliction management has decided that it's OK to run in NOARCHIVELOG mode.

    Now they want me to load a backup into a different instance so I can generate some reports using old data. (OK, using historic data sounds better but it's the same thing.)

    I created the instance & made sure it ran OK, then I restored the data files, control files, and redo logs to the new location. When I tried to reopen the database it complained that the name didn't match.

    I changed the name using CREATE CONTROLFILES & now it says that the System datafile needs recovery-but when I try that it asks for an archive log which, of course, isn't available.

    No activity occurs in the database for about 6 hours prior to the backup so I'm sure that the data doesn't need recovery-it's just the checkpoints.

    Any suggestions?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You cloned the database wrong. Don't create a new instance. Take the parameter files, and datafiles from the "old" database and copy them to a new location. Re-create the control files and rename the database at the same time with a create crontrolfile script and open with reset logs. Search metalink for "clone" for step-by-step directions.
    Jeff Hunter

  3. #3
    Join Date
    Feb 2004
    Posts
    6
    I did search Metalink but it helps to know the proper terms. Didn't think to search under clone. Thanks.

  4. #4
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    CREATE CONTROLFILE SET DATABASE "MYDB" RESETLOGS NOARCHIVELOG
    ....
    ....
    The man called Zorro

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