Home » RDBMS Server » Backup & Recovery » ORA-16032 (oracle, 10g, linux)
ORA-16032 [message #380615] Mon, 12 January 2009 13:35 Go to next message
oranwbi
Messages: 3
Registered: January 2009
Location: maryland
Junior Member

hi,
i'm new to oracle db administration, i tried to changed the log_archive_dest parameter on my oracle database the next time i tried to bang my instance this is the error i got
ORA-32004: obsolete and/or deprecated parameter(s) specified
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

please help!
Re: ORA-16032 [message #380616 is a reply to message #380615] Mon, 12 January 2009 13:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The 2 are not related.
Post the actual related part of alert.log.

By the way, read LOG_ARCHIVE_DEST and precise your Oracle edition.
Also tell us how you "tried to changed the log_archive_dest parameter".

Regards
Michel

[Updated on: Mon, 12 January 2009 13:40]

Report message to a moderator

Re: ORA-16032 [message #380618 is a reply to message #380616] Mon, 12 January 2009 14:19 Go to previous messageGo to next message
oranwbi
Messages: 3
Registered: January 2009
Location: maryland
Junior Member

i typed
alter system set log_archive_dest='location=/u02/archive/rman' SCOPE=SPFILE;


Mon Jan 12 10:37:50 2009
ARCH shutting down
ARC2: Archival stopped
Mon Jan 12 10:37:55 2009
ARCH shutting down
ARC1: Archival stopped
Mon Jan 12 10:38:00 2009
ARCH shutting down
ARC0: Archival stopped
Mon Jan 12 10:38:01 2009
Thread 1 closed at log sequence 10
Successful close of redo thread 1
Mon Jan 12 10:38:01 2009
Completed: ALTER DATABASE CLOSE NORMAL
Mon Jan 12 10:38:01 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Jan 12 10:59:26 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 10:59:55 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 12:18:40 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 12:29:14 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 12:46:09 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
[oracle@odenoradb rman]$ tail -100 bdump/alert_rman.log
Successfully onlined Undo Tablespace 1.
Mon Jan 12 10:32:58 2009
SMON: enabling tx recovery
Mon Jan 12 10:32:58 2009
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=25554
Mon Jan 12 10:33:06 2009
db_recovery_file_dest_size of 500 MB is 59.15% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Jan 12 10:33:10 2009
Completed: alter database open
Mon Jan 12 10:37:16 2009
Starting background process EMN0
Mon Jan 12 10:37:16 2009
Shutting down instance: further logons disabled
EMN0 started with pid=22, OS id=25694
Mon Jan 12 10:37:17 2009
Stopping background process QMNC
Mon Jan 12 10:37:17 2009
Stopping background process CJQ0
Mon Jan 12 10:37:19 2009
Stopping background process MMNL
Mon Jan 12 10:37:20 2009
Stopping background process MMON
Mon Jan 12 10:37:21 2009
Shutting down instance (immediate)
License high water mark = 12
Mon Jan 12 10:37:21 2009
Stopping Job queue slave processes
Mon Jan 12 10:37:21 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon Jan 12 10:37:32 2009
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Mon Jan 12 10:37:43 2009
ALTER DATABASE CLOSE NORMAL
Mon Jan 12 10:37:44 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Jan 12 10:37:44 2009
Shutting down archive processes
Archiving is disabled
Mon Jan 12 10:37:50 2009
ARCH shutting down
ARC2: Archival stopped
Mon Jan 12 10:37:55 2009
ARCH shutting down
ARC1: Archival stopped
Mon Jan 12 10:38:00 2009
ARCH shutting down
ARC0: Archival stopped
Mon Jan 12 10:38:01 2009
Thread 1 closed at log sequence 10
Successful close of redo thread 1
Mon Jan 12 10:38:01 2009
Completed: ALTER DATABASE CLOSE NORMAL
Mon Jan 12 10:38:01 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Jan 12 10:59:26 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 10:59:55 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 12:18:40 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 12:29:14 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jan 12 12:46:09 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Re: ORA-16032 [message #380665 is a reply to message #380618] Mon, 12 January 2009 23:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think this is the actual alert.log file.

Regards
Michel
Re: ORA-16032 [message #380728 is a reply to message #380615] Tue, 13 January 2009 02:54 Go to previous messageGo to next message
mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad
Junior Member
hi in which version of oracle you are setting this parameter? also the location you specified is not available it seems. can you post your steps.
Re: ORA-16032 [message #380740 is a reply to message #380728] Tue, 13 January 2009 03:21 Go to previous message
Michel Cadot
Messages: 64136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
also the location you specified is not available it seems.

What make you think that?

Regards
Michel
Previous Topic: A question about hot backup process
Next Topic: complete recovery through rman
Goto Forum:
  


Current Time: Thu Dec 08 06:13:53 CST 2016

Total time taken to generate the page: 0.13011 seconds