10g 应用dataguard 转

转VonGates 學習筆記 10gR2--DATAGUARD实施步骤

简单记录一个10G DATAGUARD的配置过程。

[@more@]简单记录一个10G DATAGUARD的配置过程。

1． Preparing the Primary Database for Standby Database Creation
A ALTER DATABASE FORCE LOGGING;
This statement can take a considerable amount of time to complete, because it waits for all unlogged direct write I/O to finish.
B Create a Password File
C Configure a Standby Redo Log
Ensure log file sizes are identical on the primary and standby databases
Determine the appropriate number of standby redo log file groups
ALTER DATABASE ADD STANDBY LOGFILE THREAD 5
‘/oracle/dbs/log1c.rdo','/oracle/dbs/log2c.rdo') SIZE 500M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 10
'/oracle/dbs/log1c.rdo','/oracle/dbs/log2c.rdo') SIZE 500M;
SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
select * from V$LOGFILE;
D Set Primary Database Initialization Parameters
DB_NAME=ora10gp
DB_UNIQUE_NAME=ora10gp
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ora10gp,ora10gs)'
CONTROL_FILES='/arch1/ora10gp/control1.ctl', '/arch2/ora10gp/control2.ctl'
LOG_ARCHIVE_DEST_1='LOCATION=/arch1/ora10gp/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora10gp'
LOG_ARCHIVE_DEST_2='SERVICE=ora10gs LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10gs'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=ora10gs
FAL_CLIENT=ora10gp
DB_FILE_NAME_CONVERT='ora10gs','ora10gp'
LOG_FILE_NAME_CONVERT='/arch1/ora10gs/','/arch1/ora10gp/','/arch2/ora10gs/','/arch2/ora10gp/'
STANDBY_FILE_MANAGEMENT=AUTO

E Enable Archiving
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;

2. Creating a Physical Standby Database
A backup database
B create control file
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/ora10gs.ctl';
C prepare an initialize parameter file
CREATE PFILE='/tmp/initora10gs.ora' FROM SPFILE;
DB_NAME=ora10gp
DB_UNIQUE_NAME=ora10gs
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ora10gp,ora10gs)'
CONTROL_FILES='/arch1/ora10gs/control1.ctl', '/arch2/ora10gs/control2.ctl'
DB_FILE_NAME_CONVERT='ora10gp','ora10gs'
LOG_FILE_NAME_CONVERT='/arch1/ora10gp/','/arch1/ora10gs/','/arch2/ora10gp/','/arch2/ora10gs/'
LOG_ARCHIVE_FORMAT=log%t_%s_%r.arc
LOG_ARCHIVE_DEST_1='LOCATION=/arch1/ora10gs/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora10gs'
LOG_ARCHIVE_DEST_2='SERVICE=ora10gp LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10gp'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=ora10gp
FAL_CLIENT=ora10gs

在主库 中设置好fal_server,fal_client,

方便以后switchover 啊
DB_UNIQUE_NAME=ora10gs
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ora10gp,ora10gs)'

这两个参数是10g才有的吧,在9i里面找不到

还有怎么不设置那个standby_archive_dest路径呢

参数多了好多啊,学习

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

转载于:http://blog.itpub.net/9194732/viewspace-913179/