數(shù)據(jù)庫adg實(shí)施手冊-全文預(yù)覽
【正文】 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = gdstjcpt) ) )配置主庫的數(shù)據(jù)庫參數(shù)cd $ORACLE_HOME/dbsvi pfile以下為添加的內(nèi)容，標(biāo)紅字段需要針對不同系統(tǒng)進(jìn)行相應(yīng)修改：log_archive_config=39。(需注意：若主庫已有此歸檔目錄的配置，保留原配置，上述此配置可忽視)log_archive_dest_2=39。alter database open。select * from v$dataguard_status。檢查鏈路情況與歸檔文件應(yīng)用情況：sqlplus “/as sysdba”檢查歸檔日志的應(yīng)用情況col name for a40select NAME,SEQUENCE,APPLIED from v$archived_log order by NAME。LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_DEST_STATE_2=ENABLEFAL_SERVER= gdstjcpt_standby FAL_CLIENT= gdstjcpt standby_file_management=’auto’五、開啟并驗(yàn)證步驟開啟主庫與備庫之間的傳輸應(yīng)用：sqlplus “/as sysdba”alter database recover managed standby database using current logfile disconnect from session。 log_archive_dest_1=39。需注意：大小應(yīng)與原redolog大小相同，并保證組名和命名不沖突。) size 50m。/oradata/39。/oradata/39。select * from v$log。/oradata/39。/oradata39。需注意：針對pfile文件的部分參數(shù)仍需要根據(jù)備庫所分配的計(jì)算資源進(jìn)行相應(yīng)修改。+FRA/gdstjcpt/onlinelog/39。+DATA/gdstjcpt/onlinelog/39。gdstjcpt_standby39。location=/archivelog valid_for=(all_logfiles,all_roles) db_uniq
化學(xué)相關(guān)推薦
鄂ICP備17016276號-1