如果我们原来使用的是log_archive_dest,现在希望使用log_archive_dest_n,那么首先我们必须不使用
log_archive_dest这个参数。
sql>alter system reset log_archive_dest scope=spfile sid='*';
之后我们就可以设置log_archive_dest_n 了,比如:
sql>alter system set log_archvie_dest_1="location=/u01/app/archivelog/dest1/" scope=both;
sql>alter system set log_archive_dest_2="location=/u01/app/archivelog/dest2/" scope=both;
再次查看:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/archivelog/dest2/
Oldest online log sequence 2
Next log sequence to archive 4
Current log sequence 4
我们切换一下日志:
SQL> alter system switch logfile;
System altered.
再到相关目录下去查看:
[oracle@localhost archivelog]$ cd dest1
[oracle@localhost dest1]$ ls
1_3_855555375.dbf
[oracle@localhost dest1]$ cd dest2
-bash: cd: dest2: No such file or directory
[oracle@localhost dest1]$ cd ..
[oracle@localhost archivelog]$ cd dest2
[oracle@localhost dest2]$ ls
1_3_855555375.dbf
我们可以看到在dest1和dest2中产生了两个大小类型名字完全相同的归档日志文件。