-
Hi,
I don't know why the archive destination in my db is pointing to ..\archive2 instead of ..\archive (a mandatory destination). I want to change it to ..\archive but couldn't do it. Here is the
scenario.
> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\oradata\mydb\archive2
Oldest online log sequence 1999
Next log sequence to archive 2001
Current log sequence 2001
These are the entries in my init file:
##### For archiving if archiving is enabled #####
log_archive_start = true
log_archive_dest_1 = "location=C:\oracle\oradata\mydb\archive MANDATORY"
log_archive_dest_2 = "location=C:\oracle\oradata\mydb\archive2"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
If I want to change my archive destination to ...\mydata\archive (instead of ..\archive2)
directory how would I do that? I tried both of the following commands but none of them work.
SQL> alter system set log_archive_dest='C:\oracle\oradata\mydb\archive';
alter system set log_archive_dest='C:\oracle\oradata\mydb\archive'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n
SQL> alter system archive log start to 'C:\oracle\oradata\mydb\archive';
alter system archive log start to 'C:\oracle\oradata\mydb\archive'
*
ERROR at line 1:
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST
Do I have other options?? Please advise. Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|