3节点的rac,在其中一个节点上修改归档路径
SQL> connect / as sysdba
Connected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 92
Next log sequence to archive 93
Current log sequence 93
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+REDO/ARC' SCOPE=both;
System altered.
尝试切换日志:
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
新归档目录产生的文件
ASMCMD> pwd
+redo/arc
ASMCMD> ls
1_93_1146388330.dbf
1_94_1146388330.dbf
1_95_1146388330.dbf
1_96_1146388330.dbf
1_97_1146388330.dbf
2_93_1146388330.dbf
2_94_1146388330.dbf
2_95_1146388330.dbf
2_96_1146388330.dbf
3_40_1146388330.dbf
3_41_1146388330.dbf
3_42_1146388330.dbf
3_43_1146388330.dbf
3_44_1146388330.dbf
3_45_1146388330.dbf
旧归档目录产生的文件
ASMCMD> pwd
+redo/slnngk/ARCHIVELOG/2023_09_27
ASMCMD> ls
thread_1_seq_90.375.1148633665
thread_1_seq_91.377.1148641801
thread_1_seq_92.379.1148641803
thread_1_seq_93.382.1148656193
thread_1_seq_94.383.1148656199
thread_1_seq_95.389.1148656245
thread_1_seq_96.394.1148656609
thread_1_seq_97.395.1148656613
thread_2_seq_89.376.1148633665
thread_2_seq_90.378.1148641801
thread_2_seq_91.380.1148643407
thread_2_seq_92.381.1148643409
thread_2_seq_93.384.1148656233
thread_2_seq_94.385.1148656235
thread_2_seq_95.390.1148656245
thread_2_seq_96.393.1148656509
thread_3_seq_37.374.1148633661
thread_3_seq_38.361.1148642203
thread_3_seq_39.360.1148642203
thread_3_seq_40.386.1148656237
thread_3_seq_41.387.1148656239
thread_3_seq_42.388.1148656243
thread_3_seq_43.391.1148656353
thread_3_seq_44.392.1148656509
thread_3_seq_45.396.1148656675