RMAN-06580: the SECBYTES option cannot be used with AS COPY

1

问题:

RMAN-06580: the SECBYTES option cannot be used with AS COPY

2           

原因:

RMAN> show all;

 

RMAN configuration parameters for database with db_unique_name PROD1 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1;

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 ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_PROD1.f'; # default

 

3

解决方法:

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1; 

 

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1;

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;

new RMAN configuration parameters are successfully stored

released channel: ORA_DISK_1

 

4

测验:

RMAN> run

2> {

3> allocate channel c1 device type disk;

4> allocate channel c2 device type disk;

5> allocate channel c3 device type disk;

6> allocate channel c4 device type disk;

7> backup datafile 1 section size 130m tag=

8> 'secton_df1';

9> }

 

allocated channel: c1

channel c1: SID=146 device type=DISK

 

allocated channel: c2

channel c2: SID=148 device type=DISK

 

allocated channel: c3

channel c3: SID=26 device type=DISK

 

allocated channel: c4

channel c4: SID=149 device type=DISK

 

Starting backup at 03-FEB-16

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf

backing up blocks 1 through 16640

channel c1: starting piece 1 at 03-FEB-16

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf

backing up blocks 16641 through 33280

channel c2: starting piece 2 at 03-FEB-16

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf

backing up blocks 33281 through 49920

channel c3: starting piece 3 at 03-FEB-16

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf

backing up blocks 49921 through 66560

channel c4: starting piece 4 at 03-FEB-16

channel c1: finished piece 1 at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hht8_.bkp tag=SECTON_DF1 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf

backing up blocks 66561 through 83200

channel c1: starting piece 5 at 03-FEB-16

channel c1: finished piece 5 at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hl96_.bkp tag=SECTON_DF1 comment=NONE

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

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf

backing up blocks 83201 through 96000

channel c1: starting piece 6 at 03-FEB-16

channel c2: finished piece 2 at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjkx_.bkp tag=SECTON_DF1 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:05

channel c3: finished piece 3 at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjmb_.bkp tag=SECTON_DF1 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:05

channel c4: finished piece 4 at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjnn_.bkp tag=SECTON_DF1 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:05

channel c1: finished piece 6 at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hol4_.bkp tag=SECTON_DF1 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 03-FEB-16

 

Starting Control File and SPFILE Autobackup at 03-FEB-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902842614_cc34hpst_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 03-FEB-16

released channel: c1

released channel: c2

released channel: c3

released channel: c4

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-1986063/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/30606702/viewspace-1986063/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值