设为首页 加入收藏

TOP

oracle 11g dataguard 使用dgbroker管理主备切换以及快速failover方法讲解(五)
2018-01-17 13:05:42 】 浏览:666
Tags:oracle 11g dataguard 使用 dgbroker 管理 切换 以及 快速 failover 方法 讲解
p;     = ''

    LogArchiveTrace                 = '0'

    LogArchiveFormat                = '%t_%s_%r.dbf'

    TopWaitEvents                   = '(monitor)'

Database Status:

DISABLED

DGMGRL> ENABLE CONFIGURATION;

Enabled.

DGMGRL> SHOW CONFIGURATION;

Configuration - DRSolution

  Protection Mode: MaxPerformance

  Databases:

    CUBE  - Primary database

    JAKKI - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

DGMGRL> enable database 'JAKKI';

Enabled.

DGMGRL> show database 'JAKKI';

Database - JAKKI

Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds (computed 1 second ago)

  Apply Lag:       0 seconds (computed 1 second ago)

  Apply Rate:      0 Byte/s

  Real Time Query: ON

  Instance(s):

    JAKKI

Database Status:

SUCCESS

DGMGRL> EDIT DATABASE 'JAKKI' SET PROPERTY 'LogXptMode'='SYNC';

Property "LogXptMode" updated

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Succeeded.

DGMGRL> SHOW CONFIGURATION;

Configuration - DRSolution

  Protection Mode: MaxAvailability

  Databases:

    CUBE  - Primary database

    JAKKI - Physical standby database

DGMGRL> EDIT DATABASE 'CUBE' SET PROPERTY 'LogXptMode'='SYNC';

Property "LogXptMode" updated

DGMGRL> EDIT DATABASE 'JAKKI' SET PROPERTY 'LogXptMode'='SYNC';

Property "LogXptMode" updated

DGMGRL> EDIT DATABASE 'CUBE' SET PROPERTY FastStartFailoverTarget='JAKKI';

Property "faststartfailovertarget" updated

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Succeeded.

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

检查开启fast failover的前提条件:

ALTER SYSTEM SET UNDO_RETENTION=3600 SCOPE=SPFILE;

ALTER SYSTEM SET UNDO_MANAGEMENT='AUTO' SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

SHOW PARAMETER UNDO;

ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320 SCOPE=BOTH;

ALTER DATABASE ARCHIVELOG;

ALTER SYSTEM SET db_recovery_file_dest_size=<size>;

ALTER SYSTEM SET db_recovery_file_dest=<directory-specification>;

ALTER DATABASE FLASHBACK ON;

ALTER DATABASE OPEN;

SQL> select FLASHBACK_ON from v$database;

FLASHBACK_ON

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

NO

SQL> recover managed standby database cancel;

Media recovery complete.

SQL> alter database flashback on

Database altered.

SQL> recover managed standby database using current logfile disconnect;

Media recovery complete.

fast failover 开启:

DGMGRL> START OBSERVER;

Observer started

使用nohup后台开启observer:

[oracle@cube ~]$ nohup dgmgrl sys/password@cube "start observer" &

[1] 2263

[oracle@cube ~]$ nohup: ignoring input and appending output to `nohup.out'

[1]+  Exit 255                nohup dgmgrl sys/password@cube "start observer"

[oracle@cube ~]$ dgmgrl 

DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production

Copyright (c) 2000, 2009, Ora

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

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目