oracle16032解决办法,ORA-16032和ORA-07286 LOG_ARCHIVE_DEST_1没生效

主备切换在备库startup时出现归档路径没写到spfile里...

注意：修改参数时最好带上scope=spfile或scope=both，以免重启出现异常。

sql> startup mount

ora-16032: parameter log_archive_dest_1 destination string cannot be translated

ora-07286: sksagdi: cannot obtain device information.

linux-x86_64 error: 2: no such file or directory

sql>

当前spfile里面识别的，却没这个路径

[oracle@test154 dbs]$ strings spfiletest154.ora |grep dest_1

*.log_archive_dest_1='location=/u01/app/oracle/oradata/testdb/flash_recovery_area valid_for=(all_logf

真正归档路径是下面

[root@test154 ~]# ls -l/u01/app/oracle/oradata/flash_recovery_area

-rw-r-----. 1 oracle oinstall 1024 nov 6 15:04 arch_959881329_1_1613.arc

-rw-r-----. 1 oracle oinstall 1536 nov 6 15:04 arch_959881329_1_1614.arc

-rw-r-----. 1 oracle oinstall 1536 nov 6 15:04 arch_959881329_1_1615.arc

-rw