Database Software

Hi ALL,

9i

rhel5

SQL> show parameter log_archive_dest_2

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2                   string      SERVICE=STBY LGWR ASYNC NOAFFIRM

Does this parameter allows automatic transport of archive logs?

Can I change its value to be able primary database to make archived redo log files sent to the standby server automatically?

> alter system set log_archive_dest_2='service test optional reopen 30';

Because my primary does not seem to send updates to standby db

How to find error of transporting archive logs?

Thanks a lot,

jc