/*
OracleŽ Data Guard Concepts and Administration
10g Release 2 (10.2)

	http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#SBYDB00700
*/

STANDBY
=======

STARTUP MOUNT;

-- start redo apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

-- cancel redo apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;


-- archive gap
select * from v$archive_gap

-- check state on standby
SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;


PROCESS CLIENT_P  SEQUENCE# STATUS
------- -------- ---------- ------------
ARCH    ARCH              0 CONNECTED
ARCH    ARCH              0 CONNECTED
MRP0    N/A             204 WAIT_FOR_LOG
RFS     LGWR            204 WRITING
RFS     N/A               0 RECEIVING

-- last applied log
SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_APPLIED_LOG" FROM V$LOG_HISTORY GROUP BY THREAD#;



PRIMARY
=======

-- check state on primary
SELECT ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ# FROM V$ARCHIVE_DEST_STATUS;


DATABASE ROLE
=============
SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;

STANDBY REDO LOGS
=================
SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;

set linesize 120
col member for a40
SELECT * FROM v$logfile




RMAN - RESTORE OF ARCHIVES
==========================
run {
    allocate channel ch1 type disk; 
    restore (archivelog low logseq 165471 high logseq 165529 thread 1);                                                                     
    release channel ch1;                                                  
}