RAC to single instance Data Guard Physical Standby | Sayfa 3

DataGuard durumunu kontrol etmek için sorgular

Primary

select sequence#, first_time, next_time
from v$archived_log order by sequence#;

1 2	select sequence#, first_time, next_time from v$archived_log order by sequence#;

Standby

select thread#,sequence#,applied from v$archived_log;

1	select thread#,sequence#,applied from v$archived_log;

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE
ARCH.THREAD# = APPL.THREAD#
ORDER BY 1;

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"

FROM

(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,

(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL

WHERE

ARCH.THREAD# = APPL.THREAD#

ORDER BY 1;

select max(sequence#) as STANDBY,applied from v$archived_log group by applied ;

1	select max(sequence#) as STANDBY,applied from v$archived_log group by applied ;

SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID=2;

1	SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID=2;

Select process,status from v$managed_standby;

1	Select process,status from v$managed_standby;

SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

1	SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

SELECT MESSAGE FROM V$DATAGUARD_STATUS;

1	SELECT MESSAGE FROM V$DATAGUARD_STATUS;

select sequence#, first_time, next_time from v$archived_log order by sequence#;

1	select sequence#, first_time, next_time from v$archived_log order by sequence#;

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';
SELECT sequence#, first_time, next_time, applied
FROM v$archived_log
ORDER BY sequence#;

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

SELECT sequence#, first_time, next_time, applied

FROM v$archived_log

ORDER BY sequence#;

SELECT THREAD#, SEQUENCE#, APPLIED,
TO_CHAR(FIRST_TIME, 'MM/DD/YY HH24:MI:SS') FIRST,
TO_CHAR(NEXT_TIME, 'MM/DD/YY HH24:MI:SS') NEXT,
TO_CHAR(COMPLETION_TIME, 'MM/DD/YY HH24:MI:SS') COMPLETION
FROM V$ARCHIVED_LOG ORDER BY FIRST_TIME

SELECT THREAD#, SEQUENCE#, APPLIED,

TO_CHAR(FIRST_TIME, 'MM/DD/YY HH24:MI:SS') FIRST,

TO_CHAR(NEXT_TIME, 'MM/DD/YY HH24:MI:SS') NEXT,

TO_CHAR(COMPLETION_TIME, 'MM/DD/YY HH24:MI:SS') COMPLETION

FROM V$ARCHIVED_LOG ORDER BY FIRST_TIME

Arşivlenmiş (archived) son redologları görmek için

SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;

1	SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;

col DESTINATION format a40;
col status format a40;
col ARCHIVED_THREAD# format 999999;
col ARCHIVED_SEQ# format 9999;
SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# -
FROM V$ARCHIVE_DEST_STATUS -
WHERE STATUS &lt;&gt; 'DEFERRED' AND STATUS &lt;&gt; 'INACTIVE'

col DESTINATION format a40;

col status format a40;

col ARCHIVED_THREAD# format 999999;

col ARCHIVED_SEQ# format 9999;

SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# -

FROM V$ARCHIVE_DEST_STATUS -

WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE'

SELECT LOCAL.THREAD#, LOCAL.SEQUENCE# FROM -
(SELECT THREAD#, SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=1) -
LOCAL WHERE -
LOCAL.SEQUENCE# NOT IN -
(SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND -
THREAD# = LOCAL.THREAD#)

SELECT LOCAL.THREAD#, LOCAL.SEQUENCE# FROM -

(SELECT THREAD#, SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=1) -

LOCAL WHERE -

LOCAL.SEQUENCE# NOT IN -

(SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND -

THREAD# = LOCAL.THREAD#)

SELECT FREQUENCY, DURATION FROM -
V$REDO_DEST_RESP_HISTOGRAM WHERE DEST_ID=2 AND FREQUENCY&gt;1;

1 2	SELECT FREQUENCY, DURATION FROM - V$REDO_DEST_RESP_HISTOGRAM WHERE DEST_ID=2 AND FREQUENCY>1;

Primary

SELECT max(DURATION) FROM V$REDO_DEST_RESP_HISTOGRAM -
WHERE DEST_ID=2 AND FREQUENCY&gt;1;

1 2	SELECT max(DURATION) FROM V$REDO_DEST_RESP_HISTOGRAM - WHERE DEST_ID=2 AND FREQUENCY>1;

Primary

SELECT min( DURATION) FROM V$REDO_DEST_RESP_HISTOGRAM -
WHERE DEST_ID=2 AND FREQUENCY&gt;1;

1 2	SELECT min( DURATION) FROM V$REDO_DEST_RESP_HISTOGRAM - WHERE DEST_ID=2 AND FREQUENCY>1;

COLUMN FILE_NAME FORMAT a55
SELECT THREAD#, SEQUENCE#, FILE_NAME FROM DBA_LOGSTDBY_LOG L -
WHERE NEXT_CHANGE# NOT IN -
(SELECT FIRST_CHANGE# FROM DBA_LOGSTDBY_LOG WHERE L.THREAD# = THREAD#) -
ORDER BY THREAD#, SEQUENCE#;

COLUMN FILE_NAME FORMAT a55

SELECT THREAD#, SEQUENCE#, FILE_NAME FROM DBA_LOGSTDBY_LOG L -

WHERE NEXT_CHANGE# NOT IN -

(SELECT FIRST_CHANGE# FROM DBA_LOGSTDBY_LOG WHERE L.THREAD# = THREAD#) -

ORDER BY THREAD#, SEQUENCE#;

COLUMN NAME FORMAT A24
COLUMN VALUE FORMAT A16
COLUMN DATUM_TIME FORMAT A24
SELECT NAME, VALUE, DATUM_TIME FROM V$DATAGUARD_STATS;

COLUMN NAME FORMAT A24

COLUMN VALUE FORMAT A16

COLUMN DATUM_TIME FORMAT A24

SELECT NAME, VALUE, DATUM_TIME FROM V$DATAGUARD_STATS;

SELECT MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, COUNT(*)
FROM V$SESSION
GROUP BY MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER;

SELECT MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, COUNT(*)

FROM V$SESSION

GROUP BY MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER;