Tuesday, September 19, 2023

File System Alerts Short Cuts Commands specially "find command"

 


[oracle@pm u02]$ find ./* -type d -name "archivelog" -exec du -sh {} +  2>&1 | grep -v "Permission denied"

612M    ./app/oracle/fast_recovery_area/CHENNAI/archivelog
660M    ./app/oracle/fast_recovery_area/SAKRI/archivelog

[oracle@pm u02]$ find ./* -type d -name "trace" -exec du -sh {} +  2>&1 | grep -v "Permission denied"
0       ./app/oracle/product/21c/dbhome_1/network/trace
17M     ./app/oracle/diag/rdbms/chennai/chennai/trace
2.9M    ./app/oracle/diag/rdbms/sakri/chennai/trace
29M     ./app/oracle/diag/rdbms/sakri/sakri/trace
40K     ./app/oracle/diag/rdbms/unknown/chennai/trace
4.0K    ./app/oracle/diag/clients/user_oracle/host_3163451292_110/trace
1.3M    ./app/oracle/diag/tnslsnr/pm/listener/trace
0       ./app/oracle/homes/OraDB21Home1/network/trace

[oracle@pm u02]$ find ./* -type d -name "alert" -exec du -sh {} +  2>&1 | grep -v "Permission denied"
8.9M    ./app/oracle/diag/rdbms/chennai/chennai/alert
168K    ./app/oracle/diag/rdbms/sakri/chennai/alert
11M     ./app/oracle/diag/rdbms/sakri/sakri/alert
16K     ./app/oracle/diag/rdbms/unknown/chennai/alert
20K     ./app/oracle/diag/clients/user_oracle/host_3163451292_110/alert
2.2M    ./app/oracle/diag/tnslsnr/pm/listener/alert


[oracle@pm u02]$ find ./* -type d -name "*backup*" -exec du -sh {} +  2>&1 | grep -v "Permission denied"
4.6M    ./app/oracle/product/21c/dbhome_1/inventory/backup
164M    ./app/oracle/fast_recovery_area/CHENNAI/autobackup
19M     ./app/oracle/fast_recovery_area/SAKRI/autobackup
12K     ./app/oraInventory/backup

[oracle@pm u02]$ find ./* -type d -name "*dump*" -exec du -sh {} +  2>&1 | grep -v "Permission denied"
158M    ./app/oracle/product/21c/dbhome_1/rdbms/utl/upgrade_dump_seed
0       ./app/oracle/diag/rdbms/chennai/chennai/cdump
0       ./app/oracle/diag/rdbms/sakri/chennai/cdump
0       ./app/oracle/diag/rdbms/sakri/sakri/cdump
0       ./app/oracle/diag/rdbms/unknown/chennai/cdump
0       ./app/oracle/diag/clients/user_oracle/host_3163451292_110/cdump
0       ./app/oracle/diag/tnslsnr/pm/listener/cdump
18M     ./app/oracle/admin/chennai/adump
4.0K    ./app/oracle/admin/chennai/dpdump
13M     ./app/oracle/admin/sakri/adump


[oracle@pm u02]$ find ./* -type d -name "*crs*" -exec du -sh {} +  2>&1 | grep -v "Permission denied"
208M    ./app/oracle/product/21c/dbhome_1/crs
24K     ./app/oracle/product/21c/dbhome_1/inventory/Components21/oracle.rdbms.crs
32K     ./app/oracle/product/21c/dbhome_1/inventory/Templates/crs
0       ./app/oracle/diag/crs


others RAC GRID:-
find /opt -type d -name "*crsd*" 2>&1 | grep -v "Permission denied"
find ./* -type d -name "*crsd*"  2>&1 | grep -v "Permission denied"
find ./* -type d -name "*evm*"  2>&1 | grep -v "Permission denied"
find ./* -type d -name "*orarootagent*"   2>&1 | grep -v "Permission denied"
find ./* -type d -name "*oraagent*"   2>&1 | grep -v "Permission denied"
find ./* -type d -name "*ohas*"    2>&1 | grep -v "Permission denied"

+++++++++++ To find files older than some hours +++++++++++++++++++++++++++++++
find . -daystart -type f -newermt "$(date -d 'today 10 hours ago' +'%Y-%m-%d %H:%M:%S')"
find . -type f -writable
find . -type f -executable
find . -type f -readable 

+++++++++++++files older between 5 hours to 10 hours from the daystart++++++++++++++
find .  -daystart -type f -newermt "$(date -d 'today 10 hours ago' +'%Y-%m-%d %H:%M:%S')" ! -newermt "$(date -d 'today 5 hours ago' +'%Y-%m-%d %H:%M:%S')"

find . -type f -newermt '5 hours ago' 
find . -type f -newermt '5 minutes ago' 
find . -type f -newermt '5 days ago' 
find . -type f -newermt '5 months ago' 
find . -type f -newermt '5 years ago' 
find . -type f -newermt 'yesterday' 
we can use 
"-type d" flag for directories 
"-type b" flag for block devices
"-type f" flag for files 




No comments:

Post a Comment

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...