12c rman optimization优化设置失效?
发表于:2025-02-05 作者:千家信息网编辑
千家信息网最后更新 2025年02月05日,实验过程RMAN> show all;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE
千家信息网最后更新 2025年02月05日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安全错误
数据库的锁怎样保障安全
软件开发测试用例编写
数据库 经典书籍
VB数据库英文单词
网络安全脚本视频
td350服务器能装8t硬盘吗
打开数据库显示要密码
剑网三创建角色数据库
软件开发验收报告
软件开发培训手册
服务器 多少人
政务智能网络技术
阿里云服务器安装svn
武大网络安全学院2021
康复数据库
win10管理服务器在哪
软件开发属于哪个专业
我的世界差点被炸毁的服务器
服务器硬盘都有什么用
网络安全服务内涵
西安国研软件开发
网络技术与社会
mc连服务器卡顿
百度数据库安全员
服务器安全狗iis兼容版
甲骨文美国数据库
欧盟网络安全工具箱
落实实施网络安全法
龙团信息技术大数据库
关于2g通信网络技术论文
如何新建另一个数据库