rman执行完全备份（图）

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

iteye_6490

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

阅读量167

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE-windows 文章标签： Java Oracle C C++ C#

本文链接：https://blog.youkuaiyun.com/iteye_6490/article/details/81820851

ORACLE-windows 专栏收录该内容

15 篇文章

订阅专栏

本文详细介绍了 Oracle 数据库的完全备份方法，包括如何通过批命令实现数据库及归档日志的备份，并展示了如何验证备份是否成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[img]http://dl.iteye.com/upload/attachment/198770/8cc862f4-21a5-33ed-9a2e-9fd72f89588b.jpg[/img]

backup as copy db_file_name_convert=('C:\oracle\product\10.2.0\oradata\charge','D:\database\backup') database;

[img]http://dl.iteye.com/upload/attachment/198779/2e0b6499-ebc5-3c1d-a272-0af458cb87ec.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/198772/e6bee461-ad15-3c16-89e9-77ccacbab579.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/198774/7f0509e1-8f01-3e21-b444-0ba23db805e9.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/198776/58c1945f-31fe-369c-ba06-119b9a9118e1.jpg[/img]

上面的完全备份不能备份归档日志，下面用一个批命令：

run{
crosscheck archivelog all;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
configure controlfile autobackup format for device type disk to 'D:\database\backup2\control_%F';
backup full database format 'D:\database\backup2\data_%d_%U'
plus
archivelog format 'D:\database\backup2\arch_%d_%U' delete all input;
}

备份完后查看备份集：