$ARCHIVE displays information about redo log files in need of archiving. Each row displays information for one thread. This information is also available in V$LOG. Oracle recommends that you use V$LOG.
• GROUP# – Log file group number
• THREAD# – Log file thread number
• SEQUENCE# – Log file sequence number
• ISCURRENT – This is the current online redo log
• CURRENT – This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in ISCURRENT.
• FIRST_CHANGE# – First SCN stored in the current log
• THREAD# – Log file thread number
• SEQUENCE# – Log file sequence number
• ISCURRENT – This is the current online redo log
• CURRENT – This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in ISCURRENT.
• FIRST_CHANGE# – First SCN stored in the current log
SQL> select * from v$archive; |
no rows selected |
0 comments:
Post a Comment