| v$log: status : ACTIVE ? [message #369269] |
Fri, 28 July 2000 17:17  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
