why ora-16032 when in NOARCHIVELOG mode ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: why ora-16032 when in NOARCHIVELOG mode ?

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    why ora-16032 when in NOARCHIVELOG mode ?

    Init Params:
    log_archive_dest_1 location=/u570/oradata/hdb/arch mandatory reopen=5
    log_archive_start FALSE

    SQL> archive log list
    Database log mode No Archive Mode
    Automatic archival Disabled
    Archive destination ?/dbs/arch
    Oldest online log sequence 1585
    Current log sequence 1587

    SQL> select log_mode from v$database;
    LOG_MODE
    ------------
    NOARCHIVELOG

    Question:
    Why would I get this error at startup time ?
    ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
    ORA-07286: sksagdi: cannot obtain device information.

    I know the device does not exist, but why is it checking, when it is not going to arhieve there ?
    Do I need to set the "log_archive_dest_1" parameter to BLANK ? to get rid of this error ?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This has nothing to do with archiving. You simply have invalid syntax in your init.ora file, it just happens to be on your log_archive_dest_1 parameter. Comment this line out or remove it all together.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    log_archive_dest or
    log_archive_dest_n, where n >= 2

    "Supposed to" not use log_archive_dest_1 by itself; use log_archive_dest if there is only one destination. If more than one, the other format is appropriate.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width