【Linux Oracle】杂货铺 日常实用2024

1.跨服务器移动文件

passwd='^T^bxxxx'
`/usr/bin/expect <<-EOF
set timeout -1
spawn scp -r ${BATCH_TIME} sxnhtc@192.168.3.x:${EXP_MCRO_DIR}/
expect "*password:"
send "$passwd\r"
interact
expect eof
EOF`

curl -k -X GET https://192.168.3.x:8888/fileCommon/push/2024-04

#跨服务器移动
/usr/bin/rsync -av oracle@192.168.3.15:/home/oracle/backup /home/oracle/important/15/echo "已备份"#修改时间60天之前的删除
find /home/oracle/important/15/backup/ -mtime +60 -type d ! -path "/home/oracle/important/15/backup/" -exec rm -rf {} \; #删除跨服务器6天之前的
ssh oracle@192.168.3.x " find /home/oracle/backup -mtime +6 -type d ! -path "/home/oracle/backup/" -exec rm -rf {} \; "

2.Oracle删除归档日志

#!/bin/bash
source /home/oracle/.bash_profile
umask 022rman target / << EOF
run{
delete noprompt force archivelog all completed before 'sysdate-35';
}
EOF

3.导出文件

导出命令：exp system/pass@dbsid parfile=exp_parfile.par

exp_parfile.par文件内容:

directory=BACKUP
compress