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

    Standby Question

    HI folks,

    If my Primary database happen to crash, and if i have a STANDBY DATABASE setup, is it possible to recover completely.

    Suppose, if i have a 5MB sized online redolog member, and my Primary database crashes, when it was halfway through, what about the commited changes which were present in the online logs, (since it has not been archived). When i activate the standby these changes are not present in the archive. Is it possible to recover these changes as well with the standby setup.


  2. #2
    Join Date
    Dec 2001
    In Oracle9i you can switch the primary server into protected mode which will prevent updates being applied to the primary server until they have been sent to at least one standby location.

    In Oracle8i you can only get as close as the last change that's been posted top the standby.

    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Oct 2000
    If you can atleast mount your primary (depending on the type of DB crash) and swith the logs a couple of times - this should create the archive logs. You can manually transport them on the standby and apply before opening the standby DB.

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.