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>

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

转载于:http://blog.itpub.net/10856805/viewspace-1029086/