Oracle 11R2+RAC+DG安装记录

最新推荐文章于 2023-10-22 14:12:16 发布
最新推荐文章于 2023-10-22 14:12:16 发布
阅读量587 收藏
点赞数
分类专栏： Oracle 日常管理 文章标签： 安装
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yanchaohui1030/article/details/83188933
版权

一、安装规划

 

1、硬件环境

主机 CPU 内存 存储 网卡

dg1 24  Intel(R) Xeon(R) CPU           E7450  @ 2.40GHz    16G /           29G 

/dev/shm    13G  

/boot       194M

/u01        90G   

/rmanbak    3.9T  

    Eth0

Eth1

dg2 24  Intel(R) Xeon(R) CPU           E7450  @ 2.40GHz    16G /           29G 

/dev/shm    13G  

/boot       194M

/u01        90G   Eth0

Eth1

 

2、软件环境

Red Hat Enterprise Linux Server release 6.4 (Santiago)

Oracle 11g Database Release 2 

Oracle 11g Grid Release 2

 

3、IP地址规划

主机 IP地址       别名  用途

dg1    10.1.1.65 dg1 公共ip

       10.1.1.51 dg1-vip 虚拟ip

       11.1.1.1      dg1-priv    内部通讯（心跳）

dg2    10.1.1.66 dg2 公共ip

       10.1.1.52 dg2-vip 虚拟ip

       11.1.1.2      dg2-priv 内部通讯（心跳）

scan   10.1.1.50 scan    数据库全局接入

 

4、共享存储分配

用途 DG名称   说明 设备路径（需现场填写）

OCR/VOTE盘  OCR 20G     /dev/mapper/sharedisk1

LOG日志盘    LOG 1800G   /dev/mapper/sharedisk2

DATA数据盘   DATA    1900G   /dev/mapper/sharedisk3

 

 

二、主库配置

 

1、参数文件修改

SQL> create pfile from spfile;

File created.

SQL> alter database force logging;

Database altered.

SQL> alter system set db_unique_name='orcl' scope=spfile;

System altered.

SQL> alter system set log_archive_config='DG_CONFIG=(orcl,orcldg)';

System altered.

SQL> alter system set log_archive_dest_1='LOCATION=+LOG valid_for=(all_logfiles,all_roles) db_unique_name=orcl' scope=spfile;

System altered.

SQL> alter system set log_archive_dest_2='SERVICE=orcldg lgwr sync valid_for=(online_logfiles,primary_roles) db_unique_name=orcldg';

System altered.

SQL> alter system set fal_client='orcl';

System altered.

SQL> alter system set fal_server='orcldg';

System altered.

SQL> alter system set standby_file_management=auto;

System altered.

 

SQL> shutdown immediate

SQL> startup

 

修改后参数文件如下：

[oracle@rac1 dbs]$ cat pfile0906pb.ora

orcl1.__db_cache_size=37849399296

orcl3.__db_cache_size=33017561088

orcl2.__db_cache_size=32480690176

orcl4.__db_cache_size=29259464704

orcl3.__java_pool_size=1879048192

orcl1.__java_pool_size=1879048192

orcl4.__java_pool_size=1879048192

orcl2.__java_pool_size=1879048192

orcl1.__large_pool_size=2147483648

orcl3.__large_pool_size=2147483648

orcl4.__large_pool_size=2147483648

orcl2.__large_pool_size=2147483648

orcl1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcl2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcl3.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcl4.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcl3.__pga_aggregate_target=32480690176

orcl1.__pga_aggregate_target=28454158336

orcl2.__pga_aggregate_target=32749125632

orcl4.__pga_aggregate_target=34896609280

orcl3.__sga_target=48855252992

orcl1.__sga_target=52881784832

orcl2.__sga_target=48586817536

orcl4.__sga_target=46439333888

orcl3.__shared_io_pool_size=0

orcl1.__shared_io_pool_size=0

orcl4.__shared_io_pool_size=0

orcl2.__shared_io_pool_size=0

orcl4.__shared_pool_size=12616466432

orcl1.__shared_pool_size=10468982784

orcl3.__shared_pool_size=11274289152

orcl2.__shared_pool_size=11542724608

orcl3.__streams_pool_size=0

orcl1.__streams_pool_size=0

orcl4.__streams_pool_size=0

orcl2.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'

*.audit_trail='NONE'

*.cluster_database=true

*.compatible='11.2.0.4.0'

*.control_files='+DATA/orcl/controlfile/current.260.921272105','+LOG/orcl/controlfile/current.256.921272105'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_file_name_convert='+DATA/orcldg/','+DATA/orcl/'

*.db_name='orcl'

*.db_recovery_file_dest='+LOG'

*.db_recovery_file_dest_size=1048576000000

*.db_unique_name='orcl'

*.deferred_segment_creation=FALSE

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.fal_client='orcl'

*.fal_server='orcldg1','orcldg2'

orcl1.instance_number=1

orcl2.instance_number=2

orcl3.instance_number=3

orcl4.instance_number=4

*.log_archive_config='DG_CONFIG=(orcl,orcldg)'

*.log_archive_dest_1='LOCATION=+LOG valid_for=(all_logfiles,all_roles) db_unique_name=orcl'

*.log_archive_dest_2='SERVICE=orcldg lgwr sync valid_for=(online_logfiles,primary_roles) db_unique_name=orcldg'

*.log_archive_format='%t_%s_%r.dbf'

*.log_file_name_convert='+LOG/orcldg/','+LOG/orcl/'

*.memory_target=81180753920

*.open_cursors=300

*.processes=5000

*.remote_listener='scan:1521'

*.remote_login_passwordfile='exclusive'

*.sec_case_sensitive_logon=FALSE

*.sessions=3305

*.standby_file_management='AUTO'

orcl2.thread=2

orcl3.thread=3

orcl4.thread=4

orcl1.thread=1

orcl3.undo_tablespace='UNDOTBS3'

orcl1.undo_tablespace='UNDOTBS1'

orcl2.undo_tablespace='UNDOTBS2'

orcl4.undo_tablespace='UNDOTBS4'

 

 

三、备库的配置

1、装好RAC集群grid

注意的是groupdisk和原来一样

 

2、装好数据库软件

这个没有特殊要求

 

3、安装一个实例

实例名是ORCLDG，其他设置随意，主要为了得到spfile的模板和建好目录。

 

4、配置备库的spfile

先得到模板的pfile，并修改

[oracle@dg1 dbs]$ cat pfile0906.ora

orcldg2.__db_cache_size=4093640704

orcldg1.__db_cache_size=4194304000

orcldg2.__java_pool_size=201326592

orcldg1.__java_pool_size=201326592

orcldg1.__large_pool_size=134217728

orcldg2.__large_pool_size=234881024

orcldg2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcldg1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcldg2.__pga_aggregate_target=4026531840

orcldg1.__pga_aggregate_target=4026531840

orcldg2.__sga_target=6039797760

orcldg1.__sga_target=6039797760

orcldg2.__shared_io_pool_size=0

orcldg1.__shared_io_pool_size=0

orcldg2.__shared_pool_size=1442840576

orcldg1.__shared_pool_size=1442840576

orcldg2.__streams_pool_size=0

orcldg1.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/orcldg/adump'

*.audit_trail='NONE'

*.cluster_database=true

*.compatible='11.2.0.4.0'

*.control_files='+DATA/orcldg/controlfile/current.292.953920965','+LOG/orcldg/controlfile/current.281.953920965'#Set by RMAN

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_file_name_convert='+DATA/orcl/','+DATA/orcldg/'

*.db_name='orcl'

*.db_recovery_file_dest='+LOG'

*.db_recovery_file_dest_size=462107443200

*.db_unique_name='orcldg'

*.deferred_segment_creation=FALSE

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcldgXDB)'

*.fal_client='orcldg'

*.fal_server='orcl1','orcl2','orcl3','orcl4'

orcldg2.instance_number=2

orcldg1.instance_number=1

*.log_archive_config='DG_CONFIG=(orcl,orcldg)'

*.log_archive_dest_1='LOCATION=+LOG valid_for=(all_logfiles,all_roles) db_unique_name=orcldg'

*.log_archive_dest_2='SERVICE=orcl lgwr sync valid_for=(online_logfiles,primary_roles) db_unique_name=orcl'

*.log_archive_format='%t_%s_%r.dbf'

*.log_file_name_convert='+LOG/orcl/','+LOG/orcldg/'

*.memory_target=10066329600

*.open_cursors=300

*.processes=1500

*.remote_listener='scan:1521'

*.remote_login_passwordfile='exclusive'

*.sec_case_sensitive_logon=FALSE

*.sessions=1655

*.standby_file_management='AUTO'

orcldg2.thread=2

orcldg1.thread=1

orcldg2.undo_tablespace='UNDOTBS2'

orcldg1.undo_tablespace='UNDOTBS1'

SQL> shutdown immediate

SQL> create spfile='+DATA/orcldg/spfileorcl.ora' from pfile='$ORACLE_HOME/dbs/pfile0906.ora';

 

5、统一密码文件

在两个节点执行这个语句，password和主库一直，可以直接复制过来，文件名是orapworcl1和orapworcl2

主库备库每个节点都添加一个orapwdorcl

 

6、修改监听文件

[grid@dg1 admin]$ ls

endpoints_listener.ora      listener.ora          samples     sqlnet.ora

listener17090410AM5705.bak  listener.ora.bak.dg1  shrept.lst

[grid@dg1 admin]$ cat listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))   # line added by Agent

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orcldg)

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

        (SID_NAME = orcldg1)

    )

  )

[grid@dg2 admin]$ cat listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))   # line added by Agent

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orcldg)

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

        (SID_NAME = orcldg2)

    )

  )

7、修改tnsnames.ora

[oracle@dg1 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCLSCAN =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

ZFDXC =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = zfdxc)

    )

  )

ORCL =

  (DESCRIPTION =

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

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

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

 

ORCL1 =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

ORCL2 =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

  

ORCL3 =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

 

ORCL4 =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

  

ORCLDG =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcldg)

    )

  )

 

ORCLDG1 =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcldg)

    )

  )

 

ORCLDG2 =

  (DESCRIPTION =

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

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcldg)

    )

  )

主备库的所有tnsnames.ora都是这个文件

 

8、利用duplicate同步库

[oracle@dg1 dbs]$ rman target sys/ORACLE_ORCL@orcl auxiliary sys/ORACLE_ORCL@orcldg

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

 

9、创建standby redo文件

alter database add standby logfile thread 1 group 11 ('+DATA/ORCLDG/ONLINELOG/standby11.log','+LOG/ORCLDG/ONLINELOG/standby11.log') size 1000m;

alter database add standby logfile thread 1 group 12 ('+DATA/ORCLDG/ONLINELOG/standby12.log','+LOG/ORCLDG/ONLINELOG/standby12.log') size 1000m;

alter database add standby logfile thread 1 group 13 ('+DATA/ORCLDG/ONLINELOG/standby13.log','+LOG/ORCLDG/ONLINELOG/standby13.log') size 1000m;

alter database add standby logfile thread 2 group 14 ('+DATA/ORCLDG/ONLINELOG/standby14.log','+LOG/ORCLDG/ONLINELOG/standby14.log') size 1000m;

alter database add standby logfile thread 2 group 15 ('+DATA/ORCLDG/ONLINELOG/standby15.log','+LOG/ORCLDG/ONLINELOG/standby15.log') size 1000m;

alter database add standby logfile thread 2 group 16 ('+DATA/ORCLDG/ONLINELOG/standby16.log','+LOG/ORCLDG/ONLINELOG/standby16.log') size 1000m;

alter database add standby logfile thread 3 group 17 ('+DATA/ORCLDG/ONLINELOG/standby17.log','+LOG/ORCLDG/ONLINELOG/standby17.log') size 1000m;

alter database add standby logfile thread 3 group 18 ('+DATA/ORCLDG/ONLINELOG/standby18.log','+LOG/ORCLDG/ONLINELOG/standby18.log') size 1000m;

alter database add standby logfile thread 3 group 19 ('+DATA/ORCLDG/ONLINELOG/standby19.log','+LOG/ORCLDG/ONLINELOG/standby19.log') size 1000m;

alter database add standby logfile thread 4 group 20 ('+DATA/ORCLDG/ONLINELOG/standby20.log','+LOG/ORCLDG/ONLINELOG/standby20.log') size 1000m;

alter database add standby logfile thread 4 group 21 ('+DATA/ORCLDG/ONLINELOG/standby21.log','+LOG/ORCLDG/ONLINELOG/standby21.log') size 1000m;

alter database add standby logfile thread 4 group 22 ('+DATA/ORCLDG/ONLINELOG/standby22.log','+LOG/ORCLDG/ONLINELOG/standby22.log') size 1000m;

 

10、在主库创建standby redo日志，以便主备切换

alter database add standby logfile thread 1 group 11 ('+DATA/ORCL/ONLINELOG/standby11.log','+LOG/ORCL/ONLINELOG/standby11.log') size 1000m;

alter database add standby logfile thread 1 group 12 ('+DATA/ORCL/ONLINELOG/standby12.log','+LOG/ORCL/ONLINELOG/standby12.log') size 1000m;

alter database add standby logfile thread 1 group 13 ('+DATA/ORCL/ONLINELOG/standby13.log','+LOG/ORCL/ONLINELOG/standby13.log') size 1000m;

alter database add standby logfile thread 2 group 14 ('+DATA/ORCL/ONLINELOG/standby14.log','+LOG/ORCL/ONLINELOG/standby14.log') size 1000m;

alter database add standby logfile thread 2 group 15 ('+DATA/ORCL/ONLINELOG/standby15.log','+LOG/ORCL/ONLINELOG/standby15.log') size 1000m;

alter database add standby logfile thread 2 group 16 ('+DATA/ORCL/ONLINELOG/standby16.log','+LOG/ORCL/ONLINELOG/standby16.log') size 1000m;

alter database add standby logfile thread 3 group 17 ('+DATA/ORCL/ONLINELOG/standby17.log','+LOG/ORCL/ONLINELOG/standby17.log') size 1000m;

alter database add standby logfile thread 3 group 18 ('+DATA/ORCL/ONLINELOG/standby18.log','+LOG/ORCL/ONLINELOG/standby18.log') size 1000m;

alter database add standby logfile thread 3 group 19 ('+DATA/ORCL/ONLINELOG/standby19.log','+LOG/ORCL/ONLINELOG/standby19.log') size 1000m;

alter database add standby logfile thread 4 group 20 ('+DATA/ORCL/ONLINELOG/standby20.log','+LOG/ORCL/ONLINELOG/standby20.log') size 1000m;

alter database add standby logfile thread 4 group 21 ('+DATA/ORCL/ONLINELOG/standby21.log','+LOG/ORCL/ONLINELOG/standby21.log') size 1000m;

alter database add standby logfile thread 4 group 22 ('+DATA/ORCL/ONLINELOG/standby22.log','+LOG/ORCL/ONLINELOG/standby22.log') size 1000m;

 

四、主备库切换

 

1、主备切换，RAC主备切换需要停止实例到只有一台启动

主库节点2：[grid@rac2 ~]$ srvctl stop instance -d orcl -i orcl2

主库节点3：[grid@rac3 ~]$ srvctl stop instance -d orcl -i orcl3

主库节点4：[grid@rac4 ~]$ srvctl stop instance -d orcl -i orcl4

备库节点2：[grid@dg2 ~]$ srvctl stop instance -d orcldg -i orcldg2

 

2、主库切换

[grid@rac1 ~]$ lsnrctl stop listener

SQL> alter database commit to switchover to physical standby with session shutdown;

startup

alter database recover managed standby database using current logfile disconnect from session;

[grid@rac1 ~]$ lsnrctl start listener

 

3、备库切换

[grid@dg1 ~]$ lsnrctl stop listener

SQL> alter database recover managed standby database cancel;

SQL> alter database commit to switchover to primary with session shutdown;

SQL> alter database open;

[grid@dg1 ~]$ lsnrctl start listener

 

4、启动所有服务器

主库节点2：[grid@rac2 ~]$ srvctl start instance -d orcl -i orcl2

主库节点3：[grid@rac3 ~]$ srvctl start instance -d orcl -i orcl3

主库节点4：[grid@rac4 ~]$ srvctl start instance -d orcl -i orcl4

备库节点2：[grid@dg2 ~]$ srvctl start instance -d orcldg -i orcldg2

大碗刀削面
关注
专栏目录
Oracle 11g RAC+DG 非常牛逼的部署手册
06-06
Oracle 11g RAC+DG 非常牛逼的部署手册
Oracle数据库高可用--DG+RAC
最新发布
one piece的博客
07-27 941
故障转移：如果一个数据库实例故障，Oracle Clusterware会检测到这个故障，并将数据库会话和工作负载迁移到其他正常运行的实例上，实现高可用性和容错能力。辅助数据库(StandBy database)：辅助数据库是通过复制主数据库的归档日志来保持与主数据库同步的数据库。数据库实例：Oracle RAC包含多个数据库实例，每个实例都运行在独立的服务器上。的一种高可用性解决方案，它通过在主数据库和一个或多个辅助数据库之间自动复制和同步数据，来实现数据库的持续可用性和灾难恢复能力。
Oracle+11g+RAC+DG项目实战
08-11
本文档用于记录在OEL 5.5 X86_64位系统上安装配置Oracle 11gR2(11.2.0.3.0) RAC的详细步骤。 安装平台选择VMware公司的VMware ESXi Version 4.0的虚拟主机，通过在该虚拟机上配置两台OEL 5.5 X86_64位Linux系统的机器，然后在这两台Linux机器上配置Oracle 11gR2 RAC系统。其中，操作系统选择Oracle公司的OEL 5.5 X86_64位Linux系统，数据库软件采用目前Oracle 11gR2最新版本的11.2.0.3.0。 本文档中假定你已经安装配置好VMware ESXi Version 4.0的虚拟主机，如果没有该环境的话，也可以通过自行安装VMware Server来完成11gR2 RAC的安装配置。
【ORACLE】11g rac+dg
zclinux的博客
12-07 898
首先感谢群友分享的文档，在这里先感谢哆啦B梦，非常感谢 该文档主要指导如何利用现有的RAC环境搭建一套RAC与单实例的DG的环境  ============================主机配置信息==================================== |   角色    |   主机名    |     管理IP     |      VIP
oracle11g 搭建 rac+dg
csygkk2842的博客
04-24 845
一、准备阶段 1、配置RAC+DG的过程简述（备机单节点，数据文件可放至本地） （1）根据主库参数在备库创建pfile参数文件，密码文件和必要的目录。 （2）在备库修改pfile参数文件，主库上用rman dupli...
Oracle 11g RAC+DG项目实战(共15集) 视频
12-29
本文档用于详细记录在 OEL 5.5 X86_64 位系统上安装配置 Oracle 11gR2(11.2.0.3.0) RAC 的步骤、RAC 数据库的基本维护、为 RAC 创建单实例 Active Physical Dataguard、验证 Active Dataguard 的功能、RAC 主库同单...
Oracle 11g+RAC+DG项目实战【技术文档】
05-14
Oracle+11g+RAC+DG项目实战 概述 本文档用于记录在OEL 5.5 X86_64位系统上安装配置Oracle 11gR2(11.2.0.3.0) RAC的详细步骤。 安装平台选择VMware公司的VMware ESXi Version 4.0的虚拟主机，通过在该虚拟机上配置两台OEL 5.5 X86_64位Linux系统的机器，然后在这两台Linux机器上配置Oracle 11gR2 RAC系统。其中，操作系统选择Oracle公司的OEL 5.5 X86_64位Linux系统，数据库软件采用目前Oracle 11gR2最新版本的11.2.0.3.0。 本文档中假定你已经安装配置好VMware ESXi Version 4.0的虚拟主机，如果没有该环境的话，也可以通过自行安装VMware Server来完成11gR2 RAC的安装配置。
oracle dg安装,Oracle 11g RAC + DG安装详解--03
weixin_35934226的博客
04-09 737
Oracle 11g RAC + DG安装详解--03发布时间：2020-08-13 15:31:21来源：ITPUB博客阅读：103作者：pennymeng三、创建asm磁盘组这一步也可以放到安装完oracle软件后再做。任一节点，grid用户下执行：[grid@rac1 ~]$ asmcmdASMCMD> mkdg ' 'ASMCMD> mkdg ' 'ASMCMD>...
oracle rac 主库,oracle11gRAC+DG主库增加数据文件
weixin_36284522的博客
04-07 464
oracle11gRAC+DG主库增加数据文件oracle11gRAC+DG主库增加数据文件# 环境操作系统$ uname -aLinux jinhu-db02 2.6.32-696.el6.x86_64 #1 SMP Tue Mar 21 19:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux$ cat /etc/redhat-releaseCentOS...
oracle 11gRAC + dg +ogg 实战文档
09-04
手把手教你搭建 oracle 11gRAC + dg +ogg 实战文档，步骤详细，简单易懂，带你一步步走进oracle高可用。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
Oracle 11GR2 RAC-RAC DG 环境部署手册
07-20
浦东机场货运站核心数据库升级至Oracle RAC 11gR2。操作系统采用RedHat Enterprice Linux 6.3 x64，操作系统平台为x86-64。 Oracle网格管理器和数据库安装版本为11.2.0.3.，并且升级GI和DB至PSU 6,数据共享存储采用ASM管理。 主RAC和备RAC各2个节点，2套RAC采用Active Data Guard做实时同步。
搭建Oracle 11gR2_RAC+ASM+DG
10-10
完整搭建Oracle 11gR2_RAC+ASM+DG ，满满的都是干货。。。
实战完美搭建Oracle 11gR2_RAC+ASM+DG（最新精编版）
05-05
实战完美搭建Oracle 11gR2_RAC+ASM+DG（最新精编版）
ORACLE 11gR2 RAC集群+单实例DG安装部署配置RAC+DG
03-16
oracle 11gr2在linux下的安装配置，包括1.集群规划；2.RAC主库安装实施；3.RAC共享存储安装配置；4.安装GRID集群；5.ASM磁盘安装；6.安装数据库软件；7.安装数据库实例；8.备库安装配置。
11G RAC+DG搭建
congtang0640的博客
10-26 137
在逛博客时发现了一位很认真的博友，坚持写博客，很不容易，挑选了一个RAC+DG系列的博客转发一下。 linux环境下rac的搭建： 一步一步搭建 oracle 11gR2 rac + dg 之前传（一）...
最佳实践：11G-RAC到单实例物理DG配置参考v6.0
huiyangxu blog
10-22 241
最佳实践：11G-RAC到单实例物理DG配置参考v6.0
一步一步搭建oracle,一步一步搭建oracle 11gR2 rac+dg之环境准备(二)
weixin_36149595的博客
04-04 322
vi /home/oracle/.bash_profilevi /home/grid/.bash_profile--------Oracle User----切换到Oracle用户下------[root@rhel_linux_asm ~]# su - oracle[oracle@rhel_linux_asm ~]$ vi ~/.bash_profileexport ORACLE_SID=rac1...
Oracle 11g R2 RAC & DG 安装实战指南
"Oracle+11g+RAC+DG项目实战 - 黄老师的实战教程，专注于在OEL5.5X86_64环境下搭建Oracle 11g R2 (11.2.0.3.0) 数据库集群的详细过程，包括虚拟机配置、操作系统安装和Oracle RAC的安装与配置。文档还提到了相关软件...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

大碗刀削面

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值