standby down了,所以重启报错,ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated :
1,重启报错信息
SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
SQL>
2,尝试重新创建spfile
SQL> create pfile from spfile ;
File created.
SQL> create spfile from pfile;
File created.
SQL> startup;
ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
SQL>
SQL> startup mount
ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
SQL>
SQL> startup nomount
ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
SQL>
没有成功,还是一样报错。
3,由于数据库是shutdown的,所以无法通过sql命令去查看路径,不过可以尝试strings spfile的方式去查看下LOG_ARCHIVE_DEST_3的路径
[oracle@localhost dbs]$ strings spfile*.ora|grep dest_3
*.log_archive_dest_3='LOCATION=/data/oracle/oradgdata/standby_archive VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=pddgunq'
[oracle@localhost dbs]$
这个路径/data/oracle/oradgdata/standby_archive不存在,需要创建
[oracle@localhost ~]$ cd $ORACLE_HOME
[oracle@localhost dbhome_1]$ cd dbs
[oracle@localhost dbs]$ mkdir -p /data/oracle/oradgdata/standby_archive
[oracle@localhost dbs]$
4,再去startup nomount,OK。
[oracle@localhost dbs]$ rlwrap sqlplus "/ as sysdba"
rlwrap: warning: your $TERM is 'xterm' but rlwrap couldn't find it in the terminfo database. Expect some problems.
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 27 18:39:27 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size 2213136 bytes
Variable Size 3489663728 bytes
Database Buffers 1811939328 bytes
Redo Buffers 40914944 bytes
SQL>
总结原因:是因为磁盘故障,所以不识别原来的路径;而挂载坏磁盘卸载后,加入新磁盘,也需要重新创建归档路径。
ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated
最新推荐文章于 2022-12-06 23:31:52 发布