• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

rman-backup-space

backup database plus archive log;

RMAN:failure of backup plus archivelog command at 04/29/2011 10:51:13
ORA:19809  limit exceeded for recovery files
ORA:19804 cannot reclaim 1451509248 bytes disk space from 2147483648
-----------
I modified the parameter from
db_recovery_file_dest_size=2147483648
to
db_recovery_file_dest_size=3147483648
eventhough I changed
again when I did backup database plus archive log;

exactly the same error message is showing..

could you please let me know the reason ..

this scenario is different..
0
nobleit
Asked:
nobleit
  • 3
  • 2
  • 2
1 Solution
 
ThommyCommented:
Check the possible solutions...

http://ora-19804.ora-code.com/


You either have to add disk space or make your flash recovery area larger, if you already have enough disk space.

http://www.shutdownabort.com/errors/ORA-19809.php


Consider to delete old archive logs...

0
 
nobleitAuthor Commented:
I was trying to do some modification..
SQL> select      name
  2  ,      floor(space_limit / 1024 / 1024) "Size MB"
  3  ,      ceil(space_used  / 1024 / 1024) "Used MB"
  4  from      v$recovery_file_dest
  5  order by name
  6  ;

NAME                                                            Size MB    Used MB                  
------------------------------------------------------------ ---------- ----------                  
C:\app\Mathew\flash_recovery_area                                  2048       1387                  

SQL> alter system set db_recovery_file_dest_size=3000 scope=both;

System altered.

SQL> set lines 100
SQL> col name format a60
SQL> select      name
  2  ,      floor(space_limit / 1024 / 1024) "Size MB"
  3  ,      ceil(space_used  / 1024 / 1024) "Used MB"
  4  from      v$recovery_file_dest
  5  order by name
  6  ;

NAME                                                            Size MB    Used MB                  
------------------------------------------------------------ ---------- ----------                  
C:\app\Mathew\flash_recovery_area                                     0       1387                  

SQL> alter system set db_recovery_file_dest_size=2500 scope=both;

System altered.

SQL> set lines 100
SQL> col name format a60
SQL> select      name
  2  ,      floor(space_limit / 1024 / 1024) "Size MB"
  3  ,      ceil(space_used  / 1024 / 1024) "Used MB"
  4  from      v$recovery_file_dest
  5  order by name
  6  ;

NAME                                                            Size MB    Used MB                  
------------------------------------------------------------ ---------- ----------                  
C:\app\Mathew\flash_recovery_area                                     0       1387                  


I tried with different space

none of them working...

cannot reclaim 1457701376 bytes disk from 900483648 limit is the last one...
0
 
nobleitAuthor Commented:
also I am stucked with this
rman target / catalog user/pass@rmancat

rman target / catalog "may I know which user"/"what is this"@"what is this"
I know the database password
is there any way to get rman password and catalog when I created....

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
ThommyCommented:
This former EE question explains RMAN login syntax...

http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_22090410.html
0
 
slightwv (䄆 Netminder) Commented:
>>rman target / catalog "may I know which user"/"what is this"@"what is this"

/ is the same here as in sqlplus:  SYS

@rmancat tells Oracle to connect to the database rmancat in the tnsnames.ora file.

From the rman prompt try the following:
report obsolete;

If this returns information RMAN considers them no longer necessary to recover.  You can then delete them.
0
 
nobleitAuthor Commented:
Your suggestions were excellant and helpful..

Thank You..solved the issue
0
 
slightwv (䄆 Netminder) Commented:
nobliet,

Please explain how the link in the post you accepted solved the space issue?

You seem to just accept random posts.

I have asked you in several questions to explain the selection and you never respond.  I really don't want to involve a Moderator but if you continue to ignore my requests, I will.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now