Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

backup-rman-error

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
nobleit
Asked:
nobleit
  • 6
  • 5
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
nobleitAuthor Commented:
db_recovery_file_dest_size is currently  1073741824

how much can I increase...?
0
 
slightwv (䄆 Netminder) Commented:
>>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
Technology Partners: 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!

 
nobleitAuthor Commented:
please tell me disk space you mean is c: drive

0
 
slightwv (䄆 Netminder) Commented:
>>please tell me disk space you mean

The disk/drive pointed to by the db_recovery_file_dest parameter.
0
 
nobleitAuthor Commented:
'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
 
slightwv (䄆 Netminder) Commented:
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
 
nobleitAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>could you please help me to recover..

Yes but that is a different question and needs to be asked as such.
0
 
slightwv (䄆 Netminder) Commented:
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
 
nobleitAuthor Commented:
Sir,

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

my table is there..
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now