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