Suresh,

But, I see the status being "ACTIVE" even "after" the file got archived ?
I tried it myself.

-Aliyar Sahib



"Suresh Harvu "
<oracledba-ezmlms
hield-x74599296.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
04/29/2005 09:57
AM Subject
RE: v$log










Status Active is the log that is taken up for Archiving. Once done, it
becomes Inactive. The log that is currently being written to will be shown
as Current. If the archiving has been disabled, then after the log switch,
the status will be active but archived =NO.

-----Original Message-----
From: seramu
[mailto:oracledba-ezmlmshield-x72890296.[Email address protected]
Sent: Friday, April 29, 2005 9:52 AM
To: LazyDBA Discussion
Subject: v$log


Folks,

Question : What's the difference between ( STATUS=ACTIVE, ARCHVIED=YES
) and (STATUS=INACTIVE, ARCHIVED=YES) in the V$LOG view.

I can understand that (status=active, archived=NO) means, file is not
archived yet and needed for instance recovery but, why should it show the
status= "active" when the file was "archived" already.

I am missing something, please clear up my confusion.

-Thanks
Aliyar
DBA, US Census Bureau



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Oracle LazyDBA home page