rman backup database force 功能

最新推荐文章于 2025-02-25 15:05:57 发布

lovely可爱欧辰

最新推荐文章于 2025-02-25 15:05:57 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： RMAN 备份恢复文章标签： database disk optimization file parameters 优化

本文链接：https://blog.youkuaiyun.com/liqfyiyi/article/details/7967362

RMAN 备份恢复专栏收录该内容

22 篇文章

订阅专栏

本文详细介绍了RMAN中FORCE选项的作用及其使用场景。当启用FORCE选项时，RMAN将忽略备份优化设置，确保所有指定文件都会被备份，即使这些文件之前已被备份。通过示例演示了如何使用FORCE选项进行全库备份。

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

FORCE
Causes RMAN to ignore backup optimization. In other words, even if CONFIGURE BACKUP OPTIMIZATION is set to ON, RMAN backs up all specified files.

Note: You can also specify this option in the backupSpecOperand clause.
加上FORCE选项，则RMAN忽略调CONFIGURE里的优化功能选项．
比如：你配置了RMAN优化功能为ON，之前对只读表空间作了备份，这时，再备份全库，不加FORCE.
则RMAN不会备份只读表空间，因为之前已经备份过，加上FORCE，则RMAN忽略掉优化功能，
作全库备份．

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;

SQL> alter tablespace tools read only;

Tablespace altered.
RMAN> backup tablespace tools;

Starting backup at 21-DEC-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=D:ORACLEORADATAPAULTOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-DEC-07
channel ORA_DISK_1: finished piece 1 at 21-DEC-07
piece handle=D:BACKUP3IJ454LF_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-DEC-07

Starting Control File and SPFILE Autobackup at 21-DEC-07
piece handle=D:BACKUPC-1605165889-20071221-03 comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-07

RMAN> backup database;

Starting backup at 21-DEC-07
using channel ORA_DISK_1
skipping datafile 4; already backed up 3 time(s)
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEORADATAPAULSYSTEM01.DBF
input datafile fno=00002 name=D:ORACLEORADATAPAULUNDOTBS01.DBF
input datafile fno=00003 name=D:ORACLEORADATAPAULINDX01.DBF
input datafile fno=00005 name=D:ORACLEORADATAPAULUSERS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-DEC-07
channel ORA_DISK_1: finished piece 1 at 21-DEC-07
piece handle=D:BACKUP3KJ454M1_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 21-DEC-07

Starting Control File and SPFILE Autobackup at 21-DEC-07
piece handle=D:BACKUPC-1605165889-20071221-04 comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-07

RMAN> backup database force;

Starting backup at 21-DEC-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEORADATAPAULSYSTEM01.DBF
input datafile fno=00002 name=D:ORACLEORADATAPAULUNDOTBS01.DBF
input datafile fno=00003 name=D:ORACLEORADATAPAULINDX01.DBF
input datafile fno=00005 name=D:ORACLEORADATAPAULUSERS01.DBF
input datafile fno=00004 name=D:ORACLEORADATAPAULTOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-DEC-07
channel ORA_DISK_1: finished piece 1 at 21-DEC-07
piece handle=D:BACKUP3MJ454NL_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 21-DEC-07

Starting Control File and SPFILE Autobackup at 21-DEC-07
piece handle=D:BACKUPC-1605165889-20071221-05 comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-07

RMAN>