Search This Blog

Friday, February 26, 2010

ORA-16139: media recovery required

Dear All,
During switch physical standby database to primary database i received following error message on (physical standby database)
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required
Solution for the above error message is following
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
SWITCHOVER LATENT

SQL> RECOVER MANAGED STANDBY DATABASE FINISH;
Media recovery complete.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.
Reference: Metalink Note:[ID 219554.1]

1 comment:

shahnawaj said...

i want take user-managed online backup. now first of all put the tablespace in backup mode.for this

alter tablespace users begin backup;

but after this command generated media recovery not enabled


tell me solution
shahnawaj