Oracle 10G windows 平台 DataGuard 实例(二)

 

7. 在initorcl.ora添加以下内容： ­

*.log_archive_format='%T%S%r.ARC' ­

*.DB_UNIQUE_NAME='primary' ­

*.log_archive_config='DG_CONFIG=(primary,standby)' ­

*.log_archive_dest_1='location=D:/oracle/product/10.2.0/oradata/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary' ­

*.log_archive_dest_2='SERVICE=standby arch ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby' ­

*.STANDBY_FILE_MANAGEMENT=AUTO ­

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE ­

*.LOG_ARCHIVE_DEST_STATE_2=ENABLE ­

*.FAL_SERVER='standby' ­

*.FAL_CLIENT='primary' ­

 

关闭数据库，在用initorcl.ora重启，并创建spfile文件 ­

SQL>startup pfile='$ORACLE_HOME/database/initorcl.ora' ­

SQL>create spfile from pfile='$ORACLE_HOME/database/initorcl.ora' ­

 

8.­

A. 拷贝数据文件，参数文件，控制文件，密码文件到备库上 ­

initorcl.ora参数文件,PWDorcl.ora密码文件考到$ORACLE_HOME/database下的， ­

controlbak.ctl 考到$ORACLE_base/oradata/orcl/下，并分别重命名为control01.ctl,control01.ctl,control01.ctl ­

数据文件考到$ORACLE_base/oradata/orcl/下 ­

 

B. 用Rman拷贝,不用停机­

$ rman target /­

RMAN> backup full format 'D:/FULL_%d_%T_%s.bak' database include current controlfile for standby;­

RMAN> sql 'alter system archive log current';­

RMAN> Backup ArchiveLog all format='D:/arch_%d_%T_%s.bak'; ­

备份完后将备份文件拷到standby上同样的目录，强调：同样的目录，在standby进行rman 恢复即可­

 

9. 启动主数据库 ­

SQL>startup ­

 

--------------------------------------------------------------------- ­

Standy操作： ­

 

1. 用oradim工具创建备库orcl实例 ­

oradim.exe -new -sid orcl -startmode m ­

oradim.exe -edit -sid orcl -startmode a ­

2. 创建备库存放数据文件和后台跟踪目录 ­

   $ORACLE_BASE/ORADATA/ORCL ­

   $ORACLE_BASE/admin/orcl ­

   $ORACLE_BASE/admin/orcl/adump ­

   $ORACLE_BASE/admin/orcl/bdump ­

   $ORACLE_BASE/admin/orcl/cdump ­

   $ORACLE_BASE/admin/orcl/dpdump ­

   $ORACLE_BASE/admin/orcl/pfile ­

   $ORACLE_BASE/admin/orcl/udump ­

   $ORACLE_BASE/admin/orcl/ ­

3. 添加"备用联机日志文件" ­

SQL>startup mount ­

先查看日志文件位置： ­

SQL>select * from v$logfile; ­

在添加： ­

SQL> alter database add standby logfile group 4 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo04.log') size 50m; ­

SQL> alter database add standby logfile group 5 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo05.log') size 50m; ­

SQL> alter database add standby logfile group 6 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo06.log') size 50m; ­

SQL> alter database add standby logfile group 7 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo07.log') size 50m; ­

 

4. 在备库创建监听和配置tnsnams.ora ­

 

listener.ora配置如下: ­

# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora­

# Generated by Oracle configuration tools.­

SID_LIST_LISTENER =­

  (SID_LIST =­

    (SID_DESC =­

      (SID_NAME = PLSExtProc)­

      (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)­

      (PROGRAM = extproc)­

    )­

    (SID_DESC =­

      (GLOBAL_DBNAME = orcl)­

      (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)­

      (SID_NAME = orcl)­

    )­

  )­

LISTENER =­

  (DESCRIPTION_LIST =­

    (DESCRIPTION =­

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))­

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.3.44)(PORT = 1521))­

    )­

  )­

 

tnsnames.ora配置如下: ­

# tnsnames.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora­

# Generated by Oracle configuration tools.­

primary =­

  (DESCRIPTION =­

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.3.44)(PORT = 1521))­

    (CONNECT_DATA =­

      (SERVER = DEDICATED)­

      (SERVICE_NAME = orcl)­

    )­

  )­

standby =­

  (DESCRIPTION =­

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.3.43)(PORT = 1521))­

    (CONNECT_DATA =­

      (SERVER = DEDICATED)­

      (SERVICE_NAME = orcl)­

    )­

  )­

EXTPROC_CONNECTION_DATA =­

  (DESCRIPTION =­

    (ADDRESS_LIST =­

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))­

    )­

    (CONNECT_DATA =­

      (SID = PLSExtProc)­

      (PRESENTATION = RO)­

    )­

  )­

 

 

5. 测试主备之间网络连通 ­

  primary: ­

   C:>lsnrctl start ­

   C:>tnsping standby ­

standby ­

   C:>lsnrctl start ­

   C:>tnsping primary ­

 

6. 配置备库初始化参数 ­

编辑$ORACLE_HOME/database目录下的initorcl.ora添加以下内容 ­

*.log_archive_format='%T%S%r.ARC' ­

*.DB_UNIQUE_NAME='standby' ­

*.log_archive_config='DG_CONFIG=(primary,standby)' ­

*.log_archive_dest_1='location=D:/oracle/product/10.2.0/oradata/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby' ­

*.log_archive_dest_2='SERVICE=primary arch ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary' ­

*.STANDBY_FILE_MANAGEMENT=AUTO ­

*.LOG_ARCHIVE_DEST_STATE_1=ENABLE ­

*.LOG_ARCHIVE_DEST_STATE_2=ENABLE ­

*.FAL_SERVER='primary' ­

*.FAL_CLIENT='standby' ­

更多信息请查看 java进阶网 http://www.javady.com