oracle_backup

#!/bin/bash

DAYS=`date +"%Y%m%d"`

. /home/oracle/.bash_profile

# /home/opt/oracle/11g/bin/exp ydm/123456_xwcz@orcl owner=ydm file=/home/backup/ydm_${DAYS}.dmp
/home/opt/oracle/11g/bin/expdp ydm/123456  directory=backup2 dumpfile=ydm_${DAYS}.dmp logfile=ydm_${DAYS}.log

tar zcvf /home/backup/ydm_${DAYS}.tar.gz /home/backup/oracle/ydm_${DAYS}.dmp /home/backup/oracle/ydm_${DAYS}.log --remove-files

/usr/bin/rsync -aP --port=8733 --password-file=/etc/rsync.passwd /home/backup/ydm_${DAYS}.tar.gz ydm_backup@10.104.185.8::backup/oracle_130//usr/bin/rsync -aP --port=8733 ydm_backup@10.104.185.8::backup/oracle_130/ydm_20180507.tar.gz  .alter user ydm identified by 123

alter user ydm identifed by 123;  --修改密码

alter user ydm quota unlimited on YDM; --取消限制

show parameter dump_dest;  --查看日志


https://www.cnblogs.com/fiberhome/p/7414220.html   数据库启动和关闭

　　select username,default_tablespace from dba_users;  --用户和表空间

ORACLE删除当前用户下所有的表的方法