重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-16032 归档路径无法识别 [打印本页]

作者: denglj 时间: 2021-11-30 22:53
标题: ORA-16032 归档路径无法识别

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

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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)