Dear All,
Recently I cannot backup oracle DB, when i check the logs i got below error, could anyone please help me how to fix this?
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Jul 3 08:19:20 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Windows NT Version V6.1 Service Pack 1
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x0x00000000
Memory (Avail/Total): Ph:1445M/4095M, Ph+PgF:5266M/8189M, VA:1925M/2047M VM name : VMWare Version (6)
Starting with debugging turned off
connected to target database: XE (DBID=2690903275)
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=''E:\COMPANY\ORACLEXE\APP\ORACLE\PRODUCT\11.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>
echo set on
using target database control file instead of recovery catalog
RMAN configuration parameters are successfully reset to default value
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
sql statement: create pfile=''E:\COMPANY\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile
Starting backup at 03-JUL-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=E:\COMPANY\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=E:\COMPANY\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00002 name=E:\COMPANY\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=E:\COMPANY\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 03-JUL-15
Calling krmmpem from krmmexe
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/03/2015 08:19:26
RMAN-10035: exception raised in RPC:
ORA-19583: conversation terminated due to error
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10737418240 limit
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 1381
RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
Recovery Manager complete.