OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » REDO log status (oracle9i)

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

REDO log status [message #321595]

Tue, 20 May 2008 15:56

shrinika
Messages: 306
Registered: April 2008

Senior Member

Hello,

I have one question in redo log status.

Here are the below valid status?

UNUSED
CURRENT
ACTIVE
CLEARING
CLEARING_CURRENT
INACTIVE

I am not able to understand the difference between ACTIVE & INACTIVE?

Any one can help me on this?

Report message to a moderator

Re: REDO log status [message #321597 is a reply to message #321595]

Tue, 20 May 2008 16:05

ebrian
Messages: 2794
Registered: April 2006

Senior Member

V$LOG

Report message to a moderator

Re: REDO log status [message #321641 is a reply to message #321597]

Tue, 20 May 2008 23:04

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

ACTIVE log are those which are required for recovery while INACTIVW logs are no longer required or needed by oracle for recovery.

Regards.

Report message to a moderator

Re: REDO log status [message #321767 is a reply to message #321641]

Wed, 21 May 2008 05:09

ebrian
Messages: 2794
Registered: April 2006

Senior Member

vithalani_dipali wrote on Wed, 21 May 2008 00:04

ACTIVE log are those which are required for recovery while INACTIVW logs are no longer required or needed by oracle for recovery.

How does this provide any additional information that what is provided in the link above?

Report message to a moderator

Re: REDO log status [message #321817 is a reply to message #321767]

Wed, 21 May 2008 07:03

shrinika
Messages: 306
Registered: April 2008

Senior Member

Thank you every one.

Report message to a moderator

Previous Topic:	recreate control file: do i need to create temp file after i mount the database
Next Topic:	User script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 18:06:40 CDT 2024