为什么我在配置的时候会报错: RMAN> configure channel 1 device type disk format '/opt/ora_data/backup/full%s_%t_%U';new RMAN configuration parameters: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/opt/ora_data/backup/full%s_%t_%U'; new RMAN configuration parameters are successfully stored RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of configure command at 03/27/2009 03:25:48 ORA-01013: user requested cancel of current operation
configure channel device type disk format '/opt/ora_data/backup/full%s_%t_%U';
谢谢楼上兄弟,但是修改完成以后,我使用BACKUP DATABASE;备份却又出现以下错误,是否还需要配置其他有关设备最大长度的参数: RMAN> backup database;Starting backup at 28-MAR-09 using target database control file instead of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 03/28/2009 21:10:50 ORA-19700: device type exceeds maximum length of 16 下面是我的参数: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO '/OPT/ORA_DATA/BACKUP/'; CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /OPT/ORA_DATA/BACKUP/ TO '%F'; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE /OPT/ORA_DATA/BACKUP/ PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /OPT/ORA_DATA/BACKUP/ TO 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /OPT/ORA_DATA/BACKUP/ TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/opt/ora_data/backup/full%s_%t_%U'; CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/opt/ora_data/backup/full%s_%t_%U'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/10.2.0/db_1/dbs/snapcf_orctest.f'; # default
先把所有的clear掉吧.看着都是晕的.
原因找到了 CONFIGURE DEFAULT DEVICE TYPE TO '/OPT/ORA_DATA/BACKUP/';配置有问题,应该是配置为DISK 谢谢
RMAN> configure channel 1 device type disk format '/opt/ora_data/backup/full%s_%t_%U';new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/opt/ora_data/backup/full%s_%t_%U';
new RMAN configuration parameters are successfully stored
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 03/27/2009 03:25:48
ORA-01013: user requested cancel of current operation
RMAN> backup database;Starting backup at 28-MAR-09
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/28/2009 21:10:50
ORA-19700: device type exceeds maximum length of 16
下面是我的参数:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO '/OPT/ORA_DATA/BACKUP/';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /OPT/ORA_DATA/BACKUP/ TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE /OPT/ORA_DATA/BACKUP/ PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /OPT/ORA_DATA/BACKUP/ TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /OPT/ORA_DATA/BACKUP/ TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/opt/ora_data/backup/full%s_%t_%U';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/opt/ora_data/backup/full%s_%t_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/10.2.0/db_1/dbs/snapcf_orctest.f'; # default
CONFIGURE DEFAULT DEVICE TYPE TO '/OPT/ORA_DATA/BACKUP/';配置有问题,应该是配置为DISK
谢谢