Home » RDBMS Server » Server Administration » the status of the online logfile
the status of the online logfile [message #571287] Fri, 23 November 2012 00:35 Go to next message
Messages: 97
Registered: August 2011
Location: shenzhen,China
in the documents , about the v$log , the following :

V$LOG displays log file information from the control file.
STATUS VARCHAR2(16) Log status: 
      ACTIVE - Log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived.

above , i have some confuse about this statement " It may or may not be archived". Can U tell me ,in this statement "when the log can be archived ,when it can't be archived ."

Re: the status of the online logfile [message #571291 is a reply to message #571287] Fri, 23 November 2012 01:21 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is archived (assuming you are in archived log mode) as soon as the archiver is started and has completed archiving the previous logs.

Previous Topic: Unable To Connect to Oracle 11g EM
Next Topic: Exchange Partition issue
Goto Forum:

Current Time: Mon Jul 24 14:16:50 CDT 2017

Total time taken to generate the page: 0.22533 seconds