ORA-16032 归档路径无法识别

denglj

主库启动时报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.