请教:
我在oracle9i中做增量备份,执行backup database plus archivelog delete input; 时出现下面的错误,该如何解决?
database session for channel ora_disk_1 terminated unexpectedly
我在oracle9i中做增量备份,执行backup database plus archivelog delete input; 时出现下面的错误,该如何解决?
database session for channel ora_disk_1 terminated unexpectedly
解决方案 »
- Oracle下创建数据库的SQL命令(高分!)
- oracle8i的DBA Studio无法打开
- 求一句sql
- oracle能否在一般机子上跑起来
- 求写一个关于日期类的SQL语句
- 请问记录对某个表的删除操作的触发器该怎么写?
- 求教一条24小时连锁店的统计问题
- 在删除Oracle 9i的表的时候出现“All version enabled tables owned by 'table' must be disabled first”?
- 8。0。6的dmp文件,导入8。1。7中,导入导致进程停滞?
- oracle 11g 行级触发器中:old与:new后面的字段名能不能是动态的?
- 求教
- oracle定时器(jop)
把show all;
的内容也贴了看看。
using target database controlfile instead of recovery catalog
RMAN configuration parameters 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 "d:\backup1\ctl_
%F";
CONFIGURE DEVICE TYPE DISK 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 CHANNEL 1 DEVICE TYPE DISK FORMAT "d:\oracle\backup1\backup_%U.dbf";CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\DATABASE\SNCFBJSGX.ORA'; # default这是show all 的结果
你手动allocate一个通道看看。
结果:
Starting backup at 11-OCT-08
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=16 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=223 recid=11 stamp=667842573
channel ORA_DISK_1: starting piece 1 at 11-OCT-08
channel ORA_DISK_1: finished piece 1 at 11-OCT-08
piece handle=D:\ORACLE\BACKUP1\BACKUP_0KJSSU0D_1_1.DBF comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=D:\ORACLE\RDBMS\ARC00223.001 recid=11 stamp=667842573
Finished backup at 11-OCT-08
Starting backup at 11-OCT-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00008 name=D:\ORACLE\ORADATA\BJSGX\TOOLS01.DBF
input datafile fno=00001 name=D:\ORACLE\ORADATA\BJSGX\SYSTEM01.DBF
input datafile fno=00013 name=D:\ORACLE\ORADATA\BJSGX\MEMBER.ORA
input datafile fno=00002 name=D:\ORACLE\ORADATA\BJSGX\UNDOTBS01.DBF
input datafile fno=00005 name=D:\ORACLE\ORADATA\BJSGX\EXAMPLE01.DBF
input datafile fno=00011 name=D:\ORACLE\ORADATA\BJSGX\BJMEMBER.ORA
input datafile fno=00010 name=D:\ORACLE\ORADATA\BJSGX\XDB01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\BJSGX\INDX01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\BJSGX\USERS01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\BJSGX\CWMLITE01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\BJSGX\DRSYS01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\BJSGX\ODM01.DBF
input datafile fno=00012 name=D:\ORACLE\ORADATA\MES09\EM.ORA
channel ORA_DISK_1: starting piece 1 at 11-OCT-08
channel ORA_DISK_1: finished piece 1 at 11-OCT-08
piece handle=D:\ORACLE\BACKUP1\BACKUP_0LJSSU0G_1_1.DBF comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:26 Finished backup at 11-OCT-08 Starting backup at 11-OCT-08 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=224 recid=12 stamp=667842903 channel ORA_DISK_1: starting piece 1 at 11-OCT-08 channel ORA_DISK_1: finished piece 1 at 11-OCT-08 piece handle=D:\ORACLE\BACKUP1\BACKUP_0MJSSUAN_1_1.DBF comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_1: deleting archive log(s) archive log filename=D:\ORACLE\RDBMS\ARC00224.001 recid=12 stamp=667842903 Finished backup at 11-OCT-08 Starting Control File and SPFILE Autobackup at 11-OCT-08 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00601: fatal error in recovery manager RMAN-03004: fatal error during execution of command RMAN-10038: database session for channel ORA_DISK_1 terminated unexpectedly
有问题了。
路径是不是应该是: d:\oracle\backup1\
不知道自己执行的是否有问题,盼指教,谢谢!
configure CONTROLFILE AUTOBACKUP off;
backup database include current controlfile plus archivelog delete input;
configure CONTROLFILE AUTOBACKUP off;
backup database include current controlfile plus archivelog delete input;
没有报错,可以备份。我有一些疑问,如果设置成configure CONTROLFILE AUTOBACKUP off; 就没有备份
Control File and SPFILE ,没有这两个文件,能恢复吗?
我上面给你写的脚本有include current controlfile,等于是手动备份了控制文件。
spfile一般都不备份的。实在要备,你就在你的脚本里加个backup spfile不就行了吗。