Sunday, July 28, 2013

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

[oracle11@db01 ~]$ export ORACLE_SID=orcl

[oracle11@db01 ~]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 29 10:12:44 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory

SQL> create pfile='/data01/orcl.ora' from spfile;

File created.

open the pfile and check this parameter and check the path that path is available or not if not then you have to create the folder same as you set  the path in the parameter. and startup the db.


*.log_archive_dest='/data/oracle11_backup/archive'


All The Best.........:)

2 comments:

  1. create pfile=/path/to/backup.ora from spfile;

    ReplyDelete
    Replies
    1. sorry for the late reply..
      could you please let us know what is your question.

      Delete