var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DataGuard Error
I am trying to use datguard to mmake a standby database for my oracle 9i.When i am trying to open the standby database in the read only mode then i get the following error.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY
ALTER DATABASE RECOVER MANAGED STANDBY
ERROR at line 1:
ORA-16136: Managed Standby Recovery not
Does anyone know the reason for this...
Are you sure it was in managed recovery mode?
select max(sequence#) from v$log_history;
on both databases to see if they are / were in sync.
none of the steps gave error.... and both the primary and secondary give the value as 1.... is it ok
SQL> RECOVER MANAGED STANDBY DATABASE cancel;
ORA-16136: Managed Standby Recovery not active
SQL> RECOVER MANAGED STANDBY DATABASE disconnect from session;
Media recovery complete.
If not My sequence is:
SQL> startup nomount pfile=initSTBY.ora
SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect;
Let me know,
I have done all the three commands told by you and none of them gave error.... it even said media recovery complete......
After the steps i assumed that its done and tried openeing in read only mode to check out if things are really being backued up.... but i got the error
I just want to confirm that you are cancelling recovery before you try to open it read only?
SQL> alter database recover managed standby database cancel;
SQL> alter database open read only;
When in recovery mode have you switched the logfile to confirm that it is indeed replicating the data accross to standby:
SQL> alter system switch logfile;