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;