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% 数据库停止运行。