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-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>
最新文章
- 第3章 Linux常用命令(1)_文件处理命令
- Python笔记-built-in函数,文件操作,lambda函数
- PHP与memcache安装使用说明
- SpringMVC学习系列(2) 之 经典的HelloWorld实现
- 详解Bootstrap列表组组件
- dubbo Linux 解决:nc: command not found
- 分布式存储系统sheepdog
- Xaml代码格式设置
- 【转】Please define the NDK_PROJECT_PATH variable to point to it
- The Child and Toy
- JSON多层数据添加与访问
- C# LogHelper
- 上海赛区-org.apache.ibatis.type.TypeException: JDBC requires that the JdbcType must be specified for all nullable parameters.
- Oracle:对用户的CREATE、ALTER、GRANT、REVOKE操作练习
- codeforces 1082G - Petya and Graph 	 最大权闭合子图 网络流
- [国家集训队] calc
- 生产环境中tomcat的配置
- random(随机模块)
- mybatis介绍——(一)
- python selenium-webdriver 环境搭建(一)