connect catalog Rman_user/111@orcl;
connect target sys/iii@orcl;
#备份数据库
run{
#分配通道
allocate
channel='ch1'
device type=disk
format='F:\Oracle_Rman_Backup\Database-%u-%T.bak';
#备份数据库,归档日志,控制文件
backup full (database)
plus archivelog
channel='ch1'
tag='database&archivelog&controlfile'
maxsetsize=1 G
delete all input;
release channel ch1;
}
#检查备份集,删除过时和无效的备份
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
resync catalog;
release channel;
connect target sys/iii@orcl;
#备份数据库
run{
#分配通道
allocate
channel='ch1'
device type=disk
format='F:\Oracle_Rman_Backup\Database-%u-%T.bak';
#备份数据库,归档日志,控制文件
backup full (database)
plus archivelog
channel='ch1'
tag='database&archivelog&controlfile'
maxsetsize=1 G
delete all input;
release channel ch1;
}
#检查备份集,删除过时和无效的备份
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
resync catalog;
release channel;
RMEN Referrence Menu.pdf,其实也不难找。
要的话我可以发给你。
connect catalog Rman_user/111@orcl;
--连接到catalog
connect target sys/iii@orcl;
--连接到目标数据库
#备份数据库
run{
#分配通道
allocate channel='ch1' device type=disk format='F:\Oracle_Rman_Backup\Database-%u-%T.bak';
--指定通道,备份目录以及备份文件名规则,指定备份的载体为disk
#备份数据库,归档日志,控制文件
backup full (database) plus archivelog channel='ch1' tag='database&archivelog&controlfile' maxsetsize=1 G
delete all input;
--数据库带归档日志全备,删除归档日志,tag指定备份的标签,maxsetsize限定备份集的大小
release channel ch1;
--释放通道
}
#检查备份集,删除过时和无效的备份
allocate channel for maintenance device type disk;
--分配维护通道
crosscheck backup;
--校验备份信息:
delete noprompt expired backup;
delete noprompt obsolete;
--删除失效,过期备份
resync catalog;
--同步
release channel;
--释放通道
其他未设置参数都取 default 值