Standby database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Standby database

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    I start my standby database as read only.
    Now i want to restart the recovery process on my standby database.
    How can i do it??
    Should i manually copy the archivelog on the standby database??

    Thank's in advance

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The following steps should resolve the problem:

    * copy any missing archive logs over manaually.
    * Mount the database in standby mode.
    * Issue the 'recover standby database' to allow the archive logs to be applied.
    * Once the archive logs have been applied issue 'recover managed standby database'

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Thank's Jim

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    Is it necessary to copy manually the archived redo log file to standby database from primary DB to continue the recover process?
    Is SQL>recover managed standby database not enough to
    make automatically the missing arch logfile on Stdby DB?

  5. #5
    Join Date
    Mar 2002
    Posts
    301

    Question

    It's necessary to copy manually the archived log files from primary to standby DB after disabling READ ONLY STBY DB??

    Thank's in advance!

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