??????MySQL??????????????????????????????????????????????????????????????MySQL???д????????????????д??????????????????????????????????????
???????????Oracle???????????????У????????????????????????к?????
?????л???RAC??????????????????????????
?????л???Streams???????????????????????????????????????
?????????????????????????????Golden Gate(?????Oracle????????)??DSG???????????????????????????С?
???????????Logical standby???????????????????????????????????????????
?????????????????????????????dataguard?????е?logical standby???Oracle???????д????
???????????????standby
?????????????????????д?????????????????????
????*.log_archive_config='dg_config=(webdb??webdg)'
????*.log_archive_dest_2='service=webdb_standby lgwr sync affirm  valid_for=(online_logfiles??primary_role) db_unique_name=webdg'
????*.log_archive_dest_state_2='enable'
????????????tnsnames.ora???
??????tnsnames.ora??????????????????????webdb_standby???????log_archive_dest_2??service????????????????汾??10g?????????LGWR???????????????y?????????11g????????????LNS??
WEBDB_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.65.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = webdb)
)
)
WEBDB_READER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.65.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = webreader)
)
)
??????????????????????????
????*.db_unique_name='webdg'
????*.fal_client='webdb_standby'
????*.fal_server='webdb_primary'
????*.log_archive_config='dg_config=(webdb??webdg)'
????*.log_archive_dest_1='location=+VG2 valid_for=(all_logfiles??all_roles) db_unique_name=webdg'
????????????tnsnames.ora???
WEBDB_PRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.65.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = webdb)
)
)
WEBDB_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.65.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = webdb)
)
)
??????tnsnames.ora???????????????????????webdb_standby??webdb_primary???????fal_client??fal-_server??????????????????鵵???gap??