Home » RDBMS Server » Server Administration » rman instance crash and disapp (oracle 9 , linux)
rman instance crash and disapp [message #436788] Mon, 28 December 2009 06:09 Go to next message
chuikingman
Messages: 90
Registered: August 2009
Member
I have an rman instance in oracle 9
the instance crash and disappear suddenly.
I need to recover it by restarting the rman instance again.
There is no any information in the log like alert log as I search
before already.No any log information certainly.
How can I set trace or debug for this instance
So , next time ,it crash again ,I can have information to pass to support ??
Any advice
Re: rman instance crash and disapp [message #436789 is a reply to message #436788] Mon, 28 December 2009 06:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean RMAN catalog database?
The standard oracle database log file (alert_sid.log) is the starting place.
Re: rman instance crash and disapp [message #436790 is a reply to message #436788] Mon, 28 December 2009 06:15 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
I check already ,
No information in that file /log .
Any advice ??
Re: rman instance crash and disapp [message #436791 is a reply to message #436790] Mon, 28 December 2009 06:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
post the most relevant contents of the alert log.
Any crash would usually leave some trace files.
Look for trace files generated around the same time.
Re: rman instance crash and disapp [message #436792 is a reply to message #436790] Mon, 28 December 2009 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the problem now?
Are you able to restart it?
Did you lose something?
RMAN catalog database is the same as any other database, restore and recover it from your backup (if needed).

Regards
Michel

[Updated on: Mon, 28 December 2009 06:20]

Report message to a moderator

Re: rman instance crash and disapp [message #436793 is a reply to message #436791] Mon, 28 December 2009 06:24 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
trust me .
There is no any information in the log or trace file .
Or the administrator have been deleted it ...
So, any advice on setting trace ?????
Re: rman instance crash and disapp [message #436794 is a reply to message #436792] Mon, 28 December 2009 06:26 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Michel Cadot wrote on Mon, 28 December 2009 20:17
What is the problem now?
Are you able to restart it?
Did you lose something?
RMAN catalog database is the same as any other database, restore and recover it from your backup (if needed).

Regards
Michel

The man instance can restart by command.
But I have no information about why it crash.
So, is it possible to set trace in it , so next time , it crash again, I can have more information what cause it crash ...
Any advice ???
Re: rman instance crash and disapp [message #436795 is a reply to message #436794] Mon, 28 December 2009 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have no problem now.
Check udump for trace files.
Maybe the processes were killed.
Without any trace files or lines in alert.log, you will never know what happened.

Regards
Michel
Re: rman instance crash and disapp [message #436797 is a reply to message #436795] Mon, 28 December 2009 06:33 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
So, How can I set "open the trace" or set debug mode for that instance ??So, next time , I can have more trace/debug for that instance if it crash again ??
Any advice how to set it ???/
Re: rman instance crash and disapp [message #436804 is a reply to message #436797] Mon, 28 December 2009 08:03 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing to do, traces are ALWAYS active for this event.

Regards
Michel
Previous Topic: How to find unused datafile size
Next Topic: ora-00371
Goto Forum:
  


Current Time: Fri Dec 09 06:13:16 CST 2016

Total time taken to generate the page: 0.05356 seconds