problemas de aplicação de archives dataguard

[fabiommirandaParticipante]

Eu tenho uma rotina de deleção nos archives na cron do linux

segue os params solicitados:

log_archive_config string dg_config=(STANDBY)
log_archive_dest string
log_archive_dest_1 string location=”/orabckp/archive/PRIM
“, valid_for=(ONLINE_LOGFILE,A
LL_ROLES)
log_archive_dest_10 string
log_archive_dest_2 string service=”(DESCRIPTION=(ADDRESS
_LIST=(ADDRESS=(PROTOCOL=tcp)(
HOST=lnx-oracle-cont)(PORT=152
1)))(CONNECT_DATA=(SERVICE_NAM
E=STANDBY_XPT)(INSTANCE_NAME

NAME TYPE VALUE

---

                                             =STANDBY)(SERVER=dedicated))
                                             )",    LGWR ASYNC NOAFFIRM del
                                             ay=0 OPTIONAL max_failure=0 ma
                                             x_connections=1   reopen=300 d
                                             b_unique_name="STANDBY" regi
                                             ster net_timeout=180  valid_fo
                                             r=(online_logfile,primary_role
                                             )

log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string

NAME TYPE VALUE

---

log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_3 string ENABLE
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable

NAME TYPE VALUE

---

log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string arch_PRIM_%t_%s_%r.log
log_archive_local_first boolean TRUE
log_archive_max_processes integer 5
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE

SQL> select * from v$standby_log;

GROUP# DBID                                        THREAD#  SEQUENCE#      BYTES       USED ARC STATUS     FIRST_CHANGE# FIRST_TIM LAST_CHANGE# LAST_TIME

---

     5 3891203292                                            1     162971  209715200   29111808 YES ACTIVE        1.2370E+10 06-JUL-11   1.2370E+10 06-JUL-11
     6 UNASSIGNED                                        1          0  209715200        512 NO  UNASSIGNED             0                   0
     7 UNASSIGNED                                        1          0  209715200        512 NO  UNASSIGNED             0                   0
     8 UNASSIGNED                                        0          0  209715200        512 YES UNASSIGNED             0                   0
     9 UNASSIGNED                                        0          0  209715200        512 YES UNASSIGNED             0                   0
    10 UNASSIGNED                                       0          0  209715200        512 YES UNASSIGNED             0                   0