oracle p over,Oracle 10g DataGuard物理主备切换-switchover与failover

第1步、直接备库failover切换

SQL> alter database recover managed standby database finish;

Database altered.查看alert日志Wed Jul 3 10:29:10 2013

alter database recover managed standby database finish

Wed Jul 3 10:29:10 2013

Terminal Recovery: Stopping real time apply

Wed Jul 3 10:29:12 2013

MRP0: Background Media Recovery cancelled with status 16037

Wed Jul 3 10:29:12 2013

Errors in file /Oracle/admin/sdk/bdump/sdk_mrp0_4113.trc:

ORA-16037: user requested cancel of managed recovery operation

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

Wed Jul 3 10:29:14 2013

Errors in file /oracle/admin/sdk/bdump/sdk_mrp0_4113.trc:

ORA-16037: user requested cancel of managed recovery operation

Wed Jul 3 10:29:14 2013

MRP0: Background Media Recovery process shutdown (sdk)

Wed Jul 3 10:29:15 2013

Terminal Recovery: Stopped real time apply

SKIP STANDBY LOGFILE option no longer needed for RECOVERFINISH. Option ignored

Wed Jul 3 10:29:15 2013

Attempt to do a Terminal Incomplete Recovery (sdk)

Wed Jul 3 10:29:15 2013

Media Recovery Start: Managed Standby Recovery (sdk)

Managed Standby Recovery not using Real Time Apply

Media Recovery Waiting for thread 1 sequence 266

Terminal Recovery timestamp is '07/03/2013 10:29:15'

Terminal Recovery: applying standby redo logs.

Terminal Recovery: thread 1 seq# 266 redo required

Terminal Recovery: End-Of-Redo log allocation

MRP: Validating standby redo logfile 4

Wed Jul 3 10:29:15 2013

Media Recovery Log /oracle/oradata/sdk/redo04_standby

Terminal Recovery: log 4 reserved for thread 1 sequence 266

Wed Jul 3 10:29:15 2013

Recovery of Online Redo Log: Thread 1 Group 4 Seq 266 Reading mem 0

Mem# 0: /oracle/oradata/sdk/redo04_standby

Identified End-Of-Redo for thread 1 sequence 266

Terminal Recovery: Updated next available block for thread 1 sequence 266 lno 4 to value 2

Wed Jul 3 10:29:16 2013

Incomplete recovery applied all redo ever generated.

Recovery completed through change 1993928

Wed Jul 3 10:29:16 2013

Media Recovery Complete (sdk)

Terminal Recovery: successful completion

Begin: Standby Redo Logfile archival

End: Standby Redo Logfile archival

Resetting standby activation ID 3126107239 (0xba549c67)

Completed: alter database recover managed standby database finish第2步、再直接备库转换为主库SQL> alter database commit to switchover to primary;第3步、重启备库SQL>shutdown immediateORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.Total System Global Area 419430400 bytesFixed Size 2084456 bytes

Variable Size 184549784 bytes

Database Buffers 226492416 bytes

Redo Buffers 6303744 bytes

Database mounted.

Database opened.

第3步、 查看转换角色SQL> select open_mode,database_role,switchover_status from v$database;OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS

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

READ WRITE PRIMARYNOT ALLOWED