oracle闪回文件太大,rman 在线备份 占用闪回区过多

rman 语句

backup as compressed backupset incremental level= 1  skip inaccessible filesperset 5 Database format='/home/oracle/ora_bak/orcl_lev1_%U_%T'  tag='orcl_lev1_0520' database

include current controlfile ;

执行日志:

channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00006 name=/home/oracle/ora_data/orcl/newdb2.dbf

input datafile file number=00013 name=/home/oracle/ora_data/orcl/newdb9.dbf

input datafile file number=00019 name=/home/oracle/ora_data/orcl/newdb15.dbf

input datafile file number=00023 name=/home/oracle/ora_data/orcl/AJBD.dbf

input datafile file number=00021 name=/home/oracle/ora_data/orcl/biindex2

channel ORA_DISK_1: starting piece 1 at 20-MAY-19

channel ORA_DISK_1: finished piece 1 at 20-MAY-19

piece handle=/home/oracle/ora_bak/orcl_lev1_eau1vpki_1_1_20190520 tag=ORCL_LEV1_0520 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00006 name=/home/oracle/ora_data/orcl/newdb2.dbf

input datafile file number=00013 name=/home/oracle/ora_data/orcl/newdb9.dbf

input datafile file number=00019 name=/home/oracle/ora_data/orcl/newdb15.dbf

input datafile file number=00023 name=/home/oracle/ora_data/orcl/AJBD.dbf

input datafile file number=00021 name=/home/oracle/ora_data/orcl/biindex2

channel ORA_DISK_1: starting piece 1 at 20-MAY-19

channel ORA_DISK_1: finished piece 1 at 20-MAY-19

piece handle=/home/oracle/ora_data/flash_recovery_area/ORCL/backupset/2019_05_20/o1_mf_nnnd1_TAG20190520T010002_gg32woy1_.bkp tag=TAG20190520T010002 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

为什么要在 flash_recovery_area 下写入一份备份?是否可以不写。

如果一定要写,是否可以限制写入大小或者更改写入的目录?

因为我设置了 64 GB 的flash_recovery_area  , 现在全备文件大约62GB ,会在 flash_recovery_area  下产生62GB 的文件,导致 flash_recovery_area  空间占用100% 数据库停止运行。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值