Decommission pre check

 #!/bin/bash


# Function to log messages with timestamp

LOG_FILE="decommission_precheck_${ORACLE_SID}.log"

log() {

    local message=$1

    echo "$(date +'%Y-%m-%d %H:%M:%S') $message" | tee -a $LOG_FILE

}


# Check if correct arguments are provided

if [ $# -ne 2 ]; then

    echo "Usage: $0 <ORACLE_SID> <frame>"

    exit 1

fi


# Export environment variables

export ORAENV_ASK=NO

export ORACLE_SID=$1

export frame=$2

db_name=${ORACLE_SID%?}


# Load Oracle environment

. oraenv


# Start logging

log "Precheck gather information process started for ORACLE_SID: $ORACLE_SID"


# Generate report file

report_file="pre_check_report_$(date +%F).log"


# Execute SQL script

log "Executing queries.sql to gather database information."

sqlplus -s / as sysdba <<EOF >> $report_file

@queries.sql

exit;

EOF


# Retrieve DB unique name

log "Retrieving DB unique name from the database."

db_unique_name=$(sqlplus -s / as sysdba <<EOF | tr -d '[:space:]'

set heading off

set feedback off

set pagesize 0

select db_unique_name from v\$database;

exit;

EOF

)


if [ -z "$db_unique_name" ]; then

    log "Failed to retrieve DB unique name."

    exit 1

fi


log "DB unique name: $db_unique_name"


# Execute autosys.ksh script

log "Running autosys.ksh with parameters."

./autosys.ksh h "$frame-d" "$db_unique_name" -c delete


# Data Guard information logging

dr_info="dr_info_$(date +%F).log"

log "Checking Data Guard configuration."

dgmgrl / <<EOF > $dr_info

show configuration;

EOF


if grep -qE "ORA-16525|ORA-16596" "$dr_info"; then

    log "Data Guard not available for $db_unique_name."

fi


# Switch to ASM instance

export ORACLE_SID=$(ps -ef | grep "[a]sm_smon.*+ASM" | awk '{print $NF}' | cut -d '_' -f3)

if [ -z "$ORACLE_SID" ]; then

    log "Failed to switch to ASM instance."

    exit 1

fi

log "Switched to ASM instance: $ORACLE_SID"

. oraenv <<< "$ORACLE_SID"


# Check Goldengate status

log "Checking Goldengate status."

agctl status goldengate > goldengate_status_log.log


srvctl status database -d "$db_unique_name" -v >> $report_file


running_instances_with_manager=$(grep "is running" goldengate_status_log.log | awk '{gsub(/^\**|\**$/, "", $0); print $NF":"$3}')


if [ -z "$running_instances_with_manager" ]; then

    log "No running instances with Goldengate manager found."

else

    log "Running instances with Goldengate manager: $running_instances_with_manager"

    echo "$running_instances_with_manager" >> $report_file


    # Loop through each instance and check Goldengate status

    for instance_with_manager in $running_instances_with_manager; do

        node_name=$(echo $instance_with_manager | cut -d':' -f1)

        manager_name=$(echo $instance_with_manager | cut -d':' -f2)


        log "Logging into $node_name to check Goldengate status for $manager_name"

        ssh $node_name <<EOF >> $report_file

export ORACLE_SID=$(ps -ef | grep [a]sm_smon.*+ASM | awk '{print \$NF}' | cut -d'+' -f3)

. oraenv <<< "\$ORACLE_SID"

/auto/data.misc/oracle/ogg_distribution/automation_scripts/gg_processes.sh

/auto/data.misc/oracle/ogg_distribution/automation_scripts/gg_pumps.sh

EOF

    done

fi


log "Precheck gather information process completed."

Comments

Post a Comment

Popular posts from this blog

Database growth

#!/bin/bash # Log file LOGFILE="db_growth_check.log" echo "Checking yearly database growth on all running Oracle databases..." > $LOGFILE echo "DATABASE_NAME | YEAR | GROWTH_GB" >> $LOGFILE echo "---------------------------------" >> $LOGFILE # Find running Oracle instances (excluding ASM and APX) ps -ef | grep pmon | grep -v grep | grep -Ev "(\+ASM|APX)" | awk -F'_' '{print $3}' | while read -r ORACLE_SID do     if [[ -n "$ORACLE_SID" ]]; then         echo "Processing database: $ORACLE_SID"         # Set Oracle environment         export ORACLE_SID=$ORACLE_SID         export ORAENV_ASK=NO         . oraenv > /dev/null 2>&1         # Run SQL query to check yearly database growth         SQL_OUTPUT=$(sqlplus -s / as sysdba <<EOF SET HEADING OFF; SET FEEDBACK OFF; SELECT '$ORACLE_SID' AS DATABASE_NAME,  ...
Read more

DBA Day-2 ve

 Operating system  CPU mpstat top  load average  pidstat dstat -vr strace---> debug if system CPU usage % is high but if you dont know then use strace -tp `grep testdb1 2>&1 | head 100 debug if User CPU usage % is high but if you dont know then use 6. jobs (hit enter) 6.1 perf record -F 99 -a -g --sleep 10 (Profiling ) 6.2 perf report -n --stdio 6.3 ./perf-tools/execsnoop Memory vmstat I/O iostat -xmd 1 iotop Network sar -n DEV 1 mtr netstat -antpl | grep 1521 nmcli device status ethtool iperf3 -c 10.1.90.51 https://www.youtube.com/watch?v=eWUeJBAiX80 fs.aio-max-nr--> Async I/O max fs.file-max --> Max file open kernal.shmmin --> how many program segment can access(permission) the shared memory kernal.shmall --> maximum amount of shared memory can accessed by all the process other than OS(set to sum of all SGAs on the server divided by page size – ‘getconf PAGESIZE’) kernal.shmmax --> maximum amount of shared memory can accessed by ind...
Read more

Asm

#!/bin/bash # Set environment variables ORACLE_SID=YOUR_SID ORACLE_HOME=/path/to/oracle_home export ORACLE_SID ORACLE_HOME LOG_DIR=/path/to/logs SQL_DIR=/path/to/sql mkdir -p "$LOG_DIR" mkdir -p "$SQL_DIR" DB_USER="/ as sysdba" # Function to generate SQL data for each target type generate_sql() {   local TARGET_TYPE=$1   local SQL_FILE="$SQL_DIR/${TARGET_TYPE}_data.sql"   local OUTPUT_FILE="/tmp/${TARGET_TYPE}_data.txt"   case "$TARGET_TYPE" in     cluster)       echo "SET HEADING OFF; SET FEEDBACK OFF; SET PAGESIZE 0;" > "$SQL_FILE"       echo "SELECT TARGET_NAME || '|' || HOST_NAME || '|' || CREDENTIALS || '|' || CLUSTER_NAME || '|' || VIP_ADDRESS FROM CLUSTER_TARGETS;" >> "$SQL_FILE"       ;;     # Additional target types can be added here     *)       echo "[ERROR] Unknown target type: $TARGET_TYPE"       return 1       ;;   esac ...
Read more