XE backup failed!
Hi,
Yesterday I upgraded my XE version of apex from 3.2.1 to 4.0.
Success.
I made a backup for xe before upgrading, and then after upgrading I made up another backup, my db is in archieve log mode.
but after I input some data, and I want to make another backup of my db, I failed. that was yersterday, 27th June 2010.
This morning, I tried to backup again, and the same problem.
and I surprisingly found that my archieve log files for 27th is 1.5G !!! normally it only reaches several mbs.
Is that the problem.
?
I got the below the message at my backup log file:
-------------------------------------------------------
恢复管理器: Release 10.2.0.1.0 - Production on 星期一 6月 28 08:59:37 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1533M/2047M, Ph+PgF:3617M/4958M, VA:2002M/2047M
Starting with debugging turned off
连接到目标数据库: XE (DBID=2545514137)
RMAN> set echo on;
2> configure controlfile autobackup format for device type disk clear;
3> configure retention policy to redundancy 2;
4> configure controlfile autobackup on;
5> sql "create pfile=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile";
6> backup as backupset device type disk database;
7> configure controlfile autobackup off;
8> sql 'alter system archive log current';
9> delete noprompt obsolete;
10>
回显已打开
使用目标数据库控制文件替代恢复目录
RMAN 配置参数已成功重置为默认值
旧的 RMAN 配置参数:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
新的 RMAN 配置参数:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
已成功存储新的 RMAN 配置参数
旧的 RMAN 配置参数:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
新的 RMAN 配置参数:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
已成功存储新的 RMAN 配置参数
sql 语句: create pfile=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile
启动 backup 于 28-6月 -10
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=267 devtype=DISK
通道 ORA_DISK_1: 启动全部数据文件备份集
通道 ORA_DISK_1: 正在指定备份集中的数据文件
输入数据文件 fno=00003 name=C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
输入数据文件 fno=00001 name=C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
输入数据文件 fno=00002 name=C:\ORACLEXE\ORADATA\XE\UNDO.DBF
输入数据文件 fno=00004 name=C:\ORACLEXE\ORADATA\XE\USERS.DBF
输入数据文件 fno=00005 name=C:\ORACLEXE\ORADATA\XE\FLOW_7499102653899703.DBF
通道 ORA_DISK_1: 正在启动段 1 于 28-6月 -10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: backup 命令 (ORA_DISK_1 通道上, 在 06/28/2010 09:02:08 上) 失败
RMAN-10035: RPC 中出现异常错误:
ORA-19583: 交谈因错误而终止
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 52428800 字节磁盘空间 (从 5368709120 限制中)
ORA-06512: 在 "SYS.DBMS_BACKUP_RESTORE", line 1077
RMAN-10031: RPC 错误: ORA-19583, 在调用 DBMS_BACKUP_RESTORE.BACKUPPIECECREATE 时出现
恢复管理器完成。
----------------------------------------------
any idea?
my allocation for flash_recovery_area is 5G?
one backupset file is 1.4G.
Oh, that might be the problem, I have used up 3.84G of that space. so it is not enough space for another backupset file.
Oh, I need to change the space_quota of flash_recovery_area.
Ok, let's try it.
Peter