SQLTrace Logs

[Former Member]

Hi Friends,

In general , if we miss to switch on the sql trace during any process and still if we want to recover the supposed content(logs) of the SQL Trace, where from we can obtain this trace details (logs information)

I think somewhere the logs should be written. Please provide your valuable inputs on this.

Thanks,

Sita

[Former Member]

hi datla,

I am sure you can found what you mean (if you are using Oracle DB) on offline redo log file and online redo log file too.

ardhian

<removed_by_moderator>

Read the "Rules of Engagement"

• You can populate your homepage in your profile.*

Edited by: Juan Reyes on Dec 2, 2008 9:30 AM

[JPReyes]

I can't understand our question... It simply doesnt make any sense.

A trace does not contain any restorable objects... its simply a trace, a log of events.

I think you're talking about SQL transaction logs... if that's the case and you don't have the transaction logs because it was not switched on (for whatever the reason) you simply won't be able to restore the changes done to the database after your last online-offline full backup.

Regards

Juan