利用rman进行完整备份_无恢复目录

最新推荐文章于 2025-02-07 10:46:27 发布

原创最新推荐文章于 2025-02-07 10:46:27 发布 · 753 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#archive #database #include #delete #system

RMAN 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了如何使用RMAN配置并执行全数据库备份，包括设置保留策略、分配通道、指定备份格式、添加控制文件标签、归档日志备份、检查备份和归档日志、删除过期文件以及报告废弃文件的过程。

#backupfulldatabase.rman

run{
configure retention policy to redundancy 1;
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;

backup full database format '/home/oracle/bak/backup/full_%d_%T_%U.bak'
tag='full' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/bak/backup/arc_%d_%T_%U.bak' delete all input;

crosscheck backup;
delete noprompt expired backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
report obsolete;
delete noprompt obsolete;

release channel ch1;
release channel ch2;
}