系统：CentOS 7.9
数据库：oracle 11.2.0.4
问题描述：数据库启动时报警ORA-03113，如下所示：
SQL> startup
ORACLE instance started.
Total System Global Area 2455228416 bytes
Fixed Size 2255712 bytes
Variable Size 620758176 bytes
Database Buffers 1811939328 bytes
Redo Buffers 20275200 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 64704
Session ID: 191 Serial number: 3
告警日志显示如下：
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 4062781806
Database mounted in Exclusive Mode
Lost write protection disabled
WARNING: No local destinations have been defined for
archival of the Redo Log.
Completed: ALTER DATABASE MOUNT
Sun Aug 28 13:47:30 2022
ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Sun Aug 28 13:47:30 2022
ARC0 started with pid=20, OS id=65719
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
ARCH: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log switch
Errors in file /u01/app/oracle/diag/rdbms/orcl150/orcl151/trace/orcl151_ora_65717.trc:
ORA-16014: log 2 sequence# 23 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orcl151/redo02.log'
Sun Aug 28 13:47:31 2022
ARC1 started with pid=21, OS id=65722
USER (ospid: 65717): terminating the instance due to error 16014
System state dump requested by (instance=1, osid=65717), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl150/orcl151/trace/orcl151_diag_65684_20220828134732.trc
Dumping diagnostic data in directory=[cdmp_20220828134732], requested by (instance=1, osid=65717), summary=[abnormal instance termination].
Instance terminated by USER, pid = 65717
异常原因：归档路径不可用.
解决过程：
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?/dbs/arch
Oldest online log sequence 23
Next log sequence to archive 23
Current log sequence 25
SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/fast_recovery_area/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcl150';
System altered.
SQL> alter database open;
Database altered.
