ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated, logarchivedest1

ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated, logarchivedest1
Standby down, so restart error, ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated:


1. Reboot error message
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. Try to recreate the 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>
If it fails, an error is returned.




3. Because the database is shut down, you cannot view the path through the SQL command. However, you can try strings spfile to view the path of 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] $


This path/data/oracle/oradgdata/standby_archive does not exist and needs to be created
[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 again. OK.
[Oracle @ localhost dbs] $ rlwrap sqlplus "/as sysdba"
Rlwrap: warning: your $ TERM is 'xtermin' but rlwrap couldn't find it in the terminfo database. Specific CT some problems.


SQL * Plus: Release 11.2.0.1.0 Production on Tue Jan 27 18:39:27 2015


Copyright (c) 1982,200 9, 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 Size3489663728 bytes
Database Buffers1811939328 bytes
Redo Buffers 40914944 bytes
SQL>


Summary: The original path is not recognized because the disk is faulty. After a bad disk is mounted and detached, the archive path needs to be created again when a new disk is added.


Bytes ----------------------------------------------------------------------------------------------------------------
<All Rights Reserved. This document can be reprinted, but the source address must be indicated by link. Otherwise, we will be held legally responsible.>
Original blog address: http://blog.itpub.net/26230597/viewspace-1413077/
Original Author: Huang Shan (mchdba)
Bytes ----------------------------------------------------------------------------------------------------------------