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

Regards
Michel
Previous Topic: make a copy/backup without setting in hot backup mode. ?
Next Topic: RMAN Slow backup (merged)
Goto Forum:
  


Current Time: Tue Aug 22 02:15:33 CDT 2017

Total time taken to generate the page: 0.01700 seconds