archive not shipping from prod to Dr
edited Oct 12, 2011 7:43PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 15 commentsAnswered
Hi,
my archive from production is not getting through to Dr after a shutdown in production site. its been a week now.
enclosed please find the details:
Output of v$archvied_log(DR):
SQL> select sequence#,archived,deleted,status from v$archived_log where sequence# > 137104 order by sequence#;
SEQUENCE# ARC DEL S
---------- --- --- -
137105 YES NO A
137106 YES NO A
137107 YES NO A
137108 YES NO A
137109 YES NO A
137110 YES NO A
137111 YES NO A
137112 YES NO A
137113 YES NO A
137114 YES NO A
137115 YES NO A
SEQUENCE# ARC DEL S
---------- --- --- -
137116 YES NO A
137117 YES NO A
0