數(shù)據(jù)庫adg實(shí)施手冊(參考版)
2025-06-28 07:21本頁面
【正文】 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。alter database open。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_2=39。 log_archive_dest_1=39。cd $ORACLE_HOME/network/adminvi 以下為添加的內(nèi)容，標(biāo)紅字段需要針對不同系統(tǒng)進(jìn)行相應(yīng)修改：gdstjcpt = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = gdstjcpt) ) )gdstjcpt_standby = (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)紅字段需要針對不同
化學(xué)相關(guān)推薦
鄂ICP備17016276號(hào)-1