5 days back my dataguard was working fine, but now archives stopped shifting on the standby location
5 days back my dataguard was working fine, buit now it is giving issue, archives are not shifting on the standby location and when i saw on prod under the view v$archive_dest the value of dest_id 2 its status is "error":
select DEST_ID,status from v$archive_dest;
DEST_ID STATUS
---------- ---------
1 VALID
2 ERROR
3 INACTIVE
4 INACTIVE
5 INACTIVE
6 INACTIVE
7 INACTIVE
8 INACTIVE
9 INACTIVE
10 INACTIVE
u can see above output, please help me ASAP.
Regards,
Mukesh