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

 

server A: 10.85.10.44  SID=orcl ­

target server B: 10.85.10.43 ­

oracle version:10.2.0.1 ­

OS platform : windows XP ­

 

 

Primary设置： ­

 

1. 设置主数据库为force logging 模式 ­

SQL>sqlplus "/as sysdba" ­

SQL>alter database force logging; ­

2. 设置主数据库为归档模式 ­

SQL> archive log list ­

SQL> shutdown immediate ­

SQL> startup mount ­

SQL> alter database archivelog; ­

SQL> archive log list ­

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

先查看日志文件位置： ­

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. 创建主库的初始化参数给备库用 ­

SQL>Create pfile from spfile; ­

产生的文件名为initorcl.ora 存放目录默认放在$ORACLE_HOME/database下 ­

 

5. 在主库创建备库的控制文件 和密码文件 ­

SQL>Alter database create standby controlfile as 'D:/oracle/product/10.2.0/control01.ctl'; ­

D:>orapwd file=D:/PWDorcl.ora password=admin entries=5; ­

 

缺省情况下，win下口令文件的格式是pwdsid.ora，unix下的格式是orapwSID(大小写敏感）

 

6.  在主库创建监听和配置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)­

    )­

  )­

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

评论

1 楼 cxs4808 2019-01-08  

博主我按你的步骤来的，跑不通呀，我是11.1.0版本，操作系统是win7