–1.数据库备份 以test实例 用户ora_test
expdp system/xxxx@test directory=dump_dir dumpfile=20181023_test.dmp schemas=ora_test;
–2 停监听
lsnrctl stop
–3杀外部连接
ps -ef| grep LOCAL=NO |grep -v grep|awk ‘{print $2}‘ |xargs kill -9
–4杀掉除本身以外的内部连接
ps -ef| grep LOCAL=YES |grep -v grep|awk ‘{print $2}‘ |xargs kill -9
–5.以系统管理员身份登录sqlplus
sqlplus / as sysdba
–6.切换日志
alter system switch logfile;
alter system checkpoint;
–7.停库
shutdown immediate;
–8.启动数据库
startup;
–9.退出sqlplus
exit;
–8.启动监听
lsnrctl start ;