Standby Database Init.ora file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Standby Database Init.ora file

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Standby Database Init.ora file

    Hello All,

    While examining the init.ora file of standby database I found following messages.

    Media Recovery Log F:\ARCHIVE\LEGACYT001S61033.ARC
    Media Recovery Waiting for thread 1 seq# 61034
    Sat Feb 22 11:02:34 2003
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61034.ARC
    Media Recovery Waiting for thread 1 seq# 61035
    Sat Feb 22 11:06:33 2003
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61035.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61036.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61037.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61038.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61039.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61040.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61041.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61042.ARC
    Media Recovery Log F:\ARCHIVE\LEGACYT001S61043.ARC
    Media Recovery Waiting for thread 1 seq# 61044
    Sat Feb 22 11:07:29 2003

    Does this mean that logs 61035 to 61043 have not been
    applied to standby database, although they have been
    copied to archive location on standy db.

    If this is the case, then what steps would be required
    to resync the two databases.

    Best Regards,

    Kashif

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    This is your alert log file not init.ora

    Log 35 has been applied and it is waiting for 44 which is has not been applied yet.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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