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_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_ip_via_listener_log_xml.sh - Digging real IP Address connecting to oracle database server recently via oracle listener log file "log.xml"
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_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
buddha_bless_never_downtime.sh - Showing a pattern consisting of several special keyboard characters for "Buddha bless, Never downtime"
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
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.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 - The section of RMAN Backup and Restore Experiment
rman_validate - The section of RMAN Validate
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_backup_with_log_refresh.sh - Rsyncing oracle backup files from REMOTE server to local
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
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"
local_trust_ssh_remote.txt - Configuring SSH mutual trust both two linux servers
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