Home » RDBMS Server » Backup & Recovery » diff. between unarchived and inactive.
diff. between unarchived and inactive. [message #401014] Fri, 01 May 2009 02:00 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Refering to doc. :
Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)
Part Number B14191-02


Loss of Multiple Redo Log Groups
If you have lost multiple groups of the online redo log, then use the recovery method for the most difficult log to recover. The order of difficulty, from most difficult to least difficult, follows:

1.The current online redo log
2.An active online redo log
3.An unarchived online redo log
4.An inactive online redo log


--
Qns : Whats the diff. between unarchived and inactive ?

When would the status be 'unarchived' ? I cant see this status in v$log ?

Report message to a moderator

Re: diff. between unarchived and inactive. [message #401018 is a reply to message #401014] Fri, 01 May 2009 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"unarchived" no more needed for instance recovery, not archived yet.
"inactive" no more needed for instance recovery and archived.

"unarchived" log status is "INACTIVE".

Regards
Michel

Report message to a moderator

Re: diff. between unarchived and inactive. [message #401114 is a reply to message #401018] Fri, 01 May 2009 12:41 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Ok. that answers my question.

INACTIVE - Log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.


Thanks.

Report message to a moderator

Re: diff. between unarchived and inactive. [message #401124 is a reply to message #401114] Fri, 01 May 2009 13:26 Go to previous message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct.

Regards
Michel

Report message to a moderator

Previous Topic: How can I reset the "backup set number" back to 1
Next Topic: cant manually delete a data/log file in windows ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 22:56:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.