OraFAQ Forum: Server Administration » bdump dir deleted; cannot get cause of downtime

Home » RDBMS Server » Server Administration » bdump dir deleted; cannot get cause of downtime (SunOS prod 5.10 Generic_137112-06 i86pc i386 i86pc)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

bdump dir deleted; cannot get cause of downtime [message #523486]

Mon, 19 September 2011 01:54

drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana

Member

Is there any way I can find out what caused the database to crash; either a history of commands executed within the database, I lost my bdump directory before the scheduled backup ran and the only logs available are after I re-created the directory.

SQL> startup
ORA-00444: background process "PMON" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL>


oracle@prod:RKDB:/u01/app/oracle/admin/RKDB/pfile
ls -l /u01/app/oracle/admin/RKDB/bdump
/u01/app/oracle/admin/RKDB/bdump: No such file or directory
oracle@prod:RKDB:/u01/app/oracle/admin/RKDB/pfile

background_dump_dest=/u01/app/oracle/admin/RKDB/bdump


oracle@prod:RKDB:/u01/app/oracle/admin/RKDB
ls -l
total 208
drwxr-xr-x   2 oracle   oinstall   61952 Sep 17 20:35 adump
drwxr-xr-x   4 oracle   oinstall     512 Nov  6  2009 cdump
drwxr-xr-x   2 oracle   oinstall     512 Dec 11  2007 create
drwxr-xr-x   2 oracle   oinstall    8704 Dec 15  2010 exports
drwxr-xr-x   2 oracle   oinstall     512 Dec 11  2007 pfile
drwxr-xr-x   2 oracle   oinstall   30720 Sep 17 20:45 udump
drwxr-xr-x   2 oracle   oinstall     512 Dec 11  2007 ultdir
oracle@prod:RKDB:/u01/app/oracle/admin/RKDB

[color, font and size removed]

[Updated on: Mon, 19 September 2011 12:47] by Moderator

Report message to a moderator

Re: bdump dir deleted; cannot get cause of downtime [message #523487 is a reply to message #523486]

Mon, 19 September 2011 01:56

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no history of commands.
The first place to check is the alert.log file.

Regards
Michel

Report message to a moderator

Re: bdump dir deleted; cannot get cause of downtime [message #523490 is a reply to message #523487]

Mon, 19 September 2011 02:06

drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana

Member

The only entries in the alert log are those that occur after the db is started., anything before than is lost. Basically what you are saying is that all error prior to the crash are lost
with the alert log file and there is absolutely no way of knowing what the cause was ?

Report message to a moderator

Re: bdump dir deleted; cannot get cause of downtime [message #523507 is a reply to message #523490]

Mon, 19 September 2011 03:10

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, the cause was almost certainly the loss of the bdump directory, or something related to that.

How did it get lost?

Report message to a moderator

Re: bdump dir deleted; cannot get cause of downtime [message #523512 is a reply to message #523490]

Mon, 19 September 2011 03:17

John Watson
Messages: 8930
Registered: January 2010
Location: Global Village

Senior Member

You might have something in /u01/app/oracle/admin/RKDB/adump, look for the file dated immediately before the crash. If someone had logged in as sysdba, at least you will be able to see who. And your operating system audit trail might have something that your sysadmins can find. Lastly, if database auditing has been enabled you might have something useful in the dba_audit_% views.

Report message to a moderator

Previous Topic:	size_clause issue of parameters method_opt
Next Topic:	database creation manual error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 15:22:37 CDT 2024