oracle数据库switch,Oracle 19C Data Guard基础运维-02 Switchovers(物理)

Oracle 19C Data Guard

基础运维

-02

S

witchover

s(

物理

)

原主库

原备库

Switchovers

新主库

新备库

192.168.31.90

192.168.31.100

192.168.31.100

192.168.31.90

cjcdb

chendb

chendb

cjcdb

原理：

Figure 9-1 Oracle Data Guard Configuration Before Switchover

Figure 9-2 Standby Databases Before Switchover to the New Primary Database

Figure 9-3 Oracle Data Guard Environment After Switchover

Performing a Switchover to a Physical Standby Database

31.90

主库

SQL> select database_role,protection_level,protection_mode from v$database;

DATABASE_ROLE

PROTECTION_LEVEL     PROTECTION_MODE

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

PRIMARY

MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

31.100

备库

SQL> select database_role,protection_level,protection_mode from v$database;

DATABASE_ROLE

PROTECTION_LEVEL     PROTECTION_MODE

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

PHYSICAL STANDBY MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

1.

验证目标备用数据库是否已准备好进行切换。

Verify that the target standby database is ready for switchover.

31.90

主库

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

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

TO STANDBY

或

SQL> alter database switchover to chendb verify;

Database altered

2.

在主数据库

CJCDB

上启动切换，方法是发出以下命令

Initiate the switchover on the primary database,

CJCDB

, by issuing the following

31.90

主库

SQL> alter database switchover to chendb;

Database altered.

3.

在新的主数据库

chendb

上发出以下

SQL

语句以打开它。

Issue the following SQL statement on the new primary database,

CHICAGO

, to open

it.

SQL> alter database open;

4.

发出以下

SQL

语句以装载新的物理备用数据库

CJCDB

：

Issue the following SQL statement to mount the new physical standby database,

BOSTON

:

SQL>startup mount;

或者，如果

CJCDB

是Oracle Active Data Guard物理备用数据库，则发出以下SQL语句以只读方式打开它：

Or, if

BOSTON

is an Oracle Active Data Guard physical standby database, then

issue the following SQL statement to open it read only:

SQL> STARTUP;

5

.

在新的物理备用数据库

CJCDB

上启动Redo Apply

。例如：

Start Redo Apply on the new physical standby database. For example:

3.90

新备库

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

SQL> select database_role,protection_level,protection_mode from v$database;

DATABASE_ROLE

PROTECTION_LEVEL     PROTECTION_MODE

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

PHYSICAL STANDBY MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

3.100

新主库

SQL> select database_role,protection_level,protection_mode from v$database;

DATABASE_ROLE

PROTECTION_LEVEL     PROTECTION_MODE

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

PRIMARY

MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

同步测试：

新主库chendb:

SQL> create table test2 as select level as id from dual connect by level <=3;

新备库cjcpdb:

SQL> select * from test2;

ID

----------

1

2

3

欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！