ORA-16032 归档路径无法识别
更新时间： 2021-12-20 16:58
主库启动时报ORA-16032异常
SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot betranslated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
查看当前spfile归档路径
[oracle@meddoc dbs]$ strings spfileorcl.ora |grep dest_1
*.log_archive_dest_1='location=/u01/app/oracle/oradata/ORCL/archivelogvalid_for=(all_logfiles,all_roles) db_unique_name=ORCL'
实际却没有此路径
[oracle@meddoc dbs]$ cd /u01/app/oracle/oradata/ORCL
-bash: cd: /u01/app/oracle/oradata/ORCL: No such file or directory
查找归档真正路径
[root@meddoc ~]# find / -name *.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_29/o1_mf_1_7_jt9q87b9_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_29/o1_mf_1_8_jt9qbk0h_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_9_jtcg7k1t_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_10_jtcgt4lh_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_11_jtcgt79k_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_12_jtcn5zkv_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_13_jtco4mt4_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_14_jtcp8r0b_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_15_jtcp9qdv_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_16_jtcpb28c_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_17_jtcpvw7s_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2021_11_30/o1_mf_1_18_jtcq4vvb_.arc
解决方案：
[oracle@meddoc ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 30 20:13:48 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create pfile from spfile;
File created.
修改initorcl.ora参数文件log_archive_dest_1为location=/u01/app/oracle/fast_recovery_area/ORCL/archivelog
SQL> create spfile from pfile;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 2405122048 bytes
Fixed Size 2255592 bytes
Variable Size 603981080 bytes
Database Buffers 1778384896 bytes
Redo Buffers 20500480 bytes
Database mounted.
Database opened.
