Home » RDBMS Server » Server Administration » v$log: status : ACTIVE ?
v$log: status : ACTIVE ? [message #369269] Fri, 28 July 2000 17:17 Go to next message
Rick
Messages: 49
Registered: March 2000
Member
what does it mean when the status shows 'ACTIVE' in v$log ? does it mean that it's being archived ?

how long does it normally take for a redo log file to change its status from ACTIVE to INACTIVE ?

Will Oracle be less recoverable if something goes wrong during this process and needs to be recovered ?

thanks.
Re: v$log: status : ACTIVE ? [message #369273 is a reply to message #369269] Mon, 31 July 2000 07:33 Go to previous messageGo to next message
lienad
Messages: 2
Registered: July 2000
Junior Member
rick,
that means the online redo log is the current active redo log being used by the transaction, once the redo is filled it will shift automatically to the next available redo log. and it will change to inactive. Regarding the time for changing from active to inactive depends on the size(bytes) of the redo log and the transaction w/c is in process.

hope this will help.......

daniel(bouger)
Re: v$log: status : ACTIVE ? [message #369274 is a reply to message #369269] Mon, 31 July 2000 07:43 Go to previous message
d0dger
Messages: 7
Registered: July 2000
Location: South Dakota
Junior Member
Active indicates the online redo log group is active but is not the current online redo log group. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived.

Current indicates the current online redo log group. This implies that the online redo log group is active.

Inactive indicates that the online redo log group is no longer needed for instance recovery. It may or may not be archived.

This is from the Oracle Education Architecture and Administration Student Guide.
Previous Topic: How can i create a Autonumber ?
Next Topic: I can't insert CLOB data large than 4k.
Goto Forum:
  


Current Time: Sat Oct 24 04:43:01 CDT 2020