oracle11gdataguard主备切换

1.检查主备的环境

创新互联坚持“要么做到，要么别承诺”的工作理念，服务领域包括：网站设计制作、做网站、企业官网、英文网站、手机端网站、网站推广等服务，满足客户于互联网时代的定襄网站设计、移动媒体设计的需求，帮助企业找到有效的互联网解决方案。努力成为您成熟可靠的网络建设合作伙伴！

dg1节点:

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/oradata/tong/archive

Oldest online log sequence 59

Next log sequence to archive 61

Current log sequence 61

SQL>

dg2节点:

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/oradata/tong/archive

Oldest online log sequence 60

Next log sequence to archive 0

Current log sequence 61

SQL>

2.查看主备的角色

dg1节点(primary角色):

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

TO STANDBY PRIMARY

SQL>

dg2节点(standby角色):

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

NOT ALLOWED PHYSICAL STANDBY

SQL>

3.在主库上执行切换命令(primary节点)

SQL> alter database commit to switchover to physical standby; --将primary角色转换为standby角色

Database altered.

SQL> shutdown immediate --关闭数据库,启动到mount状态

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount

Total System Global Area 830930944 bytes

Fixed Size 2217912 bytes

Variable Size 545261640 bytes

Database Buffers 281018368 bytes

Redo Buffers 2433024 bytes

Database mounted.

SQL> select switchover_status,database_role from v$database; --查看目前primary角色的状态

SWITCHOVER_STATUS DATABASE_ROLE

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

TO PRIMARY PHYSICAL STANDBY

SQL>

4.在备库上执行(standby节点)

SQL> select switchover_status,database_role from v$database; --查看standby备库角色的状态

SWITCHOVER_STATUS DATABASE_ROLE

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

TO PRIMARY PHYSICAL STANDBY

SQL> alter database commit to switchover to primary; --将备库的角色修改为primary

Database altered.

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

NOT ALLOWED PRIMARY

SQL> alter database open; --打开数据库

Database altered.

SQL>

5.在备库上执行(standby节点)

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

RECOVERY NEEDED PHYSICAL STANDBY

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; --修改以前主库为日志应用

Database altered.

SQL>

6.测试主备节点是否切换成功

dg2节点(primary角色):

SQL> select * from tt;

----------

6 rows selected.

SQL> insert into tt values(8);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from tt where a=8;

----------

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/oradata/tong/archive

Oldest online log sequence 78

Next log sequence to archive 80

Current log sequence 80

SQL>

dg1节点(standby角色):

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/oradata/tong/archive

Oldest online log sequence 79

Next log sequence to archive 0

Current log sequence 80

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> select * from tt;

----------

7 rows selected.

SQL>

分享文章：oracle11gdataguard主备切换
标题链接：https://www.cdcxhl.com/article26/pggicg.html

成都网站建设公司_创新互联，为您提供企业网站制作、品牌网站设计、营销型网站建设、动态网站、云服务器、响应式网站

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源：创新互联

猜你还喜欢下面的内容