PDA

View Full Version : RMAN-06580: the SETSIZE option cannot be used with AS COPY


Anna Macnaughtan
05-20-2010, 10:21 AM
Problem:
Backing up a primary database with RMAN (to create a standby) fails:
$ sqlplus "/ as sysdba"
SQL> startup nomount

$ rman
connect target /
run{
change archivelog all crosscheck;
allocate channel ch1 type disk;
backup incremental level 0 database format
'/oracle/orabase/backupfile/bk_inc0_%s_%p' setsize=8250000 include current
controlfile for standby ;
sql "alter system archive log current";
backup archivelog all format '/oracle/orabase/backupfile/al_%s_%p';
release channel ch1;
}
with an error message:
RMAN-06580: the SETSIZE option cannot be used with AS COPY

Suggestion:
DEVICE TYPE DISK may be configured with BACKUP TYPE TO COPY. To confirm run the following command:
$ rman
connect target /
show device type;

If RMAN configuration parameter BACKUP TYPE is TO COPY then change it to BACKUPSET:
$ rman
configure device type disk backup type to BACKUPSET;