Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

backup-rman-error

Posted on 2011-03-24
11
Medium Priority
?
554 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35209254
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
ID: 35209521
db_recovery_file_dest_size is currently  1073741824

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

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35209897
>>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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:nobleit
ID: 35210114
please tell me disk space you mean is c: drive

0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35210395
>>please tell me disk space you mean

The disk/drive pointed to by the db_recovery_file_dest parameter.
0
 

Author Comment

by:nobleit
ID: 35212184
'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 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35212285
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
ID: 35244093
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 78

Expert Comment

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

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

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35244241
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
ID: 35244383
Sir,

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

my table is there..
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

963 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