Skip to Content

Remote Log Archive Destination

Hi Experts,

     How can I add additional log archive destination which is remote server.

     I tried to use the following below but i throws me an error. please help

    SQL>alter database noarchivelog;

    SQL>shutdown immediate

    SQL>startup

    SQL>alter system set log_archive_dest_1='Service=PRD_Z' scope=spfile;

    SQL>shutdown immediate

    SQL>startup mount

     ORA-16019: cannot use LOG_ARCHIVE_DEST_2 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DU

     PLEX_DEST


     or my procedures are wrong? please help me or tell me how to add additional archive destination(remote server)

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 15, 2016 at 08:30 AM

    from the error, it seems that you ave set the "old and deprecated" parameter LOG_ARCHIVE_DEST.

    You should unset this before starting using LOG_ARCHIVE_DEST_n

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member James Elvin Hizon

      James Elvin Hizon wrote:

      Hi Sir Fidel,

           So what im going to do are

               SQL> alter system set log_archive_dest='';

                SQL> alter system set log_archive_dest_1='';

           before setting the parameters?

      Thanks!

      no, you have to set log_archive_dest_1 to the directory you want to store the primary copy of the redo logs. and you have to RESET (different than setting to nothing) the log_atchive_dest