Skip to content

Instantly share code, notes, and snippets.

@ArtDu

ArtDu/select.sql

Created December 29, 2025 15:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ArtDu/0938b018d9c96cd34af4695a4dc9ea87 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ArtDu/0938b018d9c96cd34af4695a4dc9ea87 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle DB select archive and online log files
Raw
select.sql
SELECT 'ONLINELOG' AS LOG_TYPE, GROUP# AS GROUP_OR_SEQUENCE, MEMBER AS FILE_NAME
FROM V$LOGFILE
WHERE MEMBER LIKE '+%'
UNION ALL
SELECT 'ARCHIVELOG' AS LOG_TYPE, SEQUENCE# AS GROUP_OR_SEQUENCE, NAME AS FILE_NAME
FROM V$ARCHIVED_LOG
WHERE NAME LIKE '+%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment