Home » RDBMS Server » Server Administration » REDO log status (oracle9i)
REDO log status [message #321595] Tue, 20 May 2008 15:56 Go to next message
shrinika
Messages: 266
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?
Re: REDO log status [message #321597 is a reply to message #321595] Tue, 20 May 2008 16:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
V$LOG
Re: REDO log status [message #321641 is a reply to message #321597] Tue, 20 May 2008 23:04 Go to previous messageGo to next message
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.
Re: REDO log status [message #321767 is a reply to message #321641] Wed, 21 May 2008 05:09 Go to previous messageGo to next message
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?
Re: REDO log status [message #321817 is a reply to message #321767] Wed, 21 May 2008 07:03 Go to previous message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Thank you every one.
Previous Topic: recreate control file: do i need to create temp file after i mount the database
Next Topic: User script
Goto Forum:
  


Current Time: Tue Dec 06 02:19:33 CST 2016

Total time taken to generate the page: 0.06244 seconds