4 Replies Latest reply: Apr 23, 2013 3:06 AM by Mihael RSS

    changing log_archive_dest_1 on standby

    user8875620
      I am currently writing archives on the standby database to a normal file system path. /some_path

      I want to change to an ASM path: +MYDG_REC

      When I change it,
      SQL> alter system set log_archive_dest_1='LOCATION=+MYDG_REC/' scope=both;

      I no longer see any logs being written. I don't see any errors on primary database, standby database, asm alert logs.

      My standby database's datafiles are already on the same ASM instance, but on another diskgroup: +MYDG_DATA

      When I change it back to the normal file system,
      SQL> alter system set log_archive_dest_1='LOCATION=/some_path/' scope=both;
      The logs are written again.

      How do I go about troubleshooting this?