Scan listener relocate

#!/bin/bash


# ... (other code)


# Function to run post_patch_relocate.sh script

run_post_patch_relocate() {

    local OUTPUT_DIRECTORY="$1"


    # Run post_patch_relocate.sh with default 'n' option

    log_output "Post Patch Relocate" "sh post_patch_relocate.sh \"$OUTPUT_DIRECTORY\" <<EOF

n

EOF"

}


# ... (other code)


# Call the function with the OUTPUT_DIRECTORY variable

run_post_patch_relocate "$OUTPUT_DIRECTORY"


# ... (other code)

*************

#!/bin/bash


# Use the first argument as OUTPUT_DIRECTORY

OUTPUT_DIRECTORY="$1"


# Specify the file containing captured listener information

listener_info_file="$OUTPUT_DIRECTORY/listener_info.log"


# Specify the log file for relocation activities

relocate_log_file="$OUTPUT_DIRECTORY/relocation_output.log"  # Change to desired name


# Check if the listener info file exists

if [ ! -f "$listener_info_file" ]; then

    echo "Error: Missing listener info file. Please run pre_patch_listener_capture.sh first." > "$relocate_log_file"

    exit 1

fi


# Choose whether to execute relocations or perform a dry run

read -p "Do you want to execute relocations now (y/n)? " execute_relocations


# Loop through captured listener information and generate relocation commands

while read -r listener_name node_name; do

    # Replace with your actual logic for target node selection

    target_node="$node_name"


    # Example using current node (consider replacing)


    # Execute relocation command with logging or dry run based on the choice

    if [ "$execute_relocations" == "y" ]; then

        srvctl relocate scan listener scannumber "$listener_name" -node "$target_node" >> "$relocate_log_file" 2>&1

    else

        # Dry run message

        echo "Dry run relocation: srvctl relocate scan listener -scannumber \"$listener_name\" -node \"$target_node\"" >> "$relocate_log_file"

        # Display completion message and log

        echo "Processed $listener_name (target node: $target_node)." >> "$relocate_log_file"

    fi

done < "$listener_info_file"


# Display final message and log

echo "Relocation process completed (dry run: $execute_relocations)." >> "$relocate_log_file"


# Display contents of the relocate_log_file

cat "$relocate_log_file"

Comments

Post a Comment

Popular posts from this blog

SQL Loader V3

Create the Configuration File (config.cfg):Create a file named config.cfg with the following content. Adjust the values to match your environment:[database] username=your_username password=your_password database=your_database [files] csv_file=/path/to/your/file.csv log_file=/path/to/your/log_file.log inserted_rows_file=/path/to/your/inserted_rows.log updated_rows_file=/path/to/your/updated_rows.log ********** #!/bin/bash # Load configuration source config.cfg # Variables CSV_FILE=$csv_file USERNAME=$username PASSWORD=$password DATABASE=$database MASTER_TABLE="master_table" CHILD_TABLE="child_table" LOG_FILE=$log_file INSERTED_ROWS_FILE=$inserted_rows_file UPDATED_ROWS_FILE=$updated_rows_file # Logging function log() {   echo "$(date +'%Y-%m-%d %H:%M:%S') $1" >> $LOG_FILE } log "Starting data load process." # SQL Loader Control File for child table CONTROL_FILE="control_file.ctl" # Create control file for child table cat ...
Read more

Db Unix

-- Insert new records into master table INSERT INTO $master_table (     parent,     parent_sys_class_name,     child_sys_class_name,     child_u_cmdb_ci_used_for,     parent_correlation_id,     type,     child_correlation_id,     child,     modified_date ) SELECT     c.parent,     c.parent_sys_class_name,     c.child_sys_class_name,     c.child_u_cmdb_ci_used_for,     c.parent_correlation_id,     c.type,     c.child_correlation_id,     c.child,     c.modified_date FROM $child_table c LEFT JOIN $master_table m ON c.child_correlation_id = m.child_correlation_id WHERE m.child_correlation_id IS NULL; -- Log inserted rows SPOOL $inserted_rows_file SELECT     c.parent,     c.parent_sys_class_name,     c.child_sys_class_name,     c.child_u_cmdb_ci_used_for,     c.pare...
Read more

Standby redo log add

********* #!/bin/bash # Function to run SQL*Plus commands run_sql() {     sqlplus -s / as sysdba <<EOF     SET HEADING OFF FEEDBACK OFF VERIFY OFF ECHO OFF     $1     EXIT EOF } # Get the max group, max thread, and max size from the v$log and v$logfile views redo_info=$(run_sql "SELECT MAX(l.group#), MAX(l.thread#), MAX(l.bytes/1024/1024)  FROM v\$log l, v\$logfile f  WHERE f.group# = l.group#;") # Extract the max group, max thread, and max size values max_group=$(echo "$redo_info" | awk '{print $1}') max_thread=$(echo "$redo_info" | awk '{print $2}') max_size=$(echo "$redo_info" | awk '{print $3}') # Get the number of redo groups per thread groups_per_thread=$(run_sql "SELECT COUNT(DISTINCT group#) FROM v\$log WHERE thread#=1;") # Get the recovery file destination reco_dest=$(run_sql "SHOW PARAMETER db_recovery_file_dest") reco_dest=$(echo "$reco_dest" | awk 'NR==2 {print $3}' |...
Read more