设为首页 加入收藏

TOP

oracle 11g dataguard 使用dgbroker管理主备切换以及快速failover方法讲解(六)
2018-01-17 13:05:42 】 浏览:665
Tags:oracle 11g dataguard 使用 dgbroker 管理 切换 以及 快速 failover 方法 讲解
cle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys

Password:

Connected.

DGMGRL> ENABLE FAST_START FAILOVER;

Enabled.

DGMGRL> SHOW FAST_START FAILOVER;

Fast-Start Failover: ENABLED

  Threshold:          30 seconds

  Target:             JAKKI

  Observer:           cube

  Lag Limit:          30 seconds (not in use)

  Shutdown Primary:   TRUE

  Auto-reinstate:     TRUE

  Observer Reconnect: (none)

  Observer Override:  FALSE

Configurable Failover Conditions

  Health Conditions:

    Corrupted Controlfile          YES

    Corrupted Dictionary           YES

    Inaccessible Logfile            NO

    Stuck Archiver                  NO

    Datafile Offline               YES

  Oracle Error Conditions:

    (none)

switch over 演示:

DGMGRL> switchover to 'JAKKI';

Performing switchover NOW, please wait...

Operation requires a connection to instance "JAKKI" on database "JAKKI"

Connecting to instance "JAKKI"...

Connected.

New primary database "JAKKI" is opening...

Operation requires startup of instance "CUBE" on database "CUBE"

Starting instance "CUBE"...

ORACLE instance started.

Database mounted.

Database opened.

Switchover succeeded, new primary is "JAKKI"

DGMGRL> show configuration;

Configuration - DRSolution

  Protection Mode: MaxAvailability

  Databases:

    JAKKI - Primary database

    CUBE  - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

failover 测试:

DGMGRL> connect sys/password@jakki;

Connected.

DGMGRL> failover to 'JAKKI';

Performing failover NOW, please wait...

Failover succeeded, new primary is "JAKKI"

DGMGRL> show configuration;

Configuration - DRSolution

  Protection Mode: MaxAvailability

  Databases:

    JAKKI - Primary database

      Warning: ORA-16817: unsynchronized fast-start failover configuration

    CUBE  - (*) Physical standby database (disabled)

      ORA-16661: the standby database needs to be reinstated

Fast-Start Failover: ENABLED

Configuration Status:

WARNING

原主库重新启动至mount状态:

[oracle@cube ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 4 15:56:39 2018

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

Connected.

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  839282688 bytes

Fixed Size                  2257880 bytes

Variable Size             545262632 bytes

Database Buffers          289406976 bytes

Redo Buffers                2355200 bytes

Database mounted.

重新将

首页 上一页 3 4 5 6 下一页 尾页 6/6/6
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇oracle数据库创建表空间和用户并.. 下一篇MySQL 5.6.33 主从复制与主主复制

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目