*.core_dump_dest='/oracle/admin/shanghai/cdump'
db_unique_name=shanghai
log_archive_config='dg_config=(beijing,shanghai)'
control_files='/dbfile/datafile/shanghai/control01.ctl',
'/dbfile/datafile/shanghai/control02.ctl',
'/dbfile/datafile/shanghai/control03.ctl'
log_archive_dest_1=
'location=/dbfile/logfile/shanghai/ valid_for=(all_logfiles,all_roles) db_unique_name=shanghai'
log_archive_dest_2=
'service=beijing lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=beijing'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=beijing
fal_client=shanghai
db_file_name_convert='beijing','shanghai'
log_file_name_convert='beijing','shanghai'
standby_file_management=auto
10.启动备库(shanghai)，使用pfile(刚才修改的)生成spfile
[oracle@linux ~]$ export ORACLE_SID=shanghai
[oracle@linux ~]$ sqlplus / as sysdba
SQL> create spfile from pfile='/dbfile/initshanghai.ora';
11.启动备库到mount状态，然后启动redo应用
SQL> startup mount
SQL> alter database recover managed standby database disconnect from session
12.检查日志，看设置是否成功
主库切换日志
SQL> alter system switch logfile;
备库查看有无新收到的日志
SQL> select sequence#,first_time,next_time from v$archived_log order by 1;
SEQUENCE# FIRST_TIME NEXT_TIME
---------- ------------------- -------------------
16 2012-01-10 08:51:41 2012-01-10 08:51:45
16 2012-01-10 08:51:41 2012-01-10 08:51:45
17 2012-01-10 08:51:45 2012-01-10 08:51:48
17 2012-01-10 08:51:45 2012-01-10 08:51:48
18 2012-01-10 08:51:48 2012-01-10 08:52:26
18 2012-01-10 08:51:48 2012-01-10 08:52:26
19 2012-01-10 08:52:26 2012-01-10 08:53:57
19 2012-01-10 08:52:26 2012-01-10 08:53:57
20 2012-01-10 08:53:57 2012-01-10 08:54:06
20 2012-01-10 08:53:57 2012-01-10 08:54:06
也可以到/dbfile/logfile/shanghai目录中，看一下有无归档日志文件