|
Explanation: You must query the V$LOG dynamic performance view to obtain information about the online CURRENT redo log group. The relevant column of the view are GROUP#, THREAD#, SEQUENCE#, and STATUS. Reference: Oracle 9i Net Services Administrator’s Guide Oracle 9i Net Services Reference Guide Oracle 9i Recovery Manager Reference Oracle 9i Backup and Recovery Concepts
|