數(shù)據(jù)庫adg實(shí)施手冊(文件)
【正文】 rchivelogmkdir oradatamkdir **(主庫備份文件的存放目錄，保持一致)復(fù)制主庫密碼文件至備庫$ORACLE_HOME/dbs目錄下需注意：格式為orapw+sid啟動(dòng)備庫數(shù)據(jù)庫根據(jù)主庫的pfile文件啟動(dòng)，pfile文件應(yīng)存放于備庫$ORACLE_HOME/dbs目錄下startup nomount恢復(fù)備庫的控制文件rman target /restore standby database controlfile from **(控制文件的存放地址)alter database mount查看數(shù)據(jù)庫相關(guān)信息select * from v$logfile。dg_config=(gdstjcpt,gdstjcpt_standby)39。SERVICE=gdstjcpt LGWR ASYNC valid_for=(online_logfiles,primary_roles) db_unique_name=gdstjcpt39。gdstjcpt39。/oradata/39。/oradata/39。+DATA/gdstjcpt/datafile39。+DATA/gdstjcpt/tempfile39。重啟備庫數(shù)據(jù)庫shutdown immediatestartup mount恢復(fù)備庫的數(shù)據(jù)文件rman target /restore database追補(bǔ)備庫的歸檔文件restore archivelog all添加備庫redolog組需注意：備庫需要比主庫配置多一個(gè)redolog組，由于主庫為RAC模式，因此，備庫應(yīng)該添加（N+1）*2組，其中N為主庫兩個(gè)分區(qū)中配置的最大redolog組數(shù)。/oradata/39。/oradata/39。 group 8 (39。/oradata/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
化學(xué)相關(guān)推薦
鄂ICP備17016276號-1