ITPub博客

首页 > 数据库 > Oracle > duplicate搭建DG最大性能(rac-单实例)

duplicate搭建DG最大性能(rac-单实例)

原创 Oracle 作者:zhangsharp20 时间:2017-04-21 13:25:04 0 删除 编辑
备库操作:
一、创建pfile和密码口令文件

我创建的pfile如下:

*.control_files='/dup1/control01.ctl'
*.db_block_size=8192
*.db_create_file_dest='/dup1'
*.db_file_name_convert='+oradata','/dup1'
*.db_name='test'
*.db_recovery_file_dest='/arch'
*.db_recovery_file_dest_size=4621074432
*.fal_client='dup1'
*.fal_server='test'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='+oradata','/dup1','+rcy','/dup2'
*.remote_login_passwordfile='exclusive'
*.standby_file_management='AUTO'
db_unique_name=testt
log_archive_config='DG_CONFIG=(testt,test)'
LOG_ARCHIVE_DEST_1='LOCATION=/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=testt';

创建密码口令文件:

orapwd file=$ORACLE_HOME/dbs/orapwtest password=oracle entries=3

在备库上配置监听

LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.120)(PORT=1521))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=dup1)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME=test)))

配置完成重启监听

[oracle@ora3 admin]$ lsnrctl status


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-MAR-2017 04:33:42


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.120)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                01-JAN-2017 14:10:43
Uptime                    81 days 14 hr. 23 min. 19 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/ora3/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora3)(PORT=1521)))
Services Summary...
Service "test" has 1 instance(s).
  Instance "test", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[oracle@ora3 admin]$ lsnrctl stop


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-MAR-2017 04:33:49


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.120)(PORT=1521)))
The command completed successfully
[oracle@ora3 admin]$ lsnrctl start


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-MAR-2017 04:33:55


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


Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ora3/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.120)(PORT=1521)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.120)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                24-MAR-2017 04:33:55
Uptime                    0 days 0 hr. 0 min. 0 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/ora3/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.120)(PORT=1521)))
Services Summary...
Service "test" has 1 instance(s).
  Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

主库操作:

1、打开最小日志


SQL> select log_mode,force_logging from v$database;


LOG_MODE     FOR
------------ ---
ARCHIVELOG   NO


SQL> alter database force logging;


Database altered.


SQL> select log_mode,force_logging from v$database;


LOG_MODE     FOR
------------ ---
ARCHIVELOG   YES

2、修改参数

主库:
alter system set log_archive_config='DG_CONFIG=(test,testt)';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=+RCY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=test';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=dup1 arch SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testt';

3、登录rman


rman target / auxiliary sys/oracle@dup1 nocatalog


4、开始复制
run 
{
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER;
}

恢复完之后备库:


alter database recover managed standby database disconnect from session;


然后主库切换日志,备库查看告警是否已经传输日志

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

下一篇: grep文件比对
请登录后发表评论 登录
全部评论

注册时间:2014-08-12

  • 博文量
    382
  • 访问量
    801409