逻辑Data Guard维护篇

《逻辑Data Guard维护篇》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、逻辑DataGuard维护一、主备库的转换之switchoverSQL>showparameterFAL;NAMETYPEVALUE-----------------------------------------------------------------------------fal_clientstringorcl_p.1_tnsfal_serverstringorcl_s.2_tnsSQL>showparameterlog_archive_dest;NAMETYPEVALUE----

2、-------------------------------------------------------------------------log_archive_deststringlog_archive_dest_1stringlocation=/u01/archlog_archive_dest_10stringlog_archive_dest_2stringservice=orcl_s.2_tnsarchvalid_for=(online_logfiles,primary_role)

3、db_unique_name=orcl2log_archive_dest_3stringlog_archive_dest_4stringlog_archive_dest_5stringlog_archive_dest_6stringlog_archive_dest_7stringNAMETYPEVALUE-----------------------------------------------------------------------------log_archive_dest_8st

4、ringlog_archive_dest_9stringlog_archive_dest_state_1stringenablelog_archive_dest_state_10stringenablelog_archive_dest_state_2stringENABLElog_archive_dest_state_3stringenablelog_archive_dest_state_4stringenablelog_archive_dest_state_5stringenablelog_a

5、rchive_dest_state_6stringenablelog_archive_dest_state_7stringenablelog_archive_dest_state_8stringenableNAMETYPEVALUE-----------------------------------------------------------------------------log_archive_dest_state_9stringenableSQL>altersystemsetlog

6、_archive_dest_1='location=/u01/arch1valid_for=(online_logfiles,all_roles)db_unique_name=orcl1';Systemaltered.SQL>altersystemsetlog_archive_dest_3='location=/u01/arch2valid_for=(standby_logfiles,standby_role)db_unique_name=orcl1';Systemaltered.SQL>sho

7、wparameterlog_archive_dest;NAMETYPEVALUE-----------------------------------------------------------------------------log_archive_deststringlog_archive_dest_1stringlocation=/u01/archlog_archive_dest_10stringlog_archive_dest_2stringservice=orcl_s.2_tns

8、archvalid_for=(online_logfiles,primary_role)db_unique_name=orcl2log_archive_dest_3stringlocation=/u01/arch2valid_for=(standby_logfiles,standby_role)db_unique_name=orcl1log_archive_dest_4stringlog_archive_dest_5string。。。。。。创建三组standby的redolog(至少也要两组)S