AIX Script for Oracle files transfer
Budget: $30 – $250 USD
I'm looking for a UNIX (AIX) scripting expert to create a script that takes data from several Oracle SQL*Plus queries and transfers it to another AIX server.
STEP 1:
Identifying the Oracle files that need to be copied:
#1. Trace files (no core dumps) - example: retrieve location : select ... from v$diag_info ;
#2. Alert log - diagnostic_dest from v$parameter + rdbms/db unique name/instance name/trace
#3. Audit files - audit_file_dest from v$parameter
STEP 2: Copy (scp) these 3 type of files (dumps, alert log and audit files) from STEP_1 on another server (Tivoli).
Key Requirements:
- The data should be copied as a compressed file (e.g., .zip) on the destination server.
- The compressed file should contain a single archive with separate file for each script output.
The order of script execution doesn't matter. Ideal candidates should have extensive experience with UNIX AIX scripting and Oracle SQL*Plus. Please provide examples of similar projects you've completed.
STEP 1:
Identifying the Oracle files that need to be copied:
#1. Trace files (no core dumps) - example: retrieve location : select ... from v$diag_info ;
#2. Alert log - diagnostic_dest from v$parameter + rdbms/db unique name/instance name/trace
#3. Audit files - audit_file_dest from v$parameter
STEP 2: Copy (scp) these 3 type of files (dumps, alert log and audit files) from STEP_1 on another server (Tivoli).
Key Requirements:
- The data should be copied as a compressed file (e.g., .zip) on the destination server.
- The compressed file should contain a single archive with separate file for each script output.
The order of script execution doesn't matter. Ideal candidates should have extensive experience with UNIX AIX scripting and Oracle SQL*Plus. Please provide examples of similar projects you've completed.