RAC +ADG restart switchover 脚本

已于 2022-10-07 20:24:33 修改
阅读量385 收藏
点赞数
文章标签： oracle 数据库
于 2022-10-07 20:09:02 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jnrjian/article/details/127198194
版权

p2srunonp.sh

#IF P RAC  then 
#sh p2s.sh EMCC EMCCSTBY  passwd 1, 
#IF P RAC and not mount RAC
#sh p2s.sh EMCC EMCCSTBY  passwd 0
#IF P  on ADG then
#sh p2s.sh  EMCCSTBY EMCC  passwd, 


PRI_STAT=`sqlplus -s sys/$3@$1 as sysdba <<EOF
set feedback off
set pages 0
select database_role from v\\$database;
EOF`
echo $PRI_STAT

if [[ $PRI_STAT  != 'PRIMARY' ]]
then echo 'PRIMARY DB INSTANCE IS NOT '$1 ',PLEASE CHECK AGAIN'
exit
fi

PRI_DB=$1
#echo $PRI_DB

STD_STAT=`sqlplus -s sys/$3@$2 as sysdba <<EOF
set feedback off
set pages 0
select database_role from v\\$database;
EOF`

if [[ $STD_STAT  != 'PHYSICAL STANDBY' ]]
then echo 'STANDBY DB INSTANCE IS NOT '$2 ',PLEASE CHECK AGAIN'
exit
fi

STD_DB=$2

#export ORACLE_SID=$STD_DB
sqlplus -s sys/$3@$PRI_DB as sysdba <<EOF
break on db_name
set pages 50
set linesize 100
prompt
prompt Primary Instance
prompt ~~~~~~~~~~~~~~~~
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
EOF


#export ORACLE_SID=$STD_DB
sqlplus -s sys/$3@$STD_DB as sysdba <<EOF
break on db_name
set pages 50
set linesize 100
prompt
prompt Standby Instance
prompt ~~~~~~~~~~~~~~~~
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
EOF


#export ORACLE_SID=$PRI_DB
sqlplus sys/$3@$PRI_DB as sysdba <<EOF
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
prompt Alter database commit to switchover to physical standby with session shutdown;
Alter database commit to switchover to physical standby with session shutdown;
prompt   Primary db now switched to physical standby and down
EOF

#Donot start because TAF without  service need primary stopped 
#sqlplus sys/$3@$PRI_DB as sysdba <<EOF
#prompt startup mount
#startup mount
#prompt recover managed standby database disconnect from session;
#recover managed standby database disconnect from session;
#EOF


#export ORACLE_SID=$STD_DB
sqlplus sys/$3@$STD_DB as sysdba <<EOF
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
prompt alter database commit to switchover to primary WITH SESSION SHUTDOWN;;
alter database commit to switchover to primary WITH SESSION SHUTDOWN;
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
prompt alter database open;
alter database open;
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
EOF


export ORACLE_SID=$1$4
sqlplus / as sysdba <<EOF
SHUTDOWN ABORT
STARTUP MOUNT
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE OPEN;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
EOF

sqlplus sys/$3@$STD_DB as sysdba <<EOF
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
EOF


 

p2sstarts.sh

export ORACLE_SID=$1$2
sqlplus / as sysdba <<EOF
SHUTDOWN ABORT
STARTUP MOUNT
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE OPEN;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v\$database d,v\$instance i;
EOF

srvctl status database -d $1
srvctl stop database -d $1
srvctl status database -d $1
srvctl start database -d $1
srvctl status database -d $1
 

p2sstartrac.sh    ---service不正常可以加上 RAC   都需要

srvctl status database -d $1
srvctl stop database -d $1
srvctl status database -d $1
srvctl start database -d $1
srvctl status database -d $1
 

--------------------------------------------------一步切

[oracle@mesdb-18-11 sh]$ sh ./p2srunonp.sh EMCC EMCCSTBY passwd  1
PRIMARY

Primary Instance
~~~~~~~~~~~~~~~~

      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC3          PRIMARY           TO STANDBY


Standby Instance
~~~~~~~~~~~~~~~~

      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PHYSICAL STANDBY NOT ALLOWED


SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 19:58:27 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCC>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC1          PRIMARY           TO STANDBY

SYS@EMCC>Alter database commit to switchover to physical standby with session shutdown
SYS@EMCC>
Database altered.

SYS@EMCC>Primary db now switched to physical standby and down
SYS@EMCC>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 19:58:37 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PHYSICAL STANDBY NOT ALLOWED

SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PHYSICAL STANDBY NOT ALLOWED

SYS@EMCCSTBY>alter database commit to switchover to primary WITH SESSION SHUTDOWN;
SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PRIMARY           NOT ALLOWED

SYS@EMCCSTBY>alter database open
SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PRIMARY           FAILED DESTINATION

SYS@EMCCSTBY>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 19:59:02 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@EMCC1>ORACLE instance shut down.
SYS@EMCC1>ORACLE instance started.

Total System Global Area 8623485040 bytes
Fixed Size           13623408 bytes
Variable Size         2852126720 bytes
Database Buffers     5704253440 bytes
Redo Buffers           53481472 bytes
Database mounted.
SYS@EMCC1>
Database altered.

SYS@EMCC1>
Database altered.

SYS@EMCC1>
Database altered.

SYS@EMCC1>
Database altered.

SYS@EMCC1>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC1          PHYSICAL STANDBY RECOVERY NEEDED

SYS@EMCC1>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 19:59:40 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PRIMARY           TO STANDBY

SYS@EMCCSTBY>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
[oracle@mesdb-18-11 sh]$ 
[oracle@mesdb-18-11 sh]$ 
[oracle@mesdb-18-11 sh]$ 
[oracle@mesdb-18-11 sh]$ sh ./p2sstarts.sh EMCC  1

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 20:00:38 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCC1>ORACLE instance shut down.
SYS@EMCC1>ORACLE instance started.

Total System Global Area 8623485040 bytes
Fixed Size           13623408 bytes
Variable Size         2852126720 bytes
Database Buffers     5704253440 bytes
Redo Buffers           53481472 bytes
Database mounted.
SYS@EMCC1>
Database altered.

SYS@EMCC1>
Database altered.

SYS@EMCC1>
Database altered.

SYS@EMCC1>
Database altered.

SYS@EMCC1>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC1          PHYSICAL STANDBY NOT ALLOWED

SYS@EMCC1>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
Instance EMCC1 is running on node mesdb-18-11
Instance EMCC2 is not running on node mesdb-18-12
Instance EMCC3 is not running on node mesdb-18-13
Instance EMCC1 is not running on node mesdb-18-11
Instance EMCC2 is not running on node mesdb-18-12
Instance EMCC3 is not running on node mesdb-18-13
Instance EMCC1 is running on node mesdb-18-11
Instance EMCC2 is running on node mesdb-18-12
Instance EMCC3 is running on node mesdb-18-13
 

[oracle@mesdb-18-11 sh]$ sh p2sstartrac.sh EMCC
Instance EMCC1 is running on node mesdb-18-11
Instance EMCC2 is running on node mesdb-18-12
Instance EMCC3 is running on node mesdb-18-13
Instance EMCC1 is not running on node mesdb-18-11
Instance EMCC2 is not running on node mesdb-18-12
Instance EMCC3 is not running on node mesdb-18-13
Instance EMCC1 is running on node mesdb-18-11
Instance EMCC2 is running on node mesdb-18-12
Instance EMCC3 is running on node mesdb-18-13
 

------------------------------------------------两步切

主库RAC 切换分两步，主要是FAN没有使用service下，如果主库mount会连主库

[oracle@mesdg-18-17 sh]$ sh ./p2srunonp.sh EMCCSTBY  EMCC pawwd 0
PRIMARY

Primary Instance
~~~~~~~~~~~~~~~~

      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PRIMARY           TO STANDBY


Standby Instance
~~~~~~~~~~~~~~~~

      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC3          PHYSICAL STANDBY NOT ALLOWED


SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 20:10:07 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PRIMARY           TO STANDBY

SYS@EMCCSTBY>Alter database commit to switchover to physical standby with session shutdown
SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>Primary db now switched to physical standby and down
SYS@EMCCSTBY>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 20:10:12 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCC>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC2          PHYSICAL STANDBY NOT ALLOWED

SYS@EMCC>
Database altered.

SYS@EMCC>
Database altered.

SYS@EMCC>
Database altered.

SYS@EMCC>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC2          PHYSICAL STANDBY TO PRIMARY

SYS@EMCC>alter database commit to switchover to primary WITH SESSION SHUTDOWN;
SYS@EMCC>
Database altered.

SYS@EMCC>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC2          PRIMARY           NOT ALLOWED

SYS@EMCC>alter database open
SYS@EMCC>
Database altered.

SYS@EMCC>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC2          PRIMARY           FAILED DESTINATION

SYS@EMCC>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 20:10:40 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@EMCCSTBY0>ORACLE instance shut down.
SYS@EMCCSTBY0>ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19c/dbs/initEMCCSTBY0.ora'
SYS@EMCCSTBY0>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SYS@EMCCSTBY0>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SYS@EMCCSTBY0>ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SYS@EMCCSTBY0>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SYS@EMCCSTBY0>select d.dbid dbid, d.name db_name,  i.instance_name inst_name, d.database_role ,SWITCHOVER_STATUS from v$database d,v$instance i
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SYS@EMCCSTBY0>Disconnected

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 20:10:44 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SYS@EMCC>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCC2          PRIMARY           FAILED DESTINATION

SYS@EMCC>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
 

备库为主后分两次

[oracle@mesdg-18-17 sh]$ sh ./p2sstarts.sh EMCCSTBY

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 7 20:11:36 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@EMCCSTBY>ORACLE instance shut down.
SYS@EMCCSTBY>ORACLE instance started.

Total System Global Area 4194303768 bytes
Fixed Size            8904472 bytes
Variable Size          620756992 bytes
Database Buffers     3539992576 bytes
Redo Buffers           24649728 bytes
Database mounted.
SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
Database altered.

SYS@EMCCSTBY>
      DBID DB_NAME   INST_NAME          DATABASE_ROLE    SWITCHOVER_STATUS
---------- --------- ---------------- ---------------- --------------------
2519900446 EMCC      EMCCSTBY          PHYSICAL STANDBY RECOVERY NEEDED

SYS@EMCCSTBY>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
Database is running.
Database is not running.
Database is running.
[oracle@mesdg-18-17 sh]$ 
 

重启RAC

[oracle@mesdb-18-11 sh]$ sh p2sstartrac.sh EMCC
Instance EMCC1 is running on node mesdb-18-11
Instance EMCC2 is running on node mesdb-18-12
Instance EMCC3 is running on node mesdb-18-13
Instance EMCC1 is not running on node mesdb-18-11
Instance EMCC2 is not running on node mesdb-18-12
Instance EMCC3 is not running on node mesdb-18-13
Instance EMCC1 is running on node mesdb-18-11
Instance EMCC2 is running on node mesdb-18-12
Instance EMCC3 is running on node mesdb-18-13
[oracle@mesdb-18-11 sh]$ 

jnrjian
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORACLE ADG自动化切换工具_oradgtool
07-11
测试过的应用环境： 主库：oracle11gr2 RAC 备库：oracle11gr2 单节点HAS 配置文件（config.ini）说明：
RAC+ADG switch over 演练时TNS配置
jnrjian的博客
09-13 771
EMCC =))EMCCSTBY =))EMCCFAN=)#正常RAC 各实例随机连接，不会STBY，switchover 后需要关闭EMCC，否则mount下也是连EMCC#PLSQL DEV下自动切换select 无报错，直接SQLPLUS不行，报错ORA-03114EMCCFO=)))#oci 下配???EMCCOCI=
Oracle ADG自动切换脚本分享
Era666的博客
03-16 1744
为大家分享一个【Oracle ADG自动切换】的脚本，由云和恩墨工程师HongyeDBA编写，支持Switchover、Failover。
Oracle 11g ADG（Active Data Guard）切换脚本的示例
运维人生
04-17 425
在脚本中，首先设置Oracle环境变量，然后检查ADG是否已在当前服务器上启用。接着停止备用服务器上的重做应用，然后执行切换操作并将数据库切换到备用服务器上。最后，在新的主服务器上启动重做应用，并检查切换是否成功。 注意：在使用此脚本之前，请确保已备份所有相关的数据和文件，以及在测试环境中进行测试。
ADG切换脚本
02-29 421
本人主要从事架构优化、系统建设、系统运维等方面的工作，专注于Oracle、Mysql、Redis、PG、OGG等技术和系统建设、运维、优化，欢迎留言或者微信（deadknight9）交流，转载请注明出处。--查看主备库的切换状态。
Oracle 19c rac+adg.docx
12-21
Oracle 19c RAC + ADG 配置与设置 Oracle 19c 是 Oracle 公司最新的数据库管理系统版本，提供了许多新的特性和改进。其中，RAC（Real Application Clusters）和ADG（Automatic Data Guard）是 Oracle 19c 中两个...
部署安装Oracle 19c rac+adg完美手册
最新发布
07-24
### 部署安装Oracle 19c RAC+ADG完美手册 #### 一、Oracle 19c 概述 Oracle 19c作为Oracle公司的最新版本，集成了诸多创新特性与优化功能，旨在提供更为高效稳定的数据管理服务。在众多特性中，RAC（Real ...
RAC+ADG（数据文件放本地） (1).docx
10-22
RAC+ADG（数据文件放本地） (1).docx
Oracle19c RAC+ RACDG配置详细部署文档
07-13
总的来说，Oracle 19c RAC+RACDG的配置是一个复杂的过程，需要对数据库架构、操作系统、网络以及故障恢复策略有深入理解。通过细致的规划、配置和维护，可以构建出一个强大且高度可用的数据库环境，以满足上亿级生产...
Oracle rac+dg的switchover和failover步骤
jzzw的博客
07-22 1171
环境： 主库为双节点RAC，备库为单节点+ASM 数据库版本为11.2.0.4 switchover: 1.rac2节点 shutdown immediate; 2.rac1节点 alter database commit to switchover to physical standby with sess...
Oracle Data Guard 主备角色切换（rac to rac的adg架构）
文牧之的博客
02-20 2497
Oracle Data Guard 主备切换（rac to rac的adg架构） 一、Switchover（可逆） 一般SWITCHOVER切换都是计划中的切换，特点是在切换后，不会丢失任何的数据，而且这个过程是可逆的，整个DATA GUARD环境不会被破坏，原来DATA GUARD环境中的所有物理和逻辑STANDBY都可以继续工作。 在进行DATA GUARD的物理STANDBY切换前需要注意的...
ADG环境搭建
weixin_30919429的博客
07-22 653
一：实验环境介绍PC机系统： CentOS 6.5（64位）数据库版本： Oracle 11gR2 11.2.0.4 （64位）IP地址规划：主数据库10.110.9.41 SID：orapridb_name:orapridb_unique_name：orapri备份数据库10.110.9.40SID：orastddb_name:orapridb_unique_name：orastd二...
oracle adg switch over,Oracle11gr2_ADG管理之switchover补充
weixin_31176383的博客
04-10 211
之前演示的switchver总是提示下面的错误,并且需要人工干预:DGMGRL> switchover to snewtest;Warning: You are no longer connected to ORACLE.Please complete the following steps to finish switchover:start up instance "newtest" o...
ORACLE RAC+ADG(主备RAC duplicate)
xielong8866的博客
10-09 3509
ORACLE RAC+ADG(主备RAC duplicate)
双RAC主备切换流程
xielong8866的博客
10-09 1509
双RAC 主备切换测试
Oracle - ADG主备切换
m0_53148885的博客
10-28 2679
ADG主备切换
GoldenGate 传统抽取进程随 DataGuard 主备快速切换的方案（ADG 模式）
weixin_30706507的博客
11-09 299
环境描述： 1.节点描述 节点 IP 节点描述 11.6.76.221 GG 抽取端 / DG 节点，数据库版本号为 Oracle-11.2.0.3，与 11.6.76.222 组成 DataGuard。 11.6.76.222 DG 节点，数据库版本号为 Oracle-11.2.0.3，与 11.6.76.221 组成 DataGuar...
oracle adg主备手工切换11g和12c通用
kadwf123的专栏
10-16 2658
1、主库 select open_mode,database_role,protection_mode,protection_level,switchover_status from v$database; alter system switch logfile; alter system archive log current; alter database commit to switc...
搭建两套RAC+ADG
06-12
好的，这是一个比较具体的问题，需要一些背景信息才能够回答。首先，RAC是Oracle提供的一种集群技术，可以提高数据库的可用性和性能。ADG是Oracle提供的一种数据保护技术，可以在主数据库失效时，自动将备份数据库切换为可读写状态，以保证业务的连续性。 如果您想要搭建两套RAC+ADG，那么需要先确定您的硬件和网络环境是否满足Oracle的要求。具体来说，您需要至少两台服务器，每台服务器上都要安装Oracle数据库软件，并且需要满足Oracle的硬件和网络要求。 一般来说，搭建RAC+ADG需要经过以下步骤： 1. 配置共享存储：RAC需要共享存储来保证数据一致性，您需要选择一种适合您的共享存储技术，并按照Oracle的要求进行配置。 2. 安装Oracle Clusterware：Oracle Clusterware是一个集群管理软件，您需要在每台服务器上安装并进行配置。 3. 安装Oracle数据库软件：在每台服务器上安装Oracle数据库软件，并进行配置。 4. 配置RAC：按照Oracle的要求，对RAC进行配置，包括网络配置、实例配置等。 5. 配置ADG：按照Oracle的要求，对ADG进行配置，包括备份数据库的配置、数据同步配置等。 总之，搭建RAC+ADG需要一定的技术水平和经验，建议您在搭建前充分了解Oracle的要求和建议，并选择适合您的硬件和网络环境的方案。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值