64 lines
1.4 KiB
SQL
64 lines
1.4 KiB
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display Online/Standby Redo log members
|
|
* Version :
|
|
* Parameters : None
|
|
*
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 17-AUG-15 Vishal Gupta Skip 1 line on redolog type
|
|
* 14-JUL-14 Vishal Gupta Created
|
|
*
|
|
*
|
|
*/
|
|
|
|
|
|
|
|
/************************************
|
|
* INPUT PARAMETERS
|
|
************************************/
|
|
|
|
|
|
/************************************
|
|
* CONFIGURATION PARAMETERS
|
|
************************************/
|
|
|
|
Prompt
|
|
Prompt ************************
|
|
Prompt * Redologs Information
|
|
Prompt ************************
|
|
|
|
COLUMN type HEADING "Redo|Log|Type" FORMAT a7
|
|
COLUMN group# HEADING "Group#" FORMAT 9999
|
|
COLUMN thread# HEADING "Thread#" FORMAT 9999
|
|
COLUMN status HEADING "Status" FORMAT a10
|
|
COLUMN member HEADING "Member" FORMAT a100
|
|
|
|
BREAK ON type SKIP 1 ON thread# ON group#
|
|
|
|
SELECT 'Online' type
|
|
, l.thread#
|
|
, l.group#
|
|
, l.status
|
|
, f.member
|
|
FROM v$log l
|
|
JOIN v$logfile f ON f.group# = l.group#
|
|
UNION ALL
|
|
SELECT 'Standby' type
|
|
, l.thread#
|
|
, l.group#
|
|
, l.status
|
|
, f.member
|
|
FROM v$standby_log l
|
|
JOIN v$logfile f ON f.group# = l.group#
|
|
ORDER BY type, thread# , group#
|
|
;
|
|
|
|
@@footer
|