Before the switchover the application connected to dataguard allows updates on the database.execution of update statements on standby database ? Please re-confirm whether update statements were executed on standby database or primary, because a standby can be used for reporting purposes as Active Dataguard but no updates can be performed.
This converts the Standby to a Primary which is a Read-Write database.
Step 5 Switch the target physical standby database role to the primary role. Issue the following SQL statement on the target physical standby database: SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
Yes I did.This command stops the recovery on the standby database and says that the recovery is stopped for ever. This command is normally used at the time of failover and not at the time of switchover.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH