欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

ORA-16032和ORA-07286 LOG_ARCHIVE_DEST_1没生效

程序员文章站 2022-05-09 15:54:04
主备切换在备库startup时出现归档路径没写到spfile里...注意:修改参数时最好带上scope=spfile或scope=both,以免重启出现异常。SQL> startup mountORA-16032: parameter LOG_ARCHIVE_DEST_1 destination s ......

主备切换在备库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-r-----. 1 oracle oinstall 298496 nov 6 15:13 arch_959881329_1_1616.arc

处理
pfile启动,重建spfile,更新成正确路径,重启ok

[oracle@test154 ~]$ sqlplus / as sysdba

sql*plus: release 11.2.0.4.0 production on 星期三 11月 6 15:31:53 2019

copyright (c) 1982, 2013, oracle. all rights reserved.

connected to an idle instance.

sql> create pfile from spfile;

file created.

参数文件pfile修改log_archive_dest_1为/u01/app/oracle/oradata/flash_recovery_area

sql> create spfile from pfile;

file created.

sql> startup;

oracle instance started.

total system global area 3975139328 bytes
fixed size 2259360 bytes
variable size 2634024544 bytes
database buffers 1325400064 bytes
redo buffers 13455360 bytes
database mounted.
database opened.
sql>