Oracle 9i DataGuard Failover 發生ORA-16139

偷懶打算用Standby DB Copy到另一臺Server上做test DB.

結果Failover時候發生ORA-16139 ...

這個系統是Oracle9i, 10GR2之後已經不用再skip了...

[@more@]

Oracle的DataGard Concepts沒發現異樣，上Metalink搜尋了下：

原來如此.

Cause
~~~~~~~

If you are using standby redologs and they are being used then
you should be able to use the command :
sql>recover managed standby database finish
However, if you did not have Standby redolog defined or they were
not being used, then you need another approach.



Fix
~~~~

You can do the finish recovery issuing the "SKIP" attribute which tells it to
skip the standby redo logs which, in this case, aren't being used:

操作如下：

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1594852480 bytes
Fixed Size 742528 bytes
Variable Size 989855744 bytes
Database Buffers 536870912 bytes
Redo Buffers 67383296 bytes
SQL> alter database mount standby database;

Database altered.

SQL> alter database recover managed standby database finish skip wait;

Database altered.

SQL> alter database commit to switchover to primary;

Database altered.

SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1594852480 bytes
Fixed Size 742528 bytes
Variable Size 989855744 bytes
Database Buffers 536870912 bytes
Redo Buffers 67383296 bytes
Database mounted.
Database opened.
SQL>