程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> DGbroker主備切換,dgbroker主備

DGbroker主備切換,dgbroker主備

編輯:Oracle教程

DGbroker主備切換,dgbroker主備


1.檢查DG是否正常

DGMGRL> show configuration;

Configuration - dgc

  Protection Mode: MaxProtection
  Databases:
    atest1 - Primary database
    atest2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

2.如果DG無異常,則可以開始進行切換

DGMGRL> switchover to atest1;
Performing switchover NOW, please wait...
Operation requires a connection to instance "atest" on database "atest1"
Connecting to instance "atest"...
Connected.
Operation requires startup of instance "atest" on database "atest2"
Starting instance "atest"...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Database mounted.
Database opened.
Operation requires shutdown of instance "atest" on database "atest1"
Shutting down instance "atest"...
Unable to connect to database
ORA-12545: Connect failed because target host or object does not exist

Failed.
Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover:
    shut down instance "atest" of database "atest1"
    start up instance "atest" of database "atest1"

如提示,需要對數據庫信息手動的啟動或者重啟

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved