How to get archive log file details in Oracle
set linesize 190
col name for a60
col name for a60
SELECT
SEQUENCE#,
NAME,
FIRST_TIME AS "First Timestamp",
COMPLETION_TIME AS "Completion Timestamp",
THREAD#,
ARCHIVED
FROM
V$ARCHIVED_LOG
where name like '%&archive_log_file%'
ORDER BY
FIRST_TIME asc;
SEQUENCE#,
NAME,
FIRST_TIME AS "First Timestamp",
COMPLETION_TIME AS "Completion Timestamp",
THREAD#,
ARCHIVED
FROM
V$ARCHIVED_LOG
where name like '%&archive_log_file%'
ORDER BY
FIRST_TIME asc;
Comments
Post a Comment