故障处理｜无法连接到主数据库，使用 DGMGRL 进行故障转移

在今天的文章中，我将讨论如何使用 DGMGRL 执行故障转移。

如果我们无法连接到主数据库，我们将连接到备用数据库并执行故障转移过程，如下所示。

$dgmgrl sys/<password>@teststby
 
DGMGRL> FAILOVER TO teststby;
Performing failover NOW, please wait...
Failover succeeded, new primary is "teststby"

如果旧Primary开启了闪回功能，我们将旧Primary配置为standby，如下。如果没有开启闪回功能，我们会重新安装 Data Guard。

DGMGRL> REINSTATE DATABASE testdb
Reinstating database “testdb”, please wait…
Operation requires shutdown of instance “testdb” on database “testdb”
Shutting down instance “testdb”…
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance “testdb” on database “testdb”
Starting instance “testdb”…
ORACLE instance started.
Database mounted.
Continuing to reinstate database “testdb” …
Operation requires shutdown of instance “testdb” on database “testdb”
Shutting down instance “testdb”…
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance “testdb” on database “testdb”
Starting instance “testdb”…
ORACLE instance started.
Database mounted.
Continuing to reinstate database “testdb” …
Reinstatement of database “testdb” succeeded

原文标题：Failover Using DGMGRL
原文作者：Melek Durdu
原文链接：https://dbtut.com/index.php/2022/10/28/failover-using-dgmgrl/