cancel
Showing results for 
Search instead for 
Did you mean: 

Remote Log Archive Destination

former_member215439
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

former_member215439
Participant
0 Kudos

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!

0 Kudos

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