Home » RDBMS Server » Backup & Recovery » add sql_trace in rman instance
add sql_trace in rman instance [message #423898] Tue, 29 September 2009 02:49 Go to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
I add below
sql_trace = TRUE
in initrman.ora in rman instance ??
SO, if I use rman to back up the database ??
Will it affect the loading of system ??
how much the loading increase if I add sql_trace in rman instance ???

Re: add sql_trace in rman instance [message #423899 is a reply to message #423898] Tue, 29 September 2009 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quite much.
What is the purpose to add sql_trace to your rman catalog database?

Regards
Michel
Re: add sql_trace in rman instance [message #423900 is a reply to message #423899] Tue, 29 September 2009 03:03 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
Actually, we find the rman instance crash suddenly without season. We want to collect more info next time it crash again .
that is the purpose to add sql_trace in rman instance !!
Re: add sql_trace in rman instance [message #423913 is a reply to message #423900] Tue, 29 September 2009 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is in alert.log? Any file in trace directories?

Regards
Michel
Re: add sql_trace in rman instance [message #423919 is a reply to message #423913] Tue, 29 September 2009 04:45 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
No data in alert.log file .
No other data is found in the log ..
So, that is why I need to set sql_trace to get more data
next time the crash is found !!
Re: add sql_trace in rman instance [message #423926 is a reply to message #423919] Tue, 29 September 2009 05:29 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL trace will not give you anything about instance crash.
If you are sure there is nothing in alert.log and trace files then the reason is outside Oracle.

Regards
Michel
Previous Topic: relationship between different instance in RMAN
Next Topic: where is the file in RMAN
Goto Forum:
  


Current Time: Sat Oct 01 04:16:41 CDT 2016

Total time taken to generate the page: 0.30635 seconds