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/