我是新手,刚学的rman备份,遇到一些问题,请高手指教,操做过程如下:
SQL> conn / as sysdba
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> alter system archive log start;
SQL> exit
连接:
rman target=rman/rman@test
基本设置:
RMAN> configure default device type to disk;
RMAN> configure device type disk parallelism 2;
RMAN> configure channel 1 device type disk format 'D:/backup1/backup_%U';
RMAN> configure channel 2 device type disk format 'D:/backup2/backup_%U';
RMAN> configure controlfile autobackup on;
RMAN> configure controlfile autobackup format for device type disk to 'D:/backup1/ctl_%F';
查看所有设置:
RMAN> show all
查看数据库方案报表:
RMAN> report schema;
备份全库:
RMAN> backup database plus archivelog delete input;
备份归档日志:
RMAN> backup archivelog all delete input;
查看备份和文件复本:
RMAN> list backup;
验证备份:
RMAN> validate backupset 3;
当验证的时候出现ora-19624:操作失败,如果可能请重试 ora-19554:配置设备出错,设备类型:DISKYPE,设备名称ora-27001不受支持的设备类型。 如果设备类型不对的话为什么能备份成功呢啊?请高手帮帮我怎么解决遇到的错误,谢谢了
SQL> conn / as sysdba
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> alter system archive log start;
SQL> exit
连接:
rman target=rman/rman@test
基本设置:
RMAN> configure default device type to disk;
RMAN> configure device type disk parallelism 2;
RMAN> configure channel 1 device type disk format 'D:/backup1/backup_%U';
RMAN> configure channel 2 device type disk format 'D:/backup2/backup_%U';
RMAN> configure controlfile autobackup on;
RMAN> configure controlfile autobackup format for device type disk to 'D:/backup1/ctl_%F';
查看所有设置:
RMAN> show all
查看数据库方案报表:
RMAN> report schema;
备份全库:
RMAN> backup database plus archivelog delete input;
备份归档日志:
RMAN> backup archivelog all delete input;
查看备份和文件复本:
RMAN> list backup;
验证备份:
RMAN> validate backupset 3;
当验证的时候出现ora-19624:操作失败,如果可能请重试 ora-19554:配置设备出错,设备类型:DISKYPE,设备名称ora-27001不受支持的设备类型。 如果设备类型不对的话为什么能备份成功呢啊?请高手帮帮我怎么解决遇到的错误,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货