我配置了一个数据库全备份的脚本,为什么执行的时候会返回如下的错误呢?
RMAN> run {
2> allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MES\b_%u_%s_%p';
3> backup ( database include current controlfile );
4> backup ( archivelog all
5> delete input );
6>
7> }
8>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: DefaultChannel
RMAN-08500: channel DefaultChannel: sid=73 devtype=DISKRMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel DefaultChannel: starting full datafile backupset
RMAN-08502: set_count=9 set_stamp=556561804 creation_time=APR 25 2005 16:30:04
RMAN-08010: channel DefaultChannel: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=E:\ORACLE\ORADATA\MES\RBS01.DBF
RMAN-08522: input datafile fno=00004 name=E:\ORACLE\ORADATA\MES\TEMP01.DBF
RMAN-08522: input datafile fno=00008 name=E:\ORACLE\ORADATA\MES\RMES01.DBF
RMAN-08522: input datafile fno=00009 name=E:\ORACLE\ORADATA\MES\RMES02.DBF
RMAN-08522: input datafile fno=00010 name=E:\ORACLE\ORADATA\MES\RMES03.DBF
RMAN-08522: input datafile fno=00017 name=E:\ORACLE\ORADATA\MES\RMES04.DBF
RMAN-08522: input datafile fno=00011 name=E:\ORACLE\ORADATA\MES\INDX02.DBF
RMAN-08522: input datafile fno=00012 name=E:\ORACLE\ORADATA\MES\INDX03.DBF
RMAN-08522: input datafile fno=00006 name=E:\ORACLE\ORADATA\MES\INDX01.DBF
RMAN-08522: input datafile fno=00001 name=E:\ORACLE\ORADATA\MES\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00003 name=E:\ORACLE\ORADATA\MES\USERS01.DBF
RMAN-08522: input datafile fno=00013 name=E:\ORACLE\ORADATA\MES\HMES01.DBF
RMAN-08522: input datafile fno=00014 name=E:\ORACLE\ORADATA\MES\HMES02.DBF
RMAN-08522: input datafile fno=00015 name=E:\ORACLE\ORADATA\MES\HMES03.DBF
RMAN-08522: input datafile fno=00016 name=E:\ORACLE\ORADATA\MES\HMES04.DBF
RMAN-08522: input datafile fno=00005 name=E:\ORACLE\ORADATA\MES\TOOLS01.DBF
RMAN-08522: input datafile fno=00007 name=E:\ORACLE\ORADATA\MES\CMES01.DBF
RMAN-08013: channel DefaultChannel: piece 1 created
RMAN-08503: piece handle=E:\ORACLE\ORADATA\MES\B_09GIOTCC_9_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:09:26RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: DefaultChannel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log E:\ORACLE\ORA81\RDBMS\ARC30210.001 not found or out of sync with catalogRecovery Manager complete.
child process exited abnormally如果只备份表空间就是正常的,可能执行成功。
RMAN> run {
2> allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MES\b_%u_%s_%p';
3> backup ( database include current controlfile );
4> backup ( archivelog all
5> delete input );
6>
7> }
8>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: DefaultChannel
RMAN-08500: channel DefaultChannel: sid=73 devtype=DISKRMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel DefaultChannel: starting full datafile backupset
RMAN-08502: set_count=9 set_stamp=556561804 creation_time=APR 25 2005 16:30:04
RMAN-08010: channel DefaultChannel: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=E:\ORACLE\ORADATA\MES\RBS01.DBF
RMAN-08522: input datafile fno=00004 name=E:\ORACLE\ORADATA\MES\TEMP01.DBF
RMAN-08522: input datafile fno=00008 name=E:\ORACLE\ORADATA\MES\RMES01.DBF
RMAN-08522: input datafile fno=00009 name=E:\ORACLE\ORADATA\MES\RMES02.DBF
RMAN-08522: input datafile fno=00010 name=E:\ORACLE\ORADATA\MES\RMES03.DBF
RMAN-08522: input datafile fno=00017 name=E:\ORACLE\ORADATA\MES\RMES04.DBF
RMAN-08522: input datafile fno=00011 name=E:\ORACLE\ORADATA\MES\INDX02.DBF
RMAN-08522: input datafile fno=00012 name=E:\ORACLE\ORADATA\MES\INDX03.DBF
RMAN-08522: input datafile fno=00006 name=E:\ORACLE\ORADATA\MES\INDX01.DBF
RMAN-08522: input datafile fno=00001 name=E:\ORACLE\ORADATA\MES\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00003 name=E:\ORACLE\ORADATA\MES\USERS01.DBF
RMAN-08522: input datafile fno=00013 name=E:\ORACLE\ORADATA\MES\HMES01.DBF
RMAN-08522: input datafile fno=00014 name=E:\ORACLE\ORADATA\MES\HMES02.DBF
RMAN-08522: input datafile fno=00015 name=E:\ORACLE\ORADATA\MES\HMES03.DBF
RMAN-08522: input datafile fno=00016 name=E:\ORACLE\ORADATA\MES\HMES04.DBF
RMAN-08522: input datafile fno=00005 name=E:\ORACLE\ORADATA\MES\TOOLS01.DBF
RMAN-08522: input datafile fno=00007 name=E:\ORACLE\ORADATA\MES\CMES01.DBF
RMAN-08013: channel DefaultChannel: piece 1 created
RMAN-08503: piece handle=E:\ORACLE\ORADATA\MES\B_09GIOTCC_9_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:09:26RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: DefaultChannel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log E:\ORACLE\ORA81\RDBMS\ARC30210.001 not found or out of sync with catalogRecovery Manager complete.
child process exited abnormally如果只备份表空间就是正常的,可能执行成功。
解决方案 »
- oracle11怎么备份oracle10G的数据
- 请教一个imp问题 表内有大量XML信息 报错是申请不到内存
- like 后跟 substr问题?
- 如何提高Oracle语句的执行效率
- 在用.net向oracle 9i 数据库clob字段中插入值成乱码
- 刚用存储过程,此存储过程错误,请指正
- 从oracle 8i到9i数据增大的问题
- 急问一条SQL语句!!关于分布和排序的!!!
- 【期待高手】在[存储过程]中是否可以将数据表的所有记录 spool 到一个文本文件??这个文件是放在了数据库服务器上,还是客户端??
- 怎样用PB6.5存储过程类型数据窗口调用ORACLE8.1中存储过程返回的记录集
- dblink 的事务问题
- rman 增量备份的问题
rman target / catalog rman/rman@rman
rman>resync catalog;
rman>quit;
如果上面不行,则执行以下内容:
rman target / catalog rman/rman@rman
rman>ALLOCATE CHANNEL FOR DELETE DEVICE TYPE DISK;
rman>CHANGE ARCHIVELOG ALL DELETE;
rman>RELEASE CHANNEL;
rman>quit;
再执行全库备份。
或catalog 同步问题。试试用crosscheck同步一下。再测试。
同步是没有问题的。