物理备库failover实验

系统信息：Linux localhost.localdomain 2.6.18-164.el5 #1 SMP Thu Sep 3 03:33:56 EDT 2009 i686 i686 i386 GNU/Linux

数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

主库信息：

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

NAME      DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS    PRIMARY_DB_UNIQUE_NAME         PROTECTION_MODE
--------- ------------------------------ ---------------- -------------------- ------------------------------ --------------------
PHYPRIMA  phyprimary                     PRIMARY          TO STANDBY           phystandby                     MAXIMUM AVAILABILITY

备库信息：

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

NAME      DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS    PRIMARY_DB_UNIQUE_NAME         PROTECTION_MODE
--------- ------------------------------ ---------------- -------------------- ------------------------------ --------------------
PHYPRIMA  phystandby                     PHYSICAL STANDBY NOT ALLOWED          phyprimary                     MAXIMUM AVAILABILITY

实验前准备：

1. 确保没有没有redo transport errors 或者 redo gap存在(备库操作).

SQL> SELECT STATUS, GAP_STATUS FROM V$ARCHIVE_DEST_STATUS where status!='INACTIVE';  

STATUS    GAP_STATUS
--------- ------------------------
VALID
VALID     NO GAP
VALID     NO GAP

同时确保归档文件是否连接

SQL> select thread#, low_sequence#, high_sequence# from v$archive_gap;

no rows selected

如果存在的话，如果主库服务器允许，将列出的归档文件靠备考备库，并通过如下语句注册：

alter database register physical logfile 'filespec1';

2. 确保备库存在于主库想对应的临时文件

主库：

SQL> select file_name,tablespace_name, bytes/1024/1024, status from dba_temp_files;

FILE_NAME                                                    TABLESPACE_NAME                BYTES/1024/1024 STATUS
------------------------------------------------------------ ------------------------------ --------------- -------
/data/oracle/oradata/phyprimary/temp01.dbf                   TEMP                                        20 ONLINE

备库：

SQL> select file_name,tablespace_name, bytes/1024/1024, status from dba_temp_files;

FILE_NAME                                                    TABLESPACE_NAME                BYTES/1024/1024 STATUS
------------------------------------------------------------ ------------------------------ --------------- -------
/data/oracle/oradata/phystandby/temp01.dbf                   TEMP                                        20 ONLINE

3. 确保主库与备库是在最优性能模式下，如果不是，改为最优性能模式

SQL> alter database set standby database to maximize performance;

开始试验：

4. 模拟主库出现意外宕机

SQL> shutdown abort;

ORACLE instance shut down.

5. 在需要failover的备库上进行failover切换（备库操作）

5.1 停止redo apply(可选项)

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

5.2 停止接受redo log(可选项)

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

Database altered.

6 进行数据库failover

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
TO PRIMARY

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

Database altered.

SQL> alter database open;  

Database altered.

SQL> select database_role from v$database;

DATABASE_ROLE
----------------
PRIMARY

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

如果是 READ ONLY状态，则需要重启数据库到READ WRITE状态

7 立即备份新的主库，备份终于一切

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28719055/viewspace-1252931/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28719055/viewspace-1252931/