Posted on 2011-03-24
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

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.
Question by:nobleit
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 500 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.

Author Comment

ID: 35209521
db_recovery_file_dest_size is currently  1073741824

how much can I increase...?
LVL 77

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.
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.


Author Comment

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

LVL 77

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.

Author Comment

ID: 35212184

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..
LVL 77

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.

Author Comment

ID: 35244093
Expert SlightWv before I accept you I have a question..
 I increased db_recovery_file_dest_size;

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
LVL 77

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.
LVL 77

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.

Author Comment

ID: 35244383

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

my table is there..

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database Design Dilemma 6 71
why truncate is faster than delete in oracle ? 4 71
how to tune the query 17 87
Dbms_job.change procedure 16 37
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

751 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