Oracle Solution for Error ora-16516

Solution for Oracle Error ORA-16516

ORA-16516: current state is invalid for the attempted operation

What triggered the Error:

The broker may have returned this error for either switchover operations or for database state change operations. If this error was returned for a switchover operation, the broker determined that either: *- The databases changing roles are shut down. *- The primary database is not shipping redo data. *- The standby database that will become the primary database is not applying redo data. If this error was returned for database state change operations, the database state specified was invalid.

What should we do to fix it:

If this error is returned when attempting a switchover operation, make sure that: *- The databases changing roles are started. *- The primary database is shipping redo data. *- The standby database is applying redo data. If this error is returned when attempting a database state change operation, make sure a valid database state is specified.