12c rman optimization优化设置失效?
发表于:2026-11-01 作者:千家信息网编辑
千家信息网最后更新 2026年11月01日,实验过程RMAN> show all;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE
千家信息网最后更新 2026年11月01日12c rman optimization优化设置失效?
实验过程
RMAN> show all;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_orcl.f'; # defaultRMAN> backup archivelog from time 'sysdate-1/12' format '/home/oracle/arch_%d_%t_%s.bak';Starting backup at 02-DEC-2017 16:04:04current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=296 RECID=562 STAMP=961687168input archived log thread=1 sequence=297 RECID=563 STAMP=961687503input archived log thread=1 sequence=298 RECID=568 STAMP=961687506input archived log thread=1 sequence=299 RECID=570 STAMP=961688188input archived log thread=1 sequence=300 RECID=572 STAMP=961688197input archived log thread=1 sequence=301 RECID=574 STAMP=961688200input archived log thread=1 sequence=302 RECID=576 STAMP=961688200input archived log thread=1 sequence=303 RECID=578 STAMP=961688204input archived log thread=1 sequence=304 RECID=580 STAMP=961688205input archived log thread=1 sequence=305 RECID=582 STAMP=961688207input archived log thread=1 sequence=306 RECID=584 STAMP=961688208input archived log thread=1 sequence=307 RECID=586 STAMP=961688210input archived log thread=1 sequence=308 RECID=588 STAMP=961688211input archived log thread=1 sequence=309 RECID=590 STAMP=961688214input archived log thread=1 sequence=310 RECID=592 STAMP=961688214input archived log thread=1 sequence=311 RECID=594 STAMP=961688216input archived log thread=1 sequence=312 RECID=596 STAMP=961689040input archived log thread=1 sequence=313 RECID=598 STAMP=961689042input archived log thread=1 sequence=314 RECID=600 STAMP=961689088input archived log thread=1 sequence=315 RECID=602 STAMP=961689127input archived log thread=1 sequence=316 RECID=604 STAMP=961689169input archived log thread=1 sequence=317 RECID=606 STAMP=961689323input archived log thread=1 sequence=318 RECID=608 STAMP=961689498input archived log thread=1 sequence=319 RECID=610 STAMP=961689541input archived log thread=1 sequence=320 RECID=612 STAMP=961689844channel ORA_DISK_1: starting piece 1 at 02-DEC-2017 16:04:04channel ORA_DISK_1: finished piece 1 at 02-DEC-2017 16:04:05piece handle=/home/oracle/arch_ORCL_961689844_14.bak tag=TAG20171202T160404 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 02-DEC-2017 16:04:05RMAN> RMAN> backup archivelog all format '/home/oracle/arch_%d_%t_%s.bak';Starting backup at 02-DEC-2017 16:04:16current log archivedusing channel ORA_DISK_1skipping archived logs of thread 1 from sequence 227 to 320; already backed upchannel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=321 RECID=614 STAMP=961689856channel ORA_DISK_1: starting piece 1 at 02-DEC-2017 16:04:17channel ORA_DISK_1: finished piece 1 at 02-DEC-2017 16:04:18piece handle=/home/oracle/arch_ORCL_961689857_15.bak tag=TAG20171202T160416 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 02-DEC-2017 16:04:18RMAN> list backup of archivelog all;List of Backup Sets===================...省略...BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------7 4.16M DISK 00:00:00 02-DEC-2017 16:04:04 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20171202T160404 Piece Name: /home/oracle/arch_ORCL_961689844_14.bak List of Archived Logs in backup set 7 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 296 4684573 02-DEC-2017 12:37:57 4684632 02-DEC-2017 15:19:28 1 297 4684632 02-DEC-2017 15:19:28 4686128 02-DEC-2017 15:25:01 1 298 4686128 02-DEC-2017 15:25:01 4686147 02-DEC-2017 15:25:06 1 299 4686147 02-DEC-2017 15:25:06 4688091 02-DEC-2017 15:36:27 1 300 4688091 02-DEC-2017 15:36:27 4688113 02-DEC-2017 15:36:36 1 301 4688113 02-DEC-2017 15:36:36 4688123 02-DEC-2017 15:36:40 1 302 4688123 02-DEC-2017 15:36:40 4688129 02-DEC-2017 15:36:40 1 303 4688129 02-DEC-2017 15:36:40 4688142 02-DEC-2017 15:36:44 1 304 4688142 02-DEC-2017 15:36:44 4688146 02-DEC-2017 15:36:44 1 305 4688146 02-DEC-2017 15:36:44 4688156 02-DEC-2017 15:36:47 1 306 4688156 02-DEC-2017 15:36:47 4688160 02-DEC-2017 15:36:47 1 307 4688160 02-DEC-2017 15:36:47 4688170 02-DEC-2017 15:36:50 1 308 4688170 02-DEC-2017 15:36:50 4688174 02-DEC-2017 15:36:50 1 309 4688174 02-DEC-2017 15:36:50 4688184 02-DEC-2017 15:36:53 1 310 4688184 02-DEC-2017 15:36:53 4688188 02-DEC-2017 15:36:54 1 311 4688188 02-DEC-2017 15:36:54 4688198 02-DEC-2017 15:36:56 1 312 4688198 02-DEC-2017 15:36:56 4690007 02-DEC-2017 15:50:40 1 313 4690007 02-DEC-2017 15:50:40 4690015 02-DEC-2017 15:50:42 1 314 4690015 02-DEC-2017 15:50:42 4690116 02-DEC-2017 15:51:28 1 315 4690116 02-DEC-2017 15:51:28 4690212 02-DEC-2017 15:52:07 1 316 4690212 02-DEC-2017 15:52:07 4690327 02-DEC-2017 15:52:49 1 317 4690327 02-DEC-2017 15:52:49 4690692 02-DEC-2017 15:55:22 1 318 4690692 02-DEC-2017 15:55:22 4691069 02-DEC-2017 15:58:17 1 319 4691069 02-DEC-2017 15:58:17 4691175 02-DEC-2017 15:59:01 1 320 4691175 02-DEC-2017 15:59:01 4691859 02-DEC-2017 16:04:04BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------------8 106.00K DISK 00:00:00 02-DEC-2017 16:04:17 BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20171202T160416 Piece Name: /home/oracle/arch_ORCL_961689857_15.bak List of Archived Logs in backup set 8 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- -------------------- ---------- --------- 1 321 4691859 02-DEC-2017 16:04:04 4691982 02-DEC-2017 16:04:16RMAN> 小结:
当备份归档日志使用from time的时候,CONFIGURE BACKUP OPTIMIZATION ON; 设置失效。
当备份归档日志使用all的时候,CONFIGURE BACKUP OPTIMIZATION ON; 设置生效。
备份
日志
时候
小结
过程
实验
优化设置
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
什么是科技互联网
上海睿民互联网科技有限公司
哈尔滨大商圈互联网科技有限公司
北京路客互联网科技有限公司
互联网科技卖菜
与互联网科技公司
互联网 科技创新
嘟嘟瓜互联网科技
润盈互联网科技
左右互联网络科技
互联网科技寓意
栖莱科技互联网股份有限公司
互联网科技有哪些公司
互联网科技革命什么开始
用友工业互联网科技发展
互联网科技公司营业执照怎么办理
互联网方面的科技前沿
2021互联网科技公司排名
上海钢联属于互联网科技股吗
科技互联网行业投资研究
互联网科技的发展
互联网科技公司怎么样
重庆科技学院互联网
居家互联网科技有限公司
互联网科技类展会
顶级互联网科技成果有哪些
互联网科技与大数据专业
互联网科技研发水平
科技互联网的核心竞争力
上海京穆互联网科技有限公司