TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- #!/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') from dba_data_files;
- spool off
- !
- done
复制代码
|
|