Linux Shell Scripts

ADG:

check_dg_redo_apply.sql - Checking redo data apply on physical standby database of Oracle Active Data Guard
check_dg_redo_apply.sh - The shell script calling the previous "check_dg_redo_apply.sql"

BATCH REMOVE:

batch_remove_listener_xml_on_2018.sh - Removing listener log xml file that located in "$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/alert" directory generated by 2018

DIG LISTENER LOG:

dig_ip_via_listener_log_xml.sh - Digging real IP Address connecting to oracle database server recently via oracle listener log file "log.xml"

EXP:

exp_test_and_del_yesterday.sh - Exporting (logical backup with exp command) today's dmp files with specific user(s) and then deleting yesterday's
exp_test_and_del_yesterday_2.sh - The 2nd version of "exp_test_and_del_yesterday.sh", by the way adding four number of new parameters - "direct, buffer, feedback and recordlength" at the end of EXP command

EXPDP:

expdp_test_and_del_yesterday.sh - Exporting (logical backup with expdp command) today's dmp files with specific user(s) and then deleting yesterday's
expdp_test_and_del_yesterday_2.sh - The 2nd version of "expdp_test_and_del_yesterday.sh", by the way adding a new parameter compression at the end of EXPDP command

Linux Logo:

buddha_bless_never_downtime.sh - Showing a pattern consisting of several special keyboard characters for "Buddha bless, Never downtime" 

Oracle Logo Banner:

oracle_logo.sh - Showing banner logo of oracle database server
oracle_logo_2.sh - The 2nd version showing banner logo of oracle database server
oracle_logo_3.sh - The 3rd version showing banner logo of oracle database server

Oracle Service:

automatically_open_oracle.sh - Invoking this SHELL script in /etc/rc.local in order to be able to automatically startup oracle database after restarting server
oracle - Being able to run the service "oracle" for automatically open the Oracle Database in case of Linux (OS) restarts

RMAN Backup:

rman_backup.sh - Doing rman backup one week via rman utility on oracle database server
rman_backup_ASM.sh - Doing rman backup one week to ASM disk via rman utility on oracle database server
rman backup on Windows - Doing rman backup one week on Windows

RMAN Backup and Restore Experiment:

rman_backup_and_restore_experiment - The section of RMAN Backup and Restore Experiment

RMAN Validate:

rman_validate - The section of RMAN Validate

Rotate Process File:

back_and_clean_alert_log.sh - Backup and clean alert log file that located in "$ORACLE_BASE/diag/rdbms/orcl/orcl/trace" directory of oracle database server
back_and_clean_listener_log.sh - Backup and clean listener  log file that located in "$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/trace" directory on oracle user of oracle database server
retention_expdp_test_dump_file_2days.sh - Deleting all of expdp's dmp file about user "test" on oracle database 2 days before
rotate_reserve_base_dmp.sh - Periodically removing some earliest so far 7 number of "xxxx_base_xxxx.dmp" file, which located in directory "/u01/oradata" on oracle user for keeping sufficient disk space in reserve

RSYNC:

rsync_backup_with_log_refresh.sh - Rsyncing oracle backup files from REMOTE server to local

SCP:

scp_expdp_parallel_local_to_remote.sh - Copying several files that is gerenated by oracle datapump tool with expdp command from local to another linux server via scp

SHELL Demo:

check_oracle_instance_nums.sh - Checking how many instances in your Oracle Database Server
check_shell_command_return_value.sh - Checking the return value of prior SHELL command that has finished running
test_mkdir.sh - Creating a directory after obtaining the previous location by "basename"

SSH:

local_trust_ssh_remote.txt - Configuring SSH mutual trust both two linux servers

Statistics All Disk Files:

statistics_all_disk_files.sh - Listing the first file and last with only reserving the format of date and count total files number on each disk on linux server
statistics_all_disk_files_2.sh - The 2nd version listing the first file and last with only reserving the format of date and count total files number on each disk on linux server