rman-backup-space

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

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

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

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

Your suggestions were excellant and helpful..

Thank You..solved the issue

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.