Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 08-02-2012
Registered User
 
Join Date: May 2012
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Help with trace file

Hi,
I am an oracle DBA pretty new to unix. We had one of the filesystems full and a colleague cleared some stuffs to create more space. I just checked now and found there is now more space available. How do i find exactly what he cleared? We have oracle database installed and its a RAC environment. I set environment to one of the instance and checked the path for our ORA_ALERT doing:

tail **full path**/bdump/alert_BC2.log

After i did this, i didnt really find anything similar to what he did. Can someone please help?
Sponsored Links
    #2  
Old 08-02-2012
Registered User
 
Join Date: Mar 2008
Location: Italy - EU
Posts: 172
Thanks: 5
Thanked 35 Times in 35 Posts
Hi,

did your colleague made space-cleaning via Oracle (i.e. by shrinking datafiles, removing old RMAN backups, etc.) or did he operated via operating system commands (i.e. deleting filesystem files, etc.)?

see ya
fra
Sponsored Links
    #3  
Old 08-02-2012
Registered User
 
Join Date: May 2012
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
I am not sure. What i think is he either removed some old logs or deleted maybe a core file or probabaly searched for any large file in that directory.
    #4  
Old 08-02-2012
Registered User
 
Join Date: Mar 2008
Location: Italy - EU
Posts: 172
Thanks: 5
Thanked 35 Times in 35 Posts
ok so, if he made the search and removal job via command line there is a chance his commands are still recorded into the history file.
if you share the same operating system login account on the machine you could try with a

Code:
history | more

command in order to see previous commands, otherwise try to look for history files in his login user's home directory - history file location and presence may vary depending on the shells used and on the OS environment setting, but you can start by searching his homedir with a command like

Code:
ls -laR | more

and look for some file with 'history' in the name, and once you find it you can read it with 'more' command.

see ya
fra
Sponsored Links
    #5  
Old 08-05-2012
Registered User
 
Join Date: May 2012
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Thanks Frappa. We share the same login and checking history as you said was helpful. Thanks for your help
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Help with filtering trace file through grep saqibshah Shell Programming and Scripting 5 09-21-2010 05:37 PM
How to trace file sytem size change? rainbow_bean AIX 1 04-22-2010 06:41 AM
Log Trace gkrishnag Solaris 4 03-10-2010 05:54 AM
How to trace a user salhoub HP-UX 4 08-04-2008 06:05 AM
Core file without a readable stack trace ciregbu Programming 0 10-02-2002 11:42 AM



All times are GMT -4. The time now is 12:50 PM.