on 01-15-2016 8:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.