dba_registered_archived_log
The following SQL statement shows the
details:
COLUMN CONSUMER_NAME HEADING 'Capture|Process|Name'
FORMAT A15
COLUMN NAME HEADING 'Archived Redo Log|File
Name' FORMAT A35
COLUMN FIRST_SCN HEADING 'First SCN' FORMAT
99999999999
COLUMN NEXT_SCN HEADING 'Next SCN' FORMAT
99999999999
SELECT r.CONSUMER_NAME, r.NAME,
r.FIRST_SCN, r.NEXT_SCN
FROM DBA_REGISTERED_ARCHIVED_LOG r,
DBA_CAPTURE c
SEE CODE DEPOT FOR FULL SCRIPT
v$database
This view displays information about the
database from the control file. Information such as the last SCN
checkpointed, the number assigned to the database instantiation,
and the highest NEXT_CHANGE# for an archive log is useful.
The following SQL statement shows
information about the current state and current SCN values:
Select 'Database Name : ' || a.NAME ||
chr(10) ||
'Log Mode : '
|| a.LOG_MODE || chr(10) ||
'Last SCN Archived : ' ||
a.ARCHIVE_CHANGE# || chr(10) ||
'Last SCN CheckPointed : ' ||
a.CHECKPOINT_CHANGE# || chr(10) ||
'Current SCN : ' ||
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER() || chr(10) ||
