DG BROKER 之 REINSTATE DATABASE (把旧主库恢复到备用库)

来源：互联网发布：淘宝返利微信编辑：程序博客网时间：2024/06/05 09:30

DGMGRL> connect sys/oracle@dbsalve;

已连接。

DGMGRL> show configuration;

配置 - DG_BROKER_SALVE

保护模式: MaxAvailability

数据库:

DBSALVE - 主数据库

错误: ORA-16825: 检测到数据库的多个错误或警告, 包括与快速启动故障转移相关的错误或警告

DBMAST - (*) 物理备用数据库 (禁用)

ORA-16661: 需要恢复备用数据库

快速启动故障转移: ENABLED

配置状态:

ERROR

DGMGRL> show configuration verbose;

配置 - DG_BROKER_SALVE

保护模式: MaxAvailability

数据库:

DBSALVE - 主数据库

错误: ORA-16825: 检测到数据库的多个错误或警告, 包括与快速启动故障转移相关的错误或警告

DBMAST - (*) 物理备用数据库 (禁用)

ORA-16661: 需要恢复备用数据库

(*)快速启动故障转移目标

属性:

FastStartFailoverThreshold ='120'

OperationTimeout ='30'

FastStartFailoverLagLimit ='30'

CommunicationTimeout ='180'

ObserverReconnect ='0'

FastStartFailoverAutoReinstate ='TRUE'

FastStartFailoverPmyShutdown ='TRUE'

BystandersFollowRoleChange ='ALL'

ObserverOverride ='FALSE'

ExternalDestination1 =''

ExternalDestination2 =''

PrimaryLostWriteAction ='CONTINUE'

快速启动故障转移: ENABLED

阈值: 120 秒

目标: DBMAST

观察程序: DB-Salve

滞后限制: 30 秒 (未使用)

关闭主数据库: TRUE

自动恢复: TRUE

观察程序重新连接: (无)

观察程序覆盖: FALSE

配置状态:

ERROR

启动备用库

SQL> startup mount;

ORACLE 例程已经启动。

SQL> set linesize 1000

col name format a10;

col db_unique_name format a10;

col open_mode format a20;

col protection_mode format a20;

col database_role format a20;

col switchover_status format a20;

SQL> SELECTNAME,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,DB_UNIQUE_NAMEFROM V$DATABASE;

NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS DB_UNIQUE_

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

DBMAST MOUNTED MAXIMUMAVAILABILITY PRIMARY NOT ALLOWED DBMAST

郁闷还是主库角色

连接上备用库看看情况

DGMGRL> connect sys/oracle@DBMAST;

已连接。

DGMGRL> show configuration verbose;

配置 - DG_BROKER_SALVE

保护模式: MaxAvailability

数据库:

DBSALVE - 主数据库

DBMAST - (*) 物理备用数据库

(*)快速启动故障转移目标

属性:

FastStartFailoverThreshold ='120'

OperationTimeout ='30'

FastStartFailoverLagLimit ='30'

CommunicationTimeout ='180'

ObserverReconnect = '0'

FastStartFailoverAutoReinstate ='TRUE'

FastStartFailoverPmyShutdown ='TRUE'

BystandersFollowRoleChange ='ALL'

ObserverOverride ='FALSE'

ExternalDestination1 =''

ExternalDestination2 =''

PrimaryLostWriteAction ='CONTINUE'

快速启动故障转移: ENABLED

阈值: 120 秒

目标: DBMAST

观察程序: DB-Salve

滞后限制: 30 秒 (未使用)

关闭主数据库: TRUE

自动恢复: TRUE

观察程序重新连接: (无)

观察程序覆盖: FALSE

配置状态:

ORA-16665: 从数据库等待结果时超时

DGM-17017: 无法确定配置状态

情况依旧

看看原来主库的DG信息

[oracle@DB-MASTERtrace]pwd

/u01/app/software/oracle/diag/rdbms/dbmast/DBMAST/trace

[oracle@DB-MASTER trace]ll drcDBMAST.log

-rw-r----- 1 oracle oinstall 2.1M 4月 25 15:25 drcDBMAST.log

04/25/2016 14:33:23

>> Starting Data Guard Brokerbootstrap <<

Broker Configuration File Locations:

dg_broker_config_file1 ="/u01/app/software/oracle/product/11.2.0/db_1/dbs/dr1DBMAST.dat"

dg_broker_config_file2 ="/u01/app/software/oracle/product/11.2.0/db_1/dbs/dr2DBMAST.dat"

04/25/2016 14:33:27

DMON Registering serviceDBMAST_DGB with listener(s)

Broker Configuration: "DG_BROKER_SALVE"

Protection Mode: Maximum Availability

Fast-Start Failover (FSFO): Enabled, flags=0x40051, version=2

Primary Database: DBSALVE (0x01010000)

Standby Database: DBMAST, Enabled Physical Standby (FSFO target) (0x02010000)

04/25/2016 14:33:31

Failed to connect to remote databaseDBSALVE. Error is ORA-12541

Failed to send message to site DBSALVE.Error code is ORA-12541.

database DBMAST unable to contact primarydatabase for version check; status ORA-12541

completing bootstrap of this database

Creating process RSM0

04/25/2016 14:33:34

SQL Execution error=604, sql=[ALTERDATABASE MOUNT]. See error stack below.

ORA-00604: 递归 SQL 级别 1 出现错误

ORA-01100: 数据库已装载

Failed to mount standby database.

Apply Instance for Database DBMAST set toDBMAST

Database Resource SetState Error (16746)

SQL Execution error=604, sql=[ALTERDATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE]. See error stack below.

ORA-00604: 递归 SQL 级别 1 出现错误

ORA-01665: 控制文件不是备用控制文件

Failed to connect to remote databaseDBSALVE. Error is ORA-12541

Failed to send message to site DBSALVE.Error code is ORA-12541.

Command EDIT DATABASE DBMAST SET PROPERTYActualApplyInstance = DBMAST completed

04/25/2016 15:18:57