November 18 2015

ORA-16668

DGMGRL> help convert

Converts a database from one type to another

Syntax:

CONVERT DATABASE <database name> TO
{SNAPSHOT STANDBY|PHYSICAL STANDBY};
DGMGRL> convert database orcl to SNAPSHOT STANDBY;
Converting database “orcl” to a Snapshot Standby database, please wait…
Error: ORA-16668: operation cannot be performed on the fast-start failover target standby database

Failed.
Failed to convert database “orcl”
DGMGRL> disable fast_start failover
Disabled.
DGMGRL> convert database orcl to SNAPSHOT STANDBY;
Converting database “orcl” to a Snapshot Standby database, please wait…
Database “orcl” converted successfully

SQL> ho oerr ora 16668
16668, 00000, “operation cannot be performed on the fast-start failover target standby database”
// *Cause: The database specified for the operation was the fast-start
// failover target standby database.
// *Action: Retry the operation on a different database. Alternatively, disable
// fast-start failover and retry the operation.

 

当启用了fast_start failover之后 就不能转成snapshot standby了 要disable掉才可以

 

 



Copyright 2019. All rights reserved.

Posted 2015年11月18日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *