1 查看现有归档设置
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/arch
Oldest online log sequence 288
Next log sequence to archive 289
Current log sequence 289
2 查看归档文件的路径
ASMCMD> pwdshow
+data/racdb/archivelog/2021_03_24
ASMCMD> ls
thread_1_seq_411.527.1067991205
thread_1_seq_412.528.1067991205
thread_1_seq_413.532.1068013735
ASMCMD> pwd
+data/arch
ASMCMD> ls -l
Type ... Sys Name
N 1_295_1066505820.dbf => +DATA/RACDB/ARCHIVELOG/2021_03_10/thread_1_seq_295.282.1066827417
N 1_296_1066505820.dbf => +DATA/RACDB/ARCHIVELOG/2021_03_10/thread_1_seq_296.285.1066845617
N 1_297_1066505820.dbf => +DATA/RACDB/ARCHIVELOG/2021_03_10/thread_1_seq_297.289.1066856411
3 修改归档日志的目标指向磁盘组而不指定具体路径
alter system set log_archive_dest_1='LOCATION=+DATA' sid='RACDB2' scope=both;
alter system set log_archive_dest_1='LOCATION=+DATA' sid='RACDB1' scope=both;
alter system switch logfile;
最新生成的归档日志文件在DATA/RACDB/ARCHIVELOG/ ***(日期) 下保存一份了。