oracle adg switch over,oracle dg 主、备切换SWITCHOVER 全过程记录

最新推荐文章于 2024-04-08 14:58:13 发布
最新推荐文章于 2024-04-08 14:58:13 发布
阅读量172 收藏
点赞数
文章标签： oracle adg switch over

oracle dg 主、备切换SWITCHOVER 全过程记录

[oracle@oraclep trace]$ ifconfig

enp0s3: flags=4163 mtu 1500

inet 10.0.2.15 netmask 255.255.255.0 broadcast 10.0.2.255

inet6 fe80::64d8:a56d:a1af:ef20 prefixlen 64 scopeid 0x20

ether 08:00:27:23:25:0d txqueuelen 1000 (Ethernet)

RX packets 313 bytes 25282 (24.6 KiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 475 bytes 37678 (36.7 KiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

enp0s8: flags=4163 mtu 1500

inet 192.168.56.118 netmask 255.255.255.0 broadcast 192.168.56.255

inet6 fe80::283a:c36b:b773:c4d8 prefixlen 64 scopeid 0x20

inet6 fe80::3765:e61f:d653:f584 prefixlen 64 scopeid 0x20

ether 08:00:27:ae:62:fc txqueuelen 1000 (Ethernet)

RX packets 992188 bytes 1473325892 (1.3 GiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 47580 bytes 30037450 (28.6 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

lo: flags=73 mtu 65536

inet 127.0.0.1 netmask 255.0.0.0

inet6 ::1 prefixlen 128 scopeid 0x10

loop txqueuelen 1000 (Local Loopback)

RX packets 13897 bytes 1135717 (1.0 MiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 13897 bytes 1135717 (1.0 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:39:43 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

TO STANDBY PRIMARY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 11:42:57 2019

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:45:47 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

NOT ALLOWED PHYSICAL STANDBY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:46:02 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

no rows selected

SQL> insert into test values(1,2);

1 row created.

SQL> commit;

Commit complete.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:45:34 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:46:57 2019

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

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

Process ID: 0

Session ID: 0 Serial number: 0

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:47:15 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

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

Database altered.

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

NOT ALLOWED PHYSICAL STANDBY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:48:18 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

ID NUMS

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

1 2

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:48:31 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> insert into test values(1,3);

1 row created.

SQL> insert into test values(1,4);

1 row created.

SQL> insert into test values(1,5);

1 row created.

SQL> commit;

Commit complete.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:46:51 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:48:59 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

ID NUMS

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

1 3

1 4

1 5

1 2

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:52:31 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ WRITE PRIMARY TO STANDBY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:48:55 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:52:48 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ ONLY WITH APPLY PHYSICAL STANDBY NOT ALLOWED

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:53:05 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ WRITE PRIMARY TO STANDBY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

Database altered.

SQL> shutdown immdiate;

SP2-0717: illegal SHUTDOWN option

SQL> shutdown immdiate

SP2-0717: illegal SHUTDOWN option

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:54:09 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> STARTUP MOUNT;

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate

ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:54:40 2019

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

Connected to an idle instance.

SQL> STARTUP MOUNT;

ORACLE instance started.

Total System Global Area 768294912 bytes

Fixed Size 2232312 bytes

Variable Size 457179144 bytes

Database Buffers 306184192 bytes

Redo Buffers 2699264 bytes

Database mounted.

SQL> SELECT OPEN_MODE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE SWITCHOVER_STATUS

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

MOUNTED RECOVERY NEEDED

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:52:44 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:55:14 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ ONLY WITH APPLY PHYSICAL STANDBY SESSIONS ACTIVE

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:56:13 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

*

ERROR at line 1:

ORA-01665: control file is not a standby control file

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:56:49 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

MOUNTED PHYSICAL STANDBY RECOVERY NEEDED

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Database altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 0

Next log sequence to archive 0

Current log sequence 0

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:55:11 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:57:48 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 43

Next log sequence to archive 45

Current log sequence 45

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:58:45 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 44

Next log sequence to archive 0

Current log sequence 45

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

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

Database altered.

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ ONLY WITH APPLY PHYSICAL STANDBY NOT ALLOWED

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 14:00:07 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

ID NUMS

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

1 3

1 4

1 5

1 2

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:57:34 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 14:00:37 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

ID NUMS

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

1 3

1 4

1 5

1 2

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 14:01:15 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ WRITE PRIMARY TO STANDBY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 14:01:23 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

ID NUMS

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

1 3

1 4

1 5

1 2

SQL> insert into test select * from test;

4 rows created.

SQL> commit;

Commit complete.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 14:01:54 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

ID NUMS

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

1 3

1 4

1 5

1 2

1 3

1 4

1 5

1 2

8 rows selected.

至此，Switchover切换完成！

总结：Switchover为主、备之间的正常切换，切换前要保证主、备库的数据一致，而且要先主切备，后备切主，避免同时存在两个主库。

©著作权归作者所有：来自51CTO博客作者xingzhehxiang的原创作品，如需转载，请注明出处，否则将追究法律责任

Tiger5G
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORACLE ADG自动化切换工具_oradgtool
07-11
测试过的应用环境： 主库：oracle11gr2 RAC 备库：oracle11gr2 单节点HAS 配置文件（config.ini）说明：
Oracle - ADG主备切换
m0_53148885的博客
10-28 2647
ADG主备切换
Oracle ADG主备切换
最新发布
不会编程的猫星人
04-08 809
Oracle ADG主备切换
Oracle DG Switchover
Lizi_TT的博客
04-29 467
switchover三部曲： 1，切换前数据库环境，旧金山的主库及波士顿的备库 2，切换中，两个备库 3，切换完成，主备角色转换
Oracle DG之Switchover
czmmiao的专栏
12-28 197
物理STANDBY的SWITCHOVER切换会把当前的一个物理STANDBY切换为PRIMARY数据库，而PRIMARY数据库且变成物理STNADBY数据库。 一般SWITCHOVER切换都是计划中的切换，特点是在切换后，不会丢失任何的数据，而且这个过程是可逆的，整个DATA GUARD环境不会被破坏，原来DATA GUARD环境中的所有物理和逻辑STANDBY都可以继续工作。 在进行DATA...
Oracle ADG 数据库完整部署、切换、备份、运维手册(绝对干货)
03-08
Oracle ADG 数据库完整部署、切换、备份、运维手册(绝对干货)。 阿里云上部署Oracle ADG，并且带有节点故障自动切换功能。同时，也包括数据库异常故障的处理，比如死锁、数据误删除进行恢复 Oracle ADG DG Broker ...
（绝对干货）Oracle ADG数据库完整部署、切换、备份、运维手册
09-11
阿里云上部署Oracle ADG，并且带有节点故障自动切换功能。同时，也包括数据库异常故障的处理，比如死锁、数据误删除进行恢复
Oracle 11 Dg 一主两备的搭建步骤.docx
05-17
redhat 7.6 oracle 11.0.2.4 DataGuard 搭建详细步骤
Centos7 Oracle19c 一主一备搭建
09-30
Centos7 Oracle19c 一主一备搭建 Oracle 19c 是 Oracle 公司推出的关系数据库管理系统（RDBMS），是目前最流行的数据库管理系统之一。Centos7 是一个基于 Linux 的操作系统，广泛应用于服务器领域。因此，本文将...
ORACLE 数据库RAC环境DG主备不同步问题处理.docx
08-23
总结来说，处理Oracle RAC环境下的DG主备不同步问题，需要对数据库的架构、日志管理以及恢复机制有深入理解。在解决这类问题时，关键步骤包括识别问题的根源，执行适当的恢复操作，并确保在恢复后对系统进行全面检查...
Oracle 12c 部署Data Guard,Switchover和Failover
11-28
Oracle Database 12c 部署Data Guard(ADG、LDG)并实现Switchover和Failover(Rman Duplicate和Broker).pdf
oracle同步数据adg_技术宅 篇四：技术分享第四波之oracle ADG主备库切换
weixin_28716723的博客
12-23 775
技术宅 篇四：技术分享第四波之oracle ADG主备库切换2020-03-15 14:02:511点赞2收藏0评论一、查看gap，如果没有发现明显的gap现象，说明此次的failover不会有数据损失情况。SQL> select thread#, low_sequence#, high_sequence# from v$archive_gap;no rows selected二、确认主、...
oracle 11g ADG做(switchover)切换测试
小黑的博客
03-14 3594
--primary 做如下操作      SQL> alter database commit to switchover to physical standby;      Database altered.      SQL> shutdown immediate   ORA-01012: not logged on   SQL> conn / as sysdba   Con
ORACLE 11.2.0.4 DG （一主一备）主备正常切换手动switchover
qq_22960681的博客
06-19 1434
切换前务必检查当前主库与备库的归档是否是同步的，确认同步正常后再执行切换。查看备库是否可以切换至主库（SWITCHOVER_STATUS的值为TO PRIMARY或者为SESSIONS ACTIVE都可以切换至主库）对主库进行切换（如果SWITCHOVER_STATUS的值为TO STANDBY或者为SESSIONS ACTIVE都可以切换至备库）4、检查新主库及新备库alert日志，观察是否有告警及其他需要注意的日志。3、开启新主库至 open 状态，并检查新主库状态。1、查看主库当前可切换状态。
oracle数据库switch,oracle 11g switchover
weixin_36065817的博客
04-05 489
oracle dataguard搭建请看如下链接 http://www.itopers.com/?p=679 switchover主要是在数据库升级，硬件升级等进行。如下将如何进行switchover： 在prmary将数据库设置为standby SQL alter database commit to switchover to physical standby;Database alteora...
oracle数据库switch,Oracle 19C Data Guard基础运维-02 Switchovers(物理)
weixin_34365042的博客
04-05 141
Oracle 19C Data Guard基础运维-02Switchovers(物理)原主库原备库Switchovers新主库新备库192.168.31.90192.168.31.100192.168.31.100192.168.31.90cjcdbchendbchendbcjcdb原理：Figure 9-1 Oracle Data Guard Configuration Before Switc...
Oracle 一主两从 主从切换（switchover）步骤记录
Hehuyi_In的博客
07-14 4066
网上关于一主两从 switchover的文章特别少，自己测试了一下，做个记录。 数据库IP db_unique_name 原角色 目标角色 192.168.3.224 prodcdb 主库 备库 192.168.3.225 prodcdb_dg 备库 主库
oracle ns,RAC到单实例SWITCHOVER
weixin_35336900的博客
04-03 238
RAC到单实例SWITCHOVER现有RAC(12C)到单实例的物理DATAGUARD，需要SWITCHOVER主库到单实例上 ，使原来的RAC成为备库，单实例备库成为主库.在rac和单实例备库上检查DG的相关参数，确认无误.在RAC上，手动实现switch logfile,然后检查备库是已经应用了相用的logfile,以确保事务完全在备库上应用。SQL> alter system swit...
Oracle DG 手动 SwitchOver & Failover，Failover后利用闪回恢复同步
Hehuyi_In的博客
07-01 6516
一、 概述 Oracle数据库以主/备角色之一运行，可以通过以下方法更改数据库角色： SwitchOver：在主库正常运行时进行，可翻转数据库主备角色。SwitchOver没有数据丢失，通常在预期的主库维护前进行。 Failover：在主库故障时进行，可把备库activate为主库。Failover后主从关系不会自动恢复，可以使用代理的恢复功能恢复主从关系。Failover可能有数据丢失，丢...
手把手教你DBCA搭建Oracle ADG.docx
07-27
本文档是一篇由Oracle DBA专家LuciferLiu撰写的手把手教程，旨在指导读者如何使用DBCA（Database Configuration Assistant）工具在Oracle数据库中搭建ADG（Automatic Data Guard）。Oracle Data Guard是Oracle高可用...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值