Oracle 12cでREDOログファイル情報を取得
環境
Oracle 12c
Windows Server 2012 R2
A5:SQL Mk-2
Oracle 12c
Windows Server 2012 R2
A5:SQL Mk-2
Oracle 12c Windows Server 2012 R2 A5:SQL Mk-2
使用例
SELECT
GROUP#,
TYPE,
MEMBER
FROM
V$LOGFILE
SELECT
GROUP#,
TYPE,
MEMBER
FROM
V$LOGFILE
SELECT GROUP#, TYPE, MEMBER FROM V$LOGFILE
実行結果
GROUP# TYPE MEMBER
1 ONLINE C:\ORACLE\ORADATA\ORCL\REDO01.LOG
2 ONLINE C:\ORACLE\ORADATA\ORCL\REDO02.LOG
3 ONLINE C:\ORACLE\ORADATA\ORCL\REDO03.LOG
GROUP# TYPE MEMBER
1 ONLINE C:\ORACLE\ORADATA\ORCL\REDO01.LOG
2 ONLINE C:\ORACLE\ORADATA\ORCL\REDO02.LOG
3 ONLINE C:\ORACLE\ORADATA\ORCL\REDO03.LOG
GROUP# TYPE MEMBER 1 ONLINE C:\ORACLE\ORADATA\ORCL\REDO01.LOG 2 ONLINE C:\ORACLE\ORADATA\ORCL\REDO02.LOG 3 ONLINE C:\ORACLE\ORADATA\ORCL\REDO03.LOG