日期:2014-05-16 浏览次数:20502 次
Primary:
1.检查当前Primary数据库的初始化参数:
SQL> show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string orcl_192.168.1.222
fal_server string orcls_192.168.1.223
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/u01/arch_orcl
log_archive_dest_2 string service=orcls_192.168.1.223 lg
wr async valid_for=(online_log
files, primary_role) db_unique
_name=orclldg
2.修改log_archive_dest_1
SQL> alter system set log_archive_dest_1='location=/u01/arch_orcl valid_for=(online_logfiles,all_roles) db_unique_name=orclpre';
System altered.
Standby:
1.检查当前Standby数据库的初始化参数:
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/u01/arch_ldg valid_f
or=(online_logfiles,all_roles)
&nbs