Redo Log Status and Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Redo Log Status and Recovery

  1. #1
    Join Date
    May 2002
    Posts
    163

    Redo Log Status and Recovery

    Hi all,

    Just to clarify my doubt.

    I have a Log member (only one member in that group) and the status for that member is currently 'INACTIVE' but archive not completed.

    If I loose that member in such scenario, and though that memeber is not needed for instance recovery but needed for media recovery ..... I can drop that log memeber and create a new member.

    Is that right? Any other suggestion or note.

    thanks
    Nwcomer
    Student

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well my logic says you can only recover to the archived log before the lost one

  3. #3
    Join Date
    Feb 2002
    Posts
    70
    How many log groups do you have?
    As you mentioned, one log member per a group, if you drop that log member, you are dropping entire group itself. Where is the question of adding new member.
    ________________
    ShanDJ

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