OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-19815 (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-19815 [message #428134]

Tue, 27 October 2009 05:55

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

Report message to a moderator

Re: ORA-19815 [message #428137 is a reply to message #428134]

Tue, 27 October 2009 06:03

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: ORA-19815 [message #428139 is a reply to message #428134]

Tue, 27 October 2009 06:07

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)

Report message to a moderator

Re: ORA-19815 [message #428402 is a reply to message #428134]

Wed, 28 October 2009 04:12

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

Report message to a moderator

Re: ORA-19815 [message #428500 is a reply to message #428402]

Wed, 28 October 2009 09:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post output from

df -k

Report message to a moderator

Re: ORA-19815 [message #428508 is a reply to message #428134]

Wed, 28 October 2009 09:54

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

Report message to a moderator

Re: ORA-19815 [message #428979 is a reply to message #428134]

Sat, 31 October 2009 06:39

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

Report message to a moderator

Previous Topic:	cannot recompile package after a hang up compilation (merged)
Next Topic:	Oracle server time problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 01:10:32 CDT 2024