Home » RDBMS Server » Server Administration » ORA-19815 (oracle 10g)
ORA-19815 [message #428134] Tue, 27 October 2009 05:55 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

Errors in file /oddump/bdump/prod_arc1_16136.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 644245094400 bytes is 100.00% used, and has 0 remaining bytes available

I am not using RMAN utillity and not have rman schema also.

Can anybody tell how to approach for it.

Thanks
Re: ORA-19815 [message #428137 is a reply to message #428134] Tue, 27 October 2009 06:03 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Then that would leave you with option 1)

oracle ~ $ oerr ORA 19815
19815, 00000, "WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available."
// *Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
// *Action: One of the following:
//          1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          2. Backup files to tertiary device using RMAN.
//          3. Consider changing RMAN retention policy.
//          4. Consider changing RMAN archivelog deletion policy.
//          5. Delete files from recovery area using RMAN.
oracle ~ $



But you should have a look first what it is that is filling up the disk.
Re: ORA-19815 [message #428139 is a reply to message #428134] Tue, 27 October 2009 06:07 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Run

show parameter db_recovery_file_dest

Go to that directory and free it (from archived redo log files)
Re: ORA-19815 [message #428402 is a reply to message #428134] Wed, 28 October 2009 04:12 Go to previous messageGo to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi

"show parameter db_recovery_file_dest
Go to that directory and free it (from archived redo log files)"

I have check the directory and there is lots of free space available.

Also, other solution is that i can delete expired from rman
But now i m not able to enter in rman prompt.

I went to ?/oracle_home/bin
here i fired : rman

Not able to connect

I also tried for : rman target /

not getting any errors just its in hang state.

i also fired ls -lrth rman* in ?/oracle_home/bin/ location

$ls -rlth rman*
-rwxr-xr-x 1 oracle dba 11M Sep 20 2008 rmanO
-rwxrwxr-x 1 oracle dba 11M Sep 20 2008 rman
-rwxrwxr-x 1 oracle dba 0 Oct 28 14:20 rmanO_bkp


previously rmanO was showing 0 then i copied this file from test server.

sTill not able to connect through rman.


Thanks in advance

Re: ORA-19815 [message #428500 is a reply to message #428402] Wed, 28 October 2009 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
post output from

df -k

Re: ORA-19815 [message #428508 is a reply to message #428134] Wed, 28 October 2009 09:54 Go to previous messageGo to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,
Below is the output:

oracle@sslodbl:/odapps/proddb/10.2.0/db_1/bin>$df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda5 49375272 24001012 22866116 52% /
/dev/sda1 396623 16084 360058 5% /boot
/dev/sda3 8262068 54196 7788176 1% /tmp
10.1.1.75:/oddata 170375040 129654592 40720448 77% /oddata
10.1.1.75:/oracle/odapps
113583360 93767168 19816192 83% /odapps
10.1.1.75:/oracle/odload
113583360 93767168 19816192 83% /odload
10.1.1.75:/oracle/odcntl
113583360 93767168 19816192 83% /odcntl
10.1.1.75:/oracle/oddump
113583360 93767168 19816192 83% /oddump
10.1.1.75:/odarch 72280320 22184160 50096160 31% /odarch
10.1.1.75:/odback 268469760 222711136 45758624 83% /odback
oracle@sslodbl:/odapps/proddb/10.2.0/db_1/bin>$


Thanks
Re: ORA-19815 [message #428979 is a reply to message #428134] Sat, 31 October 2009 06:39 Go to previous message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

I ran as:
sh rman
and able to login in the RMAN prompt.
Then i crosscheck archivelog all;
list expired archivelog all;
delete expired archivelog all;

Now not able to get that errors.

Thanks all of you for giving yours feedback.

Thanks once again
Previous Topic: cannot recompile package after a hang up compilation (merged)
Next Topic: Oracle server time problem
Goto Forum:
  


Current Time: Sun Sep 25 21:30:35 CDT 2016

Total time taken to generate the page: 0.09160 seconds