物理Standby转化给逻辑Standby的参数变化

附录：

配置物理Standby 的参数配置：

Primary Database: Primary Role Initialization Parameters  
DB_NAME=test 
DB_UNIQUE_NAME=test 
LOG_ARCHIVE_CONFIG='DG_CONFIG=(test,teststby)'
CONTROL_FILES=' D:\oracle\product\10.2.0\oradata\test\control1.ctl', ' D:\oracle\product\10.2.0\oradata\test\control2.ctl ', ' D:\oracle\product\10.2.0\oradata\test\control3.ctl ' 
LOG_ARCHIVE_DEST_1= 'LOCATION= D:\arch1\test\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) 
  DB_UNIQUE_NAME=test'  
LOG_ARCHIVE_DEST_2=
 'SERVICE=teststby  LGWR  ASYNC 
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=teststby'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE 
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE 
LOG_ARCHIVE_FORMAT= ARC%S_%R.%T 
LOG_ARCHIVE_MAX_PROCESSES=30  

Primary Database: Standby Role Initialization Parameters 
FAL_SERVER=teststby  
FAL_CLIENT=test  
DB_FILE_NAME_CONVERT='teststby','test' 
LOG_FILE_NAME_CONVERT= ' D:\arch1\teststby\',' D:\arch1\test\',' D:\arch2\teststby\',' D:\arch2\test\'  
STANDBY_FILE_MANAGEMENT=AUTO   

 

 

 

Modifying Initialization Parameters for a Physical Standby Database
.
.
DB_NAME=test  
DB_UNIQUE_NAME=teststby 
LOG_ARCHIVE_CONFIG='DG_CONFIG=(test,teststby)'
CONTROL_FILES=' D:\oracle\product\10.2.0\oradata\test\control1.ctl', ' D:\oracle\product\10.2.0\oradata\test\control2.ctl ',' D:\oracle\product\10.2.0\oradata\test\control3.ctl ' 
DB_FILE_NAME_CONVERT='test','teststby'  
LOG_FILE_NAME_CONVERT=  
'D:\arch1\test\','D:\arch1\teststby\','D:\arch2\test\','D:\arch2\teststby\'   
LOG_ARCHIVE_FORMAT= ARC%S_%R.%T  
LOG_ARCHIVE_DEST_1=   
 'LOCATION=D:\arch1\teststby\  
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)  
  DB_UNIQUE_NAME=teststby'   
LOG_ARCHIVE_DEST_2=  
 'SERVICE=test  LGWR  ASYNC 
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=test' 
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=test 
FAL_CLIENT=teststby 
.
.

 

 

 

配置逻辑Standby 的参数配置： 

Primary Database: Logical Standby Role Initialization Parameters 
LOG_ARCHIVE_DEST_3=
 'LOCATION=D:\arch2\test\  
  VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)
  DB_UNIQUE_NAME=test' 
LOG_ARCHIVE_DEST_STATE_3=ENABLE 

Modifying Initialization Parameters for a Logical Standby Database 
LOG_ARCHIVE_DEST_1= 
  'LOCATION=D:\arch1\teststby\  
   VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
   DB_UNIQUE_NAME=teststby'
LOG_ARCHIVE_DEST_2=
  'SERVICE=test  LGWR  ASYNC
   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
   DB_UNIQUE_NAME=test'
LOG_ARCHIVE_DEST_3=
  'LOCATION=D:\arch2\teststby\   
   VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)
   DB_UNIQUE_NAME=teststby' 
LOG_ARCHIVE_DEST_STATE_1=ENABLE 
LOG_ARCHIVE_DEST_STATE_2=ENABLE 
LOG_ARCHIVE_DEST_STATE_3=ENABLE  

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-605661/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-605661/