Oracle Rman常用的0级备份/全备命令
温馨提示:0级备份其实就是增量备份模式中的全备,但普通的全备却无法用作增量备份的0级备份
- 创建目录
mkdir -p /home/oracle/zzt_backup/
- 调用Rman工具
温馨提示:Rman工具的target模式只支持sys用户以非“as sysdba”模式登录,或者直接使用系统认证登录
su - oracle
rman target /
- 执行rman备份命令
run{
allocate channel zzt_disk01 device type disk;
allocate channel zzt_disk02 device type disk;
allocate channel zzt_disk03 device type disk;
#数据文件
crosscheck backup;
delete noprompt expired backup;
backup
incremental level 0 as compressed backupset
tag zzt_level_0_data
format 'c:/app/zwx_backup/zwx_level_0_data_%s_%p_%t.dbf'
database;
#归档文件(为了恢复需要,只需要备份最近1天的即可)
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup
as compressed backupset archivelog
from time 'sysdate-1'
delete input
tag zzt_level_0_arch
format 'c:/app/zwx_backup/zwx_level_0_arch_%s_%p_%t.arc' ;
#控制文件
backup current controlfile tag zwx_level_0_cont
format 'c:/app/zwx_backup/zwx_level_0_cont_%s_%p_%t.ctl' ;
#参数文件
backup spfile tag zwx_level_0_spfi
format 'c:/app/zwx_backup/zwx_level_0_spfi_%s_%p_%t.spf' ;
release channel zzt_disk01;
release channel zzt_disk02;
release channel zzt_disk03;
}
※ 如果您觉得文章写的还不错, 别忘了在文末给作者点个赞哦 ~
over