ORACLE10G通过RMAN创建DATAGUARD步骤

《ORACLE10G通过RMAN创建DATAGUARD步骤》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、一、安装环境Windows2008SP264位企业版Oracle10.2.0.564位企业版主库：HOSTNAME:YM-MES-SRVIP:10.57.23.2SID：MESDB_UNIQUE_NAME：MESPRI备库：HOSTNAME:YM-MES-SRV02IP:10.57.23.3SID：MESDB_UNIQUE_NAME：MESSTB主机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文件到从机同名目录下从机从主机获得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: