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

Thread: Applying Archive Log Files of OPS Database

  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Question

    i have OPS installed. i have taken backup of Datafile,Control Files, Redo Log Files and Archive Files.
    On a seprate machine i restore all files and open the database in single instance mode. Then i want to apply the Archive Files of OPS database to restored database from the date the backup was taken.
    first it ask for thread 1 (instance 1) archive file and apply it but when it ask for thread 2 (instance 2) archive file it gives an internal error.
    i use recover database using backup controlfile command to apply archive log files.
    can anybody pull me out of this issue and guide me the steps to apply archive log files in such a environment.





  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Basically in OPS ,each node generates its own redo.First u have to restore all the datafiles,control-files and then u restore all the redo-logs from your backup into each node archive destination.Then on each node you mount the database and then give the restore database command on each node.Okay before doing this can u tell me the error which it throws.Waiting for u to update this issue.

    Regards,
    ROhit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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