12crmanoptimization优化设置失效?
实验过程
我们提供的服务有:网站建设、网站设计、微信公众号开发、网站优化、网站认证、安远ssl等。为上1000家企事业单位解决了网站和推广的问题。提供周到的售前咨询和贴心的售后服务,是有科学管理、有技术的安远网站制作公司
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup archivelog from time 'sysdate-1/12' format '/home/oracle/arch_%d_%t_%s.bak';
Starting backup at 02-DEC-2017 16:04:04
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=296 RECID=562 STAMP=961687168
input archived log thread=1 sequence=297 RECID=563 STAMP=961687503
input archived log thread=1 sequence=298 RECID=568 STAMP=961687506
input archived log thread=1 sequence=299 RECID=570 STAMP=961688188
input archived log thread=1 sequence=300 RECID=572 STAMP=961688197
input archived log thread=1 sequence=301 RECID=574 STAMP=961688200
input archived log thread=1 sequence=302 RECID=576 STAMP=961688200
input archived log thread=1 sequence=303 RECID=578 STAMP=961688204
input archived log thread=1 sequence=304 RECID=580 STAMP=961688205
input archived log thread=1 sequence=305 RECID=582 STAMP=961688207
input archived log thread=1 sequence=306 RECID=584 STAMP=961688208
input archived log thread=1 sequence=307 RECID=586 STAMP=961688210
input archived log thread=1 sequence=308 RECID=588 STAMP=961688211
input archived log thread=1 sequence=309 RECID=590 STAMP=961688214
input archived log thread=1 sequence=310 RECID=592 STAMP=961688214
input archived log thread=1 sequence=311 RECID=594 STAMP=961688216
input archived log thread=1 sequence=312 RECID=596 STAMP=961689040
input archived log thread=1 sequence=313 RECID=598 STAMP=961689042
input archived log thread=1 sequence=314 RECID=600 STAMP=961689088
input archived log thread=1 sequence=315 RECID=602 STAMP=961689127
input archived log thread=1 sequence=316 RECID=604 STAMP=961689169
input archived log thread=1 sequence=317 RECID=606 STAMP=961689323
input archived log thread=1 sequence=318 RECID=608 STAMP=961689498
input archived log thread=1 sequence=319 RECID=610 STAMP=961689541
input archived log thread=1 sequence=320 RECID=612 STAMP=961689844
channel ORA_DISK_1: starting piece 1 at 02-DEC-2017 16:04:04
channel ORA_DISK_1: finished piece 1 at 02-DEC-2017 16:04:05
piece handle=/home/oracle/arch_ORCL_961689844_14.bak tag=TAG20171202T160404 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-DEC-2017 16:04:05
RMAN>
RMAN> backup archivelog all format '/home/oracle/arch_%d_%t_%s.bak';
Starting backup at 02-DEC-2017 16:04:16
current log archived
using channel ORA_DISK_1
skipping archived logs of thread 1 from sequence 227 to 320; already backed up
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=321 RECID=614 STAMP=961689856
channel ORA_DISK_1: starting piece 1 at 02-DEC-2017 16:04:17
channel ORA_DISK_1: finished piece 1 at 02-DEC-2017 16:04:18
piece handle=/home/oracle/arch_ORCL_961689857_15.bak tag=TAG20171202T160416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-DEC-2017 16:04:18
RMAN> 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:04
BS 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:16
RMAN>
小结:
当备份归档日志使用from time的时候,CONFIGURE BACKUP OPTIMIZATION ON; 设置失效。
当备份归档日志使用all的时候,CONFIGURE BACKUP OPTIMIZATION ON; 设置生效。
本文题目:12crmanoptimization优化设置失效?
网页URL:http://myzitong.com/article/pojecp.html