Solved

backup-rman-error

Posted on 2011-03-24
11
532 Views
Last Modified: 2012-05-11
my database name is company
i did like this
set oracle_sid=company
rman target /

connected to rman

rman>backup database plus archivelog;

it started backing up
but in the end it showed errors

RMAN-03009 FAILURE OF BACKUP COMMAND
ORA-19809  limit exceeded for recovery files
ora-19804 cannot reclaim 52428800  bytes disk space from 1073741824

could you please help me to figure out this issue

company database is in production and archivelog mode.
0
Comment
Question by:nobleit
  • 6
  • 5
11 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
RMAN can only use as much space as is specified by the spfile parameter: db_recovery_file_dest_size

Increase that parameter to a size large enough to handle the backups.
0
 

Author Comment

by:nobleit
Comment Utility
db_recovery_file_dest_size is currently  1073741824

how much can I increase...?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>how much can I increase...?

How much disk space do you have?  How much of that do you want Oracle backups to be able to use?

Answer those questions and you have your number.
0
 

Author Comment

by:nobleit
Comment Utility
please tell me disk space you mean is c: drive

0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>please tell me disk space you mean

The disk/drive pointed to by the db_recovery_file_dest parameter.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:nobleit
Comment Utility
'C:\app\Mathew\product\11.1.0\db_1\database'

This drive where the init.ora parameter resides have a free space of  '7.2 GB'

is there any way to figure out this space issue..
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
What space issue?

You need to increase db_recovery_file_dest_size large enough to hold the backup.  Just don't make it large enough to fill up the entire disk unless you want it to.
0
 

Author Comment

by:nobleit
Comment Utility
Expert SlightWv before I accept you I have a question..
 I increased db_recovery_file_dest_size;

now
rman>backup database plus archivelog;
is successfully backedup

after that my user dropped one of the table..

could you please help me to recover..
Thanks in advice
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>could you please help me to recover..

Yes but that is a different question and needs to be asked as such.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
If this is production: Quickly google: flashback table.  You might be able to use flashback to recreate the table.

or flashback query to maybe get the data.
If not production, please open a new question.
0
 

Author Comment

by:nobleit
Comment Utility
Sir,

Thanks a lot..
I tried this..
flashback table scott.taxable to before drop;

my table is there..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now