Home » RDBMS Server » Backup & Recovery » RMAN Backup failed. (ORACLE 10g R2 (10.2.0.1.0))
RMAN Backup failed. [message #489241] Thu, 13 January 2011 23:33 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
Hi All,

I was taking RMAN backup of Remote Server and it failed in between, i check space of the flash recovery area folder there is still space left.

Below are the logs:

RMAN> connect target sys/oracle@orcl75

connected to target database: RI (DBID=2498905454)

RMAN> backup database plus archivelog;


Starting backup at 14-JAN-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=127 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=6180 recid=1 stamp=739108613
input archive log thread=1 sequence=6181 recid=2 stamp=739108614
input archive log thread=1 sequence=6182 recid=3 stamp=739131635
input archive log thread=1 sequence=6183 recid=4 stamp=739146201
input archive log thread=1 sequence=6184 recid=5 stamp=739183261
input archive log thread=1 sequence=6185 recid=6 stamp=739228604
input archive log thread=1 sequence=6186 recid=7 stamp=739232612
input archive log thread=1 sequence=6187 recid=8 stamp=739260017
input archive log thread=1 sequence=6188 recid=9 stamp=739312240
input archive log thread=1 sequence=6189 recid=10 stamp=739344613
input archive log thread=1 sequence=6190 recid=11 stamp=739405429
input archive log thread=1 sequence=6191 recid=12 stamp=739438248
input archive log thread=1 sequence=6192 recid=13 stamp=739481219
input archive log thread=1 sequence=6193 recid=14 stamp=739491837
input archive log thread=1 sequence=6194 recid=15 stamp=739535760
input archive log thread=1 sequence=6195 recid=16 stamp=739576885
input archive log thread=1 sequence=6196 recid=17 stamp=739582273
input archive log thread=1 sequence=6197 recid=18 stamp=739632070
input archive log thread=1 sequence=6198 recid=19 stamp=739661596
input archive log thread=1 sequence=6199 recid=20 stamp=739675370
input archive log thread=1 sequence=6200 recid=21 stamp=739721219
input archive log thread=1 sequence=6201 recid=22 stamp=739749734
input archive log thread=1 sequence=6202 recid=23 stamp=739765871
input archive log thread=1 sequence=6203 recid=24 stamp=739813800
input archive log thread=1 sequence=6204 recid=25 stamp=739836516
input archive log thread=1 sequence=6205 recid=26 stamp=739864843
input archive log thread=1 sequence=6206 recid=27 stamp=739900518
input archive log thread=1 sequence=6207 recid=28 stamp=739948407
input archive log thread=1 sequence=6208 recid=29 stamp=740010330
input archive log thread=1 sequence=6209 recid=30 stamp=740061026
input archive log thread=1 sequence=6210 recid=31 stamp=740077887
input archive log thread=1 sequence=6211 recid=32 stamp=740082048
input archive log thread=1 sequence=6212 recid=33 stamp=740082060
input archive log thread=1 sequence=6213 recid=34 stamp=740082080
input archive log thread=1 sequence=6214 recid=35 stamp=740082086
input archive log thread=1 sequence=6215 recid=36 stamp=740095380
input archive log thread=1 sequence=6216 recid=37 stamp=740119155
input archive log thread=1 sequence=6217 recid=38 stamp=740145826
input archive log thread=1 sequence=6218 recid=39 stamp=740178323
input archive log thread=1 sequence=6219 recid=40 stamp=740197857
input archive log thread=1 sequence=6220 recid=41 stamp=740230045
input archive log thread=1 sequence=6221 recid=42 stamp=740257702
input archive log thread=1 sequence=6222 recid=43 stamp=740274886
input archive log thread=1 sequence=6223 recid=44 stamp=740313077
input archive log thread=1 sequence=6224 recid=45 stamp=740350212
input archive log thread=1 sequence=6225 recid=46 stamp=740377871
input archive log thread=1 sequence=6226 recid=47 stamp=740400967
channel ORA_DISK_1: starting piece 1 at 14-JAN-11
channel ORA_DISK_1: finished piece 1 at 14-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\RI\BACKUPSET\2011_01_14\O1_MF_ANNNN_TAG20110114T105607_6LZQMODH_.BKP tag=TAG20110114T105607 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:28
Finished backup at 14-JAN-11

Starting backup at 14-JAN-11
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=00004 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\RI\USERS01.DBF
input datafile fno=00006 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\RI\USERS02.DBF
input datafile fno=00001 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\RI\SYSTEM01.DBF
input datafile fno=00007 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\RI\UNDOTBS001.DBF
input datafile fno=00003 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\RI\SYSAUX01.DBF
input datafile fno=00005 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\RI\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 14-JAN-11
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/14/2011 11:02:54
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 5368709120 limit
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 14-JAN-11
channel ORA_DISK_1: finished piece 1 at 14-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\RI\BACKUPSET\2011_01_14\O1_MF_NCSNF_TAG20110114T105839_6LZR08NM_.BKP tag=TAG20110114T105839 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 01/14/2011 11:02:57

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/14/2011 11:02:54
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 5368709120 limit

RMAN>
What could be the reason? Is it the db_recovery_file_dest_size that is conflicting as the size specified is limited If Yes, then how can I remove the limit of size on this parameter.

Regards
Deepak

Report message to a moderator

Re: RMAN Backup failed. [message #489250 is a reply to message #489241] Fri, 14 January 2011 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Is it the db_recovery_file_dest_size that is conflicting as the size specified is limited

Yes.

Quote:
how can I remove the limit of size on this parameter

Increase its value. See DB_RECOVERY_FILE_DEST_SIZE in documentation.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #489252 is a reply to message #489250] Fri, 14 January 2011 01:21 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
If I am not going to specify any value for db_recovery_file_dest_size , so the default value it is going to take will be maximum space availble on my hard disk drive RIGHT SIR?

Regards
Deepak

Report message to a moderator

Re: RMAN Backup failed. [message #489253 is a reply to message #489252] Fri, 14 January 2011 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use SQL*Plus, execute the following and post it:
show parameter db_recovery_file

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #489260 is a reply to message #489253] Fri, 14 January 2011 02:04 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
 
SQL> show parameter db_recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      E:\oracle\product\10.2.0/flash
                                                 _recovery_area
db_recovery_file_dest_size           big integer 5G

Regards
Deepak

[Updated on: Fri, 14 January 2011 02:14] by Moderator

Report message to a moderator

Re: RMAN Backup failed. [message #489261 is a reply to message #489241] Fri, 14 January 2011 02:08 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
is space available at the specified location?

please post output of foll:

select SPACE_USED,SPACE_LIMIT from  v$recovery_file_dest;

Report message to a moderator

Re: RMAN Backup failed. [message #489262 is a reply to message #489260] Fri, 14 January 2011 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dsharma wrote on Fri, 14 January 2011 09:04
SQL> show parameter db_recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      E:\oracle\product\10.2.0/flash
                                                 _recovery_area
db_recovery_file_dest_size           big integer 5G

Regards
Deepak


1/ Use CODE tags then it is easier to read (don't you think it is easier now I added it?)
2/ Remove from output useless lines like "SQL> " alone.
3/ See you set the max size, if you want more (and have it) then increase the value
4/ If you can't increase the value then remove some contents defining an appropriate RMAN policy and execute "delete obsolete".

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #489267 is a reply to message #489261] Fri, 14 January 2011 03:31 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
SQL> select SPACE_USED,SPACE_LIMIT from v$recovery_file_dest;

SPACE_USED SPACE_LIMIT
---------- -----------
2113325568 5368709120

Regards
Deepak

Report message to a moderator

Re: RMAN Backup failed. [message #489268 is a reply to message #489262] Fri, 14 January 2011 03:36 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
Thanks for your guidence Sir, but I donot know how to use this CODE TAG. If you can help me out, as I also always search that how you all place this SQL code in a block.

Please tell me steps to follow.

Regards
Deepak

Report message to a moderator

Re: RMAN Backup failed. [message #489270 is a reply to message #489241] Fri, 14 January 2011 03:43 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hello dsharma

Use the leftmost icon in 'Formatting tools:'
It looks like {-}

Alternatively you can enclose the 'code and code output' related text in the 
 and
tags

Regards,
OraKaran

Report message to a moderator

Re: RMAN Backup failed. [message #489271 is a reply to message #489241] Fri, 14 January 2011 03:45 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
your rman output shows foll 

ORA-19804: cannot reclaim 52428800 bytes disk space from 5368709120 limit



as michel instructed you should opt for one of the options:

Quote:
See you set the max size, if you want more (and have it) then increase the value

If you can't increase the value then remove some contents defining an appropriate RMAN policy and execute "delete obsolete".

Report message to a moderator

Re: RMAN Backup failed. [message #489272 is a reply to message #489270] Fri, 14 January 2011 03:45 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
enclose text in

"[ code]" and "[ /code]" tags

Regards
OraKaran

Report message to a moderator

Re: RMAN Backup failed. [message #489274 is a reply to message #489271] Fri, 14 January 2011 04:01 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
Hi All,

Thanks everyone for your efforts, my last simple questions is there minimum value for the parameter "db_recovery_file_dest_size" and Can I set this parameter with no value or null so that It can take all the disk space availble on my disk as default value.


Regards
Deepak

Report message to a moderator

Re: RMAN Backup failed. [message #489277 is a reply to message #489274] Fri, 14 January 2011 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is not a minimal but a maximal one.
You can set it to the size of your disk (or even greater) but take care that now Oracle will not be able to appropriately check the space and can then fails because of "no more space left on disk".
This parameter is there to protect you not to constrain you.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #489278 is a reply to message #489277] Fri, 14 January 2011 04:11 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
you can check at http://www.orafaq.com/parms/parm369.htm

in particular,the "related error messages" at bottom

Report message to a moderator

Re: RMAN Backup failed. [message #584598 is a reply to message #489241] Thu, 16 May 2013 00:39 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi

Even I have faced the same issue. Below are the error details. We are working in oracle 11.2.0.2.0


ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 27: File too large
Additional information: -1
Additional information: 1048576

SYS> select SPACE_USED,SPACE_LIMIT/1024/1024/1024 from v$recovery_file_dest;

SPACE_USED SPACE_LIMIT/1024/1024/1024
---------- --------------------------
5323973120                        100


Please suggest.

Report message to a moderator

Re: RMAN Backup failed. [message #584601 is a reply to message #584598] Thu, 16 May 2013 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The problem is not the space in the FRA but the size of a single file that exceeds the OS limit.
First check you have no limit in your OS profile: "ulimit -a".

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #584602 is a reply to message #489241] Thu, 16 May 2013 02:02 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hello

Below is the result of ulimit -a 
$ ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user)  unlimited

Command that I have executed in RMAN prompt (to take the backup of datafile 5 which is of size 10GB) is:
backup as compressed backupset datafile 5;

Can you also please confirm that will RMAN use the TEMP tablespace to perform its activities? Please suggest.

Report message to a moderator

Re: RMAN Backup failed. [message #584606 is a reply to message #584602] Thu, 16 May 2013 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Can you also please confirm that will RMAN use the TEMP tablespace to perform its activities?


No it does not.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #584607 is a reply to message #489241] Thu, 16 May 2013 03:08 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hope the result of "ulimit -a" is also fine.
Error Details: 
RMAN> backup as compressed backupset tablespace prod;

Starting backup at 16-MAY-13
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=126 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00032 name=/home/oracle/prod05.dbf
input datafile file number=00027 name=/home/oracle/prod01.dbf
input datafile file number=00028 name=/home/oracle/prod02.dbf
input datafile file number=00029 name=/home/oracle/prod03.dbf
input datafile file number=00030 name=/home/oracle/prod04.dbf
channel ORA_DISK_1: starting piece 1 at 16-MAY-13

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/16/2013 13:30:11
ORA-19502: write error on file "/home/oracle/list_db_bkp/list_archive/PROD/backupset/2013_05_16/o1_mf_nnndf_TAG20130516T132136_8sbbotkn_.bkp", block number 262145 (block size=8192)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 27: File too large
Additional information: -1
Additional information: 1048576

Report message to a moderator

Re: RMAN Backup failed. [message #584608 is a reply to message #584607] Thu, 16 May 2013 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is your OS?
Note that you may have a hard limit (by default ulimit shows the soft limits which are at most equal to the hard limits).
Check "ulimit -Ha"
If "file size" is still "unlimited" then you encountered the OS limit.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #584609 is a reply to message #584608] Thu, 16 May 2013 03:22 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
We are working with "AIX 6.1" in UNIX environment.
Getting the same result with ulimit -Ha also. Any check has to be done from OS level? 
ulimit -Ha
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user)  unlimited

Report message to a moderator

Re: RMAN Backup failed. [message #584612 is a reply to message #584609] Thu, 16 May 2013 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use MAXPIECESIZE option on ALLOCATE CHANNEL command in your RMAN backup script to limit the size of each backup file.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #584625 is a reply to message #584612] Thu, 16 May 2013 07:02 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Thank you Michel. We are able to proceed with rman backup, after setting the MAXPIECESIZE option.

Report message to a moderator

Re: RMAN Backup failed. [message #584627 is a reply to message #584625] Thu, 16 May 2013 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #585509 is a reply to message #584627] Mon, 27 May 2013 02:53 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
How do I resolve this error... Please help me...


Recovery Manager: Release 10.2.0.1.0 - Production on Mon May 27 11:35:07 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2380M/5939M, Ph+PgF:7049M/11877M, VA:1973M/2047M
Starting with debugging turned off

connected to target database: xe (not mounted)

RMAN> set echo on;
2> restore (spfile from autobackup db_recovery_file_dest='C:\oraclexe\app\oracle\flash recovery');
3> startup nomount force;
4> restore (controlfile from autobackup);
5> alter database mount;
6> configure controlfile autobackup off;
7> restore database;
8>
echo set on

Starting restore at 27-MAY-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK

recovery area destination: C:\oraclexe\app\oracle\flash recovery
database name (or database unique name) used for search: XE
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: C:\ORACLEXE\APP\ORACLE\FLASH RECOVERY\XE\AUTOBACKUP\2013_05_02\O1_MF_S_814355177_8R3ZTYSJ_.BKP
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 27-MAY-13

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 05/27/2013 11:35:20
RMAN-04014: startup failed: ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.

Recovery Manager complete.

Regards,

Shayi

Report message to a moderator

Re: RMAN Backup failed. [message #585524 is a reply to message #585509] Mon, 27 May 2013 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
ORA-01261: Parameter %s destination string cannot be translated
 *Cause: The value for the specified parameter contained a destination
         string that could not be translated.
 *Action: Use a valid destination string in the specified parameter.

The directory must exist and be accessible in read and write mode from the oracle account.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #585535 is a reply to message #585524] Mon, 27 May 2013 05:18 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
Thanks Michel but I my flash_recovery_area folder name was flash recovery so I have just changed the name back to flash_recovery_area and tried restore. Now its restoring...

Thanks again...

Report message to a moderator

Re: RMAN Backup failed. [message #585536 is a reply to message #585535] Mon, 27 May 2013 05:20 Go to previous messageGo to next message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
Michel,

I need your support to resolve another issue which is,
I have tried RMAN backup and it got failed due to drive space issue. After that my database is not working.
How do I rectify the same.

Backup up log:

Recovery Manager: Release 10.2.0.1.0 - Production on Tue May 21 09:58:19 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:781M/1527M, Ph+PgF:2982M/4425M, VA:2002M/2047M
Starting with debugging turned off

connected to target database: XE (DBID=2684498378, not open)

RMAN> set echo on;
2> shutdown immediate;
3> startup mount;
4> configure controlfile autobackup format for device type disk clear;
5> configure retention policy to redundancy 2;
6> configure controlfile autobackup on;
7> sql "create pfile=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile";
8> backup as backupset device type disk database;
9> configure controlfile autobackup off;
10> alter database open;
11> delete noprompt obsolete;
12>
echo set on

using target database control file instead of recovery catalog
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 805306368 bytes

Fixed Size 1289996 bytes
Variable Size 243269876 bytes
Database Buffers 557842432 bytes
Redo Buffers 2904064 bytes

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=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile

Starting backup at 21-MAY-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=35 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=C:\ORACLEXE\ORADATA\XE\INDX.DBF
input datafile fno=00005 name=C:\ORACLEXE\ORADATA\XE\EXPDB.DBF
input datafile fno=00003 name=C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
input datafile fno=00002 name=C:\ORACLEXE\ORADATA\XE\UNDO.DBF
input datafile fno=00001 name=C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
input datafile fno=00007 name=C:\ORACLEXE\ORADATA\XE\EXPBLOBS.DBF
input datafile fno=00004 name=C:\ORACLEXE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 21-MAY-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/21/2013 10:07:05
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.X$DBMS_BACKUP_RESTORE", line 1080
RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.

Report message to a moderator

Re: RMAN Backup failed. [message #585545 is a reply to message #585536] Mon, 27 May 2013 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You have another topic on this issue.
Please do not multiply the topics on the same issue and do not mix up the questions in the same topic.

Regards
Michel

Report message to a moderator

Re: RMAN Backup failed. [message #585546 is a reply to message #585545] Mon, 27 May 2013 06:14 Go to previous message
shaheemm
Messages: 10
Registered: May 2013
Junior Member
I am sorry for the same. I will delete the same from here... Once again sorry for that.

Report message to a moderator

Previous Topic: Database not working after backup got failed.
Next Topic: RMAN backup successfully?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 14:29:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.