Redo Log Status and Recovery
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.
well my logic says you can only recover to the archived log before the lost one
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.
Click Here to Expand Forum to Full Width