rac庫與單機physical standby 之間的switchover

Rac 操作：

   關閉 22 節點：

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE,PROTECTION_MODE    from v$database;

 

 

NAME      DB_UNIQUE_NAME                 OPEN_MODE  DATABASE_ROLE

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

PROTECTION_MODE

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

HELLODB   std01                          READ WRITE PRIMARY

MAXIMUM PERFORMANCE

 

 

SQL> SQL>

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down

 

21 節點

SQL> SELECT * FROM V$DATAGUARD_STATS;

 

 

no rows selected

 

SQL> SQL>

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE,PROTECTION_MODE    from v$database;

 

 

NAME      DB_UNIQUE_NAME                 OPEN_MODE  DATABASE_ROLE    PROTECTION_MODE

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

HELLODB   std01                          READ WRITE PRIMARY          MAXIMUM PERFORMANCE

 

SQL> SQL>

SQL>

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 

 

SWITCHOVER_STATUS

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

TO STANDBY

 

SQL> SQL>

SQL>

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

 

 

 

Database altered.

 

SQL> SQL> SQL>

SQL>

SQL> shutdown immediate;

ORA-01507: database not mounted

 

 

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

 

Total System Global Area 4294967296 bytes

Fixed Size                  2101808 bytes

Variable Size             788532688 bytes

Database Buffers         3489660928 bytes

Redo Buffers               14671872 bytes

Database mounted.

SQL> alter database recover managed standby database disconnect from session using current logfile;

 

Database altered.

 

單機52 操作

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;

 

 

NAME      DB_UNIQUE_NAME                 OPEN_MODE  DATABASE_ROLE

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

HELLODB   pri                            MOUNTED    PHYSICAL STANDBY

 

1 row selected.

 

SQL> SQL>

SQL>

SQL> recover managed standby database disconnect from session;

Media recovery complete.

SQL>  SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 

 

SWITCHOVER_STATUS

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

SESSIONS ACTIVE

 

1 row selected.

 

SQL> SQL>

SQL>

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

*

ERROR at line 1:

ORA-01013: user requested cancel of current operation

 

 

 

SQL> alter database recover managed standby database cancel;

 

Database altered.

 

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

 

Database altered.

 

SQL> ALTER DATABASE OPEN;

 

Database altered.

 

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 

SWITCHOVER_STATUS

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

TO STANDBY

 

1 row selected.

 

SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;

 

NAME      DB_UNIQUE_NAME                 OPEN_MODE  DATABASE_ROLE

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

HELLODB   pri                            READ WRITE PRIMARY

 

1 row selected.

 

SQL> alter system switch logfile;