archivelog not applied in my stand-by basis-How to synchone it.
edited Dec 22, 2011 7:00PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 comments
Hi,
I have several files archivelog not applied in my stand-by basis: I will try to force the two to synchronize base and this is the approach
I'm going into the standby
SQL> select process,status,client_process,sequence#,block#,active_agents,known_agents
from v$managed_standby;
PROCESS STATUS CLIENT_P SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
--------- ------------ -------- ---------- ---------- ------------- ------------
ARCH WRITING ARCH 674073 264193 0 0
ARCH CLOSING ARCH 674072 612353 0 0
MRP0 APPLYING_LOG N/A 673074 614395 0 0
RFS IDLE UNKNOWN 0 0 0 0
RFS WRITING LGWR 674074 204802 0 0
SQL>connect as sysdba
SQL>shutdown immediate
---Copy the primary archivelog database to se stand by archivelog
SQL>startup nomount
I have several files archivelog not applied in my stand-by basis: I will try to force the two to synchronize base and this is the approach
I'm going into the standby
SQL> select process,status,client_process,sequence#,block#,active_agents,known_agents
from v$managed_standby;
PROCESS STATUS CLIENT_P SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
--------- ------------ -------- ---------- ---------- ------------- ------------
ARCH WRITING ARCH 674073 264193 0 0
ARCH CLOSING ARCH 674072 612353 0 0
MRP0 APPLYING_LOG N/A 673074 614395 0 0
RFS IDLE UNKNOWN 0 0 0 0
RFS WRITING LGWR 674074 204802 0 0
SQL>connect as sysdba
SQL>shutdown immediate
---Copy the primary archivelog database to se stand by archivelog
SQL>startup nomount
0