本帖最后由 dan 于 2020-4-1 23:04 编辑
1、命令:mkdir /oracle/dump,作用:创建一个备份用目录2、命令:cd /oracle/dump,作用:切换到该目录
3、命令:vim rman_backup.sh,作用:创建一个脚本文件 4、以下是脚本的内容: run{ allocate channel t1 type disk; allocate channel t2 type disk; crosscheck archivelog all; delete noprompt expired archivelog all; delete noprompt archivelog all completed before 'sysdate-7'; crosscheck backup; delete noprompt expired backup; sql 'alter system archive log current'; backup as compressed backupset incremental level 0 database format '/oracle/dump/full_%d_%T_%s_%p' plus archivelog format '/oracle/dump/arch_%d_%T_%s_%p'; backup current controlfile format '/oracle/dump/ctrl_%d_%T_%s_%p'; report obsolete; #delete noprompt obsolete; release channel t1; release channel t2; } 5、命令:rman target / @rman_backup.sh > rman_backup.log,作用:测试脚本是否有效,并把屏幕上的输出,输入到日志文件里。 6、命令:ll -h,作用:查看当前目录,备份成功 |