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 ?

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: 64132
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
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.
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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct.

Regards
Michel
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:
  


Current Time: Thu Dec 08 00:19:44 CST 2016

Total time taken to generate the page: 0.11987 seconds