數(shù)據(jù)庫(kù)adg實(shí)施手冊(cè)(文件)
【正文】 rchivelogmkdir oradatamkdir **(主庫(kù)備份文件的存放目錄，保持一致)復(fù)制主庫(kù)密碼文件至備庫(kù)$ORACLE_HOME/dbs目錄下需注意：格式為orapw+sid啟動(dòng)備庫(kù)數(shù)據(jù)庫(kù)根據(jù)主庫(kù)的pfile文件啟動(dòng)，pfile文件應(yīng)存放于備庫(kù)$ORACLE_HOME/dbs目錄下startup nomount恢復(fù)備庫(kù)的控制文件rman target /restore standby database controlfile from **(控制文件的存放地址)alter database mount查看數(shù)據(jù)庫(kù)相關(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。重啟備庫(kù)數(shù)據(jù)庫(kù)shutdown immediatestartup mount恢復(fù)備庫(kù)的數(shù)據(jù)文件rman target /restore database追補(bǔ)備庫(kù)的歸檔文件restore archivelog all添加備庫(kù)redolog組需注意：備庫(kù)需要比主庫(kù)配置多一個(gè)redolog組，由于主庫(kù)為RAC模式，因此，備庫(kù)應(yīng)該添加（N+1）*2組，其中N為主庫(kù)兩個(gè)分區(qū)中配置的最大redolog組數(shù)。/oradata/39。/oradata/39。 group 8 (39。/oradata/39。cd $ORACLE_HOME/network/adminvi 以下為添加的內(nèi)容，標(biāo)紅字段需要針對(duì)不同系統(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號(hào)-1