OraFAQ Forum: Server Administration » the status of the online logfile

Home » RDBMS Server » Server Administration » the status of the online logfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

the status of the online logfile [message #571287]

Fri, 23 November 2012 00:35

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

in the documents , about the v$log , the following :


V$LOG
 
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 ."

Report message to a moderator

Re: the status of the online logfile [message #571291 is a reply to message #571287]

Fri, 23 November 2012 01:21

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:30:33 CST 2025