資源描述：
《ORACLE10G通過(guò)RMAN創(chuàng)建DATAGUARD步驟》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。
1、一、安裝環(huán)境Windows2008SP264位企業(yè)版Oracle10.2.0.564位企業(yè)版主庫(kù)：HOSTNAME:YM-MES-SRVIP:10.57.23.2SID：MESDB_UNIQUE_NAME：MESPRI備庫(kù)：HOSTNAME:YM-MES-SRV02IP:10.57.23.3SID：MESDB_UNIQUE_NAME：MESSTB主機(jī)SQL>ALTERDATABASEFORCELOGGING;SQL>createpfilefromspfile;修改initmes.ora，添加如下信息*
2、.DB_UNIQUE_NAME=mespri*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(mespri,messtb)'*.log_archive_dest_1='location=d:oraclearchiveVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=mespri'*.log_archive_dest_2='SERVICE=messtbarchASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY
3、_ROLE)DB_UNIQUE_NAME=messtb'*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_DEST_STATE_2=ENABLE*.FAL_SERVER=mespri*.FAL_CLIENT=messtb*.STANDBY_FILE_MANAGEMENT=AUTOSQL>shutdownimmediate刪除spfilemes.oraSQL>createspfilefrompfile;SQL>startupSQL>ALTERDATABASEA
4、DDSTANDBYLOGFILEGROUP4('D:MESDATABASEMESstandbyREDO04.LOG')SIZE50M;SQL>ALTERDATABASEADDSTANDBYLOGFILEGROUP5('D:MESDATABASEMESstandbyREDO05.LOG')SIZE50M;SQL>ALTERDATABASEADDSTANDBYLOGFILEGROUP6('D:MESDATABASEMESstandbyREDO06.LOG')SIZE50M;S
5、QL>ALTERDATABASEADDSTANDBYLOGFILEGROUP7('D:MESDATABASEMESstandbyREDO07.LOG')SIZE50M;修改tnsnames.ora,添加如下信息mespri=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.57.23.2)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID=MES)))messtb=(DESCRIPTION=(ADDRESS
6、=(PROTOCOL=TCP)(HOST=10.57.23.3)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID=MES)))$rmantarget/nocatalogRMAN>backupdevicetypediskformat'd:mesrmanback%U'databaseplusarchivelog;RMAN>backupdevicetypediskformat'd:mesrmanback%U'currentcontrolfilefo
7、rstandby;copy文件到從機(jī)同名目錄下從機(jī)從主機(jī)獲得init文件和pwd文件mes.__db_cache_size=1124073472mes.__java_pool_size=16777216mes.__large_pool_size=16777216mes.__shared_pool_size=436207616mes.__streams_pool_size=0*.audit_file_dest='D:oracleproduct10.2.0/admin/MES/adump'*.bac
8、kground_dump_dest='D:oracleproduct10.2.0/admin/MES/bdump'*.compatible='10.2.0.5.0'*.control_files='D:MESDATABASEMEScontrol01.ctl','D:MESDATABASEMEScontrol02.ctl','D:MESDATABASEMEScontrol03.ctl'*.core_dump_dest='D:
