Aliases can help in issuing complex or long commands by creating short aliases for them.
Aliases can be created for the session or persistent ones by adding them to .profile or .bashrc file depending on what flavor of Unix you are using.
Example:
alias l=’l -al’#this will create alias for list command with couple of paramter
alias alert=’cd /u02/diag/rdbms/prod/prod1/trace’ #this creates alias for alert log location for oracle
####This will show any running RMAN process with details about how much work is done and left #####
select sid, serial#, context, sofar, totalwork, round(sofar/totalwork*100,2) "%_COMPLETE" FROM v$session_longops where opname like 'RMAN%' AND opname not like '%aggregate%' AND totalwork != 0 and sofar <> totalwork;
###Start ADR
adrci
###shows errors in log
SHOW PROBLEM
###Shows last 10 entries of alert file
SHOW ALERT -TAIL
###Display all trace files
SHOW TRACEFILE
###Display trace file location related to incident
SHOW TRACEFILE -I 1234
###Shows incidents in 11g above
SHOW INCIDENT
###Show details of particular incident
SHOW INCIDENT -MODE DETAIL -P “INCIDENT_ID=1234″
Find out instance info.
select * from v$instance;
Find out database info.
select * from v$database;
Get controlfile info.
select * from v$controlfile
Get DB File info.
select * from v$DBFILE
Get parameter info.
select * from v$parameter
Get session info.
select * from v$session
Get process info.
select * from v$process
To get list of full backup from Oracle database run the script below, which uses the rman_backup_job_details system view, this list all backups in database with archivelog mode on and backup size of at least 1 Terabyte.
SELECT * FROM v$rman_backup_job_details
WHERE input_type = 'DB INCR'
AND output_bytes_display LIKE '%T'
ORDER BY session_key DESC;