on 02-16-2012 12:39 PM
Hi,
I had configured Oracle dataguard and was working fine when both the primary and secondary servers were on the same network. We shifted the standby server to a remote location. Since then the logs were not moving to the standby server. So I took a fresh backup of the primary server and restored on the standby server and created a fresh standby control file. Now, the logs are moving from primary to secondary. There was a gap of 60 logs between the time backup was taken on primary and restored on the secondary. Now those 60 logs are also getting copied to falarch folder. (it is still being copied as it takes time over WAN).
The problem is these logs are not being applied to the database. When I do SQL>select * from v$archive_log; the output is no row selected.
alter database recover managed standby database cancel;
ORA-6136 Managed standby recovery not active
Can anyone please help me to resolve this?
Regards
Ivan
Hello,
We are facing the same issue though our DR is still at same location and gets same error for the command ( ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; ) .
ORA-16136: Managed Standby Recovery not active
We cant find the tracefile or logfile to check the error details. Can you please help us to resolve the issue.
Quick response will be appreciated.
Regards,
Khuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan,
Please check the following
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
Check to see that mrp0 is active and running...
If u do not see the mrp0 process , see why mrp0 has stopped running in saptrace/background ?
Secondly, if the logs are shipped automatically they will be registered in the v$archived_log view
select sequence#, archived, applied from v$archived_log order by sequence#;
Third, if u do not see any errors above....see if the logs get applied manually
recover standby database
Finally check the alert log file for any errors
Thanks,
Salman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan,
What is the version of Oracle?
Did you try the following?
alter database recover mananged standby database disconnect from session;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Br,
Venky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venky,
Yes the logs transferred completely. But when I tried the command ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; I would get the message database altered. But in the saptrace\background I would get the error about the PSAPSR3 tablespace related error. When I checked on the primary this tablespace was 99.3% full. I tried increasing this tablespace in secondary by BRTOOLS, but it would crash every time. Since I could not spend more time in that remote DR site I had to bring the DR server back to primary site.
WIll check next week.
Hello Ivan,
Have you already tried to copy those archives manually to the standby destination?
Best regards,
Thiago
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.