rman 搭建DG

一、配置网络

1、备库的listener 和 tnsname 配置

(1) 监听的配置

[oracle@enmo2 admin]$ vi listener.ora

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = enmo2)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

SID_LIST_LISTENER=

  (SID_LIST=

    (SID_DESC=

      (GLOBAL_DBNAME=ORA)

      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/)

      (SID_NAME=ORA)))

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@enmo2 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 11-JUN-2015 17:45:24

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=enmo2)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                11-JUN-2015 17:38:01

Uptime                    0 days 0 hr. 7 min. 23 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/enmo2/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ORA" has 1 instance(s).

  Instance "ORA", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

（2） tnsname 配置

[oracle@enmo2 admin]$ vi tnsnames.ora

ORA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = enmo2)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ORA)

    )

  )

ENMO =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = enmo1)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ENMO)

    )

  )

[oracle@enmo2 admin]$ tnsping enmo2

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 11-JUN-2015 18:27:41

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.80.11)(PORT=1521)))

OK (0 msec)

主库备库是一样的 配置 方法

二 开启归档、创建主备库的目录

1、开启归档设置快速恢复区

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> create pfile from spfile;

File created.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     4

Next log sequence to archive   6

Current log sequence           6

三、配置主库的参数件

在原有的基础上面添加以下参数

DB_NAME=ENMOEDU

DB_UNIQUE_NAME=ENMOEDU

LOG_ARCHIVE_CONFIG='DG_CONFIG=(ENMOEDU,ORA11GR2)'

LOG_ARCHIVE_DEST_1=/u01/app/oracle/fast_recovery_area 'LOCATION=/arch1/ENMOEDU/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ENMOEDU'

LOG_ARCHIVE_DEST_2=

'SERVICE=ORA11GR2 ASYNC

  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

  DB_UNIQUE_NAME=ORA11GR2'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_SERVER=ORA11GR2

DB_FILE_NAME_CONVERT='ORA11GR2','ENMOEDU'

LOG_FILE_NAME_CONVERT='ORA11GR2','ENMOEDU'

STANDBY_FILE_MANAGEMENT=AUTO

四：把参数文件和密码文件都传给备库

[oracle@enmo1 dbs]$ scp scp initENMOEDU.ora oracle@192.168.80.11:`pwd`

oracle@192.168.80.11's password:

scp: No such file or directory

initENMOEDU.ora                                                                   100% 1561     1.5KB/s   00:00

[oracle@enmo1 dbs]$ scp orapwENMOEDU oracle@192.168.80.11:`pwd`

oracle@192.168.80.11's password:

orapwENMOEDU                                                                      100% 1536     1.5KB/s   00:00

五：在备库建立缺失的路径

[oracle@enmo2 admin]$ mkdir -p /u01/app/oracle/admin/ORA11GR2/{adump,dpdump,pfile}

[oracle@enmo2 admin]$ mkdir -p /u01/app/oracle/oradata/ORA11GR2

[oracle@enmo2 admin]$ mkdir -p /u01/app/oracle/fast_recovery_area/ORA11GR2

六：配置备库的参数：

DB_NAME=ENMOEDU
DB_UNIQUE_NAME=ORA11GR2
LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORA11GR2,ENMOEDU)'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/fast_recovery_area/ORA11GR2 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORA11GR2'
LOG_ARCHIVE_DEST_2=
'SERVICE=ENMOEDU ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=ENMOEDU'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
FAL_SERVER=ENMOEDU
DB_FILE_NAME_CONVERT='ENMOEDU','ORA11GR2'
LOG_FILE_NAME_CONVERT='ENMOEDU','ORA11GR2'
STANDBY_FILE_MANAGEMENT=AUTO

七：利用rman  复制 备库文件

[oracle@enmo1 dbs]$ rman target sys/oracle@ENMOEDU auxiliary sys/oracle@ORA11GR2

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 12 08:22:54 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ENMOEDU (DBID=141362048)

connected to auxiliary database: ORA11GR2 (not mounted)

RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;

archived log for thread 1 with sequence 8 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA11GR2/1_8_882168514.arc

archived log for thread 1 with sequence 9 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA11GR2/1_9_882168514.arc

archived log file name=/u01/app/oracle/fast_recovery_area/ORA11GR2/1_8_882168514.arc thread=1 sequence=8

archived log file name=/u01/app/oracle/fast_recovery_area/ORA11GR2/1_9_882168514.arc thread=1 sequence=9

media recovery complete, elapsed time: 00:00:00

Finished recover at 12-JUN-15

Finished Duplicate Db at 12-JUN-15

五:检查 DG 结构

在主库上面查询

SQL> select database_name,database_role from v$database;

DATABASE_NAME             DATABASE_ROLE

------------------------- ----------------

ENMOEDU                   PRIMARY

在备库上面

SQL> select database_name,database_role from v$database;

DATABASE_NAME             DATABASE_ROLE

------------------------- ----------------

ENMOEDU                   PHYSICAL STANDBY

以上就是我的rman 搭建DG 谢谢

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30176559/viewspace-1696418/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30176559/viewspace-1696418/