Standby Database的配置，做个记录

1.

SQL> show parameter log_a

NAME                                TYPE
------------------------------------ ---------------
VALUE
------------------------------
log_archive_config                  string
DG_CONFIG=(PROD,PRODs)
log_archive_dest                    string

log_archive_dest_1                  string
LOCATION=/backup_01/prod/archi
velog MANDATORY
log_archive_dest_10                 string

NAME                                TYPE
------------------------------------ ---------------
VALUE
------------------------------
log_archive_dest_2                  string
SERVICE=PRODs LGWR ASYNC=20480
 DB_UNIQUE_NAME=PRODs OPTIONAL
 REOPEN=15 MAX_FAILURE=10 NET_
TIMEOUT=30
log_archive_dest_3                  string

log_archive_dest_4                  string

......

SQL> show parameter standby

NAME                                TYPE
------------------------------------ ----------------------
VALUE
------------------------------
standby_archive_dest                string
?/dbs/arch
standby_file_management             string
AUTO
SQL>

******************************************************************************

2. select *
from v$archive_dest_status t

 

 DEST_ID   DEST_NAMESTATUSTYPEDATABASE_MODERECOVERY_MODEPROTECTION_MODE1 LOG_ARCHIVE_DEST_1VALIDLOCALOPENIDLEMAXIMUM PERFORMANCE2  LOG_ARCHIVE_DEST_2VALIDPHYSICALOPEN_READ-ONLYMANAGED REAL TIME APPLYMAXIMUM PERFORMANCE

Standby Database上查询：

select PROCESS,STATUS from v$managed_standby;

 

 PROCESS STATUS
1 ARCH CLOSING
2 ARCH CONNECTED
3 ARCH CLOSING
4 ARCH CLOSING
5 RFS IDLE
6 RFS IDLE
7 RFS IDLE
8 RFS IDLE
9 MRP0 APPLYING_LOG

Primary Database上查询:

select PROCESS,STATUS from v$managed_standby;

 

PROCESS STATUS
1 ARCH CLOSING
2 ARCH CLOSING
3 ARCH CLOSING
4 ARCH CLOSING
5 LNS WRITING