ORACLE10G通过RMAN创建DATAGUARD步骤.doc

一、安装环境 Windows 2008 SP2 64位企业版 Oracle 64位企业版 主库： HOSTNAME: YM-MES-SRV IP: SID：MES DB_UNIQUE_NAME：MESPRI 备库： HOSTNAME: YM-MES-SRV02 IP: SID：MES DB_UNIQUE_NAME：MESSTB 主机 SQL ALTER DATABASE FORCE LOGGING; SQL create pfile from spfile; 修改initmes.ora，添加如下信息 *.DB_UNIQUE_NAME=mespri *.LOG_ARCHIVE_CONFIG=DG_CONFIG=(mespri,messtb) *.log_archive_dest_1=location=d:\oracle\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=mespri *.log_archive_dest_2=SERVICE=messtb arch ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_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=AUTO SQL shutdown immediate 删除spfilemes.ora SQL create spfile from pfile; SQL startup SQL ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (D:\MES\DATABASE\MES\standby\REDO04.LOG) SIZE 50M; SQL ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (D:\MES\DATABASE\MES\standby\REDO05.LOG) SIZE 50M; SQL ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 (D:\MES\DATABASE\MES\standby\REDO06.LOG) SIZE 50M; SQL ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 (D:\MES\DATABASE\MES\standby\REDO07.LOG) SIZE 50M; 修改tnsnames.ora,添加如下信息 mespri = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = MES) ) ) messtb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = MES) ) ) $ rman target / nocatalog RMAN backup device type disk format d:\mes\rmanback\%U database plus archivelog; RMAN backup device type disk format d:\mes\rmanback\%U current controlfile for standby; copy文件到从机同名目录下 从机 从主机获得init文件和pwd文件 mes.__db_cache_size=1124073472 mes.__java_pool_sizemes.__large_pool_sizemes.__shared_pool_size=436207616 mes.__streams_pool_size=0 *.audit_file_dest=D:\oracle\product\10.2.0/admin/MES/adump *.background_dump_