DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Standby Database

  1. #21
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    It does not need to know which SCN is in which archived log file. All it needs to know is which is the first redo log that has not yet been recorded in one of the database files, but has allready been checkponted in some of the other database files or in the controlfile.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #22
    Join Date
    Nov 2000
    Posts
    212
    "how does Oracle know that certain SCN is in certain archived log therefore it needs the corresponding archived log for recovery" - I guess Oracle knows SCN just by using formula last_scn_from_last_applied_log+1,
    and knows log number just from log_sequence_no_from_last_applied_log+1 (some issues regarding OPS may be here?)

  3. #23
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Why would you want the standby in noarchive?

    Presumptively, it will take over when the primary fails. Won't there be transactions processed by the secondary? If it fails, won't you want the archive logs to recover (assuming the primary is not yet ready?) Depending on the failure mode, won't you need them to bring the primary back up to speed until you switch processing back?
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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