shell
#!/bin/sh
for db_info in `sqlplus -s zhyu/zhyu <<EOF
set heading off
set feedback off
select db_uuid||'_'||ip_address||'_'||listener_port||'_'||service_name||'_'||username||'_'||password from godba_add_db;
EOF
`
do
db_uuid=$(echo "$db_info" | awk -F'_' '{print $1}')
ip_address=$(echo "$db_info" | awk -F'_' '{print $2}')
listener_port=$(echo "$db_info" | awk -F'_' '{print $3}')
service_name=$(echo "$db_info" | awk -F'_' '{print $4}')
username=$(echo "$db_info" | awk -F'_' '{print $5}')
password=$(echo "$db_info" | awk -F'_' '{print $6}')
sqlplus -s $username/$password@$ip_address:$listener_port/$service_name<<!
SET LINESIZE 300
SET PAGESIZE 0
SET VERIFY OFF
SET TERMOUT OFF
SET ECHO OFF
SET FEEDBACK OFF
SET MARKUP CSV ON QUOTE OFF
SET HEADING OFF
SPOOL /tmp/datafile.csv APPEND
select file_id,file_name,tablespace_name,bytes,blocks,status,autoextensible,maxblocks,increment_by,'$db_uuid',to_char(sysdate,'yyyymmddhh24miss')fromdba_data_files;
spool off
!
done
页:
[1]