export/home/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dgdb_s'
*.LOG_ARCHIVE_DEST_2='SERVICE=dgdb1 LGWR ASYNC=40960 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dgdb1'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.standby_archive_dest='/export/home/oracle/archive'
*.standby_file_management='AUTO'
--修改完后拷贝到standby端
Oracle$Scp /export/home/oracle/standby.ora oracle@192.168.94.199:/export/home/oracle/
--在standby端使用pfile启动实例
--在primary端用命令创建数据库密码文件，并接拷贝至standby端相同路径下（如已存在，可直接拷贝）
--primary端手工创建数据库密码文件
Oracle$orapwd file=... password=...
--primary端拷贝数据库密码文件至standby端
Oracle$Scp /export/home/oracle/product/10.2.0/database/PWDdgdb1.ora oracle@192.168.94.199:/export/home/oracle/product/10.2.0/database
--standby端：
Oracle$set oracle_sid=dgdb1
Oracle$sqlplus / as sysdba
SQL> startup nomount pfile=’/export/home/oracle/standby.ora’
SQL> CREATE SPFILE FROM PFILE='/export/home/oracle/standby.ora';
--在primary端修改相应参数
--primary端：
Oracle$sqlplus / as sysdba
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT = AUTO scope=both;
SQL> ALTER SYSTEM SET fal_server='dgdb1_s' scope=both;
SQL> ALTER SYSTEM SET fal_client='dgdb1' scope=both;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(dgdb1_s,dgdb1)' scope=both;
SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/export/home/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dgdb1' scope=both;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=dgdb1_s LGWR ASYNC=40960 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dgdb1_s' scope=both;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1='ENABLE' scope=both;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2='ENABLE' scope=both;
SQL> ALTER SYSTEM SET standby_archive_dest='/export/home/oracle/archive' scope=both;
--在primary端开始使用rman备份数据库
--primary端：
Oracle$rman target /
RMAN>backup full format='/u01/app/oracle/bak/ora10g_%d_%T_%s' database include current controlfile for standby plus archivelog format='/u01/app/oracle/bak/arch_%d_%T_%s';
--备份完毕后，把相应备份文件拷贝到丛库的相应目录（目录必须一致）
Oracle$Scp /export/home/oracle/bak/* oracle@192.168.94.199:/export/home/oracle/bak/
--使用duplicate 还原standby数据库
--primary端：
Oracle$rman target / auxiliary sys/system@dgdb1_s
RMAN> duplicate target database for standby nofilenamecheck dorecover;
--收尾工作及开启dg
--standby端建立standby log（至少比redo多一组）：
Oracle$sqlplus / as sysdba
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/export/home/oracle/product/10.2.0/oradata/dgdb1/redo04.log') size 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/export/home/oracle/product/10.2.0/oradata/dgdb1/redo05.log') size 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/export/home/oracle/product/10.2.0/oradata/dgdb1/redo06.log') size 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/export/home/oracle/product/10.2.0/oradata/dgdb1/redo07.log') size 50M;
--开启服务（standby端）：
SQL> alter database recover managed standby database disconnect from session;
--测试服务是否正常
--standby端（看归档日志号）：
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
--primary端（强制一个日志切换）：
SQL> alter system switch logfile;
--standby端（看归档日志号）：
SQL> SELECT SEQUEN |