Oracle 12cでREDOログファイル情報を取得

2021年11月11日

環境

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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

使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
GROUP#,
TYPE,
MEMBER
FROM
V$LOGFILE
SELECT GROUP#, TYPE, MEMBER FROM V$LOGFILE
SELECT
  GROUP#,
  TYPE,
  MEMBER
FROM
  V$LOGFILE

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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

 

Oracle 12c

Posted by arkgame