Oracle8i,9i Standby引數設定及相關說明

-------------------------------------------
Oracle 8i Standby configure Parameter
-------------------------------------------

## The following parameters are the HA parameters needed for Standby Database on primary side

LOG_ARCHIVE_START=TRUE
LOG_ARCHIVE_FORMAT = "%t_%s.arc"
LOG_ARCHIVE_DEST_1='LOCATION=/data/umlaut/arch'

LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE 

LOG_ARCHIVE_DEST_2='SERVICE=standby  OPTIONAL REOPEN=60' 
LOG_ARCHIVE_MIN_SUCCEED_DEST=1 

 

## The following parameter are the HA parameters needed for Standby Database on standby side

LOG_ARCHIVE_START=TRUE
LOG_ARCHIVE_FORMAT = "%t_%s.arc"
LOG_ARCHIVE_DEST_1='LOCATION=/stby/umlaut/arch'

LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE

STANDBY_ARCHIVE_DEST='/stby/umlaut/arch'
LOG_ARCHIVE_MIN_SUCCEED_DEST=1

 

 

 

 

fal_server與fal_client
這兩個引數是9i的新引數，指明瞭自動日誌同步，在以前的環境中（如8i），只有手工解決日誌差異，但是9i的這兩
個引數可以自動檢測並解決日誌差異。
例如：
fal_server='primary'
fal_client='standby'
其中primary與standby必須是連線到主資料庫與備用資料庫的連線

standby_file_management
這個引數也是9i的新引數，可以自動同步資料檔案。
例如：  standby_file_management=auto

 

 

======================================================================================

9I Primary DB:

# for oracle9i standby .
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_archive_dest_2="service=standby optional reopen=60" 
*.log_archive_min_succeed_dest=1

-------------------

9I Standby DB:

# for oracle9i standby .
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.standby_archive_dest="/data/acer/arch"
*.db_file_name_convert=("/data/acer","/data/acer")
*.log_file_name_convert=("/u01/product/oradata/acer","/u01/product/oradata/acer")
*.log_archive_trace=0
*.log_archive_min_succeed_dest=1
*.standby_file_management=AUTO
*.remote_archive_enable=TRUE
*.fal_server='acer'
*.fal_client='standby' 

 

 

 

====================================================================== 

Standby上的 LOG_ARCHIVE_DEST_1和 standby_archive_dest

如果建立了standby redo log那麼online redo log將不需要轉化為archived檔案就可以傳輸到備機(LGWR)，
這樣的話(LGWR方式)，這些standby redo log在Standby上需要歸檔，用到standby上設定的引數log_archive_dest。
所以Standby上的 log_archive_dest 或 log_archive_dest_1 是standby 以lgwr方式傳輸的時候standby上的
online redo log 生成的archived log 檔案存放點。 

Standby預設的arch傳輸方式，primary會遠端將archived log傳輸到standby_archive_dest下 。

 

 

LOG_ARCHIVE_DEST_1和 standby_archive_dest

STANDBY_ARCHIVE_DEST is used when logs are transmitted automatically from the
primary database.  We use this parameter to determine where these logs should
be placed.

LOG_ARCHIVE_DEST is the location where we look for logfiles by default when
recovering the standby database.  It is recommended to set the values of
STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_DEST to the same values in most cases.