OraFAQ Forum: Backup & Recovery » message in alert.log

Home » RDBMS Server » Backup & Recovery » message in alert.log (10G windows 2003)

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

message in alert.log [message #431468]

Tue, 17 November 2009 08:29

mamingui
Messages: 83
Registered: July 2006

Member

Hi All,

I'm working with oracle 10G in windows 2003 server. This morning I checked my alert.log and I saw this message :

"Wed Nov 04 21:54:42 2009
db_recovery_file_dest_size of 952861 MB is 0.17% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Nov 05 03:14:10 2009
Thread 1 advanced to log sequence 792
Current log# 1 seq# 792 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 792 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Thu Nov 05 10:25:51 2009
Thread 1 advanced to log sequence 793
Current log# 2 seq# 793 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 793 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Fri Nov 06 00:41:01 2009
Thread 1 advanced to log sequence 794
Current log# 1 seq# 794 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 794 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Fri Nov 06 19:00:15 2009
Thread 1 advanced to log sequence 795
Current log# 2 seq# 795 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 795 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Sat Nov 07 04:59:14 2009
Thread 1 advanced to log sequence 796
Current log# 1 seq# 796 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 796 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Sat Nov 07 22:18:18 2009
Thread 1 advanced to log sequence 797
Current log# 2 seq# 797 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 797 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Sun Nov 08 20:00:25 2009
Thread 1 advanced to log sequence 798
Current log# 1 seq# 798 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 798 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Mon Nov 09 20:40:05 2009
Thread 1 advanced to log sequence 799
Current log# 2 seq# 799 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 799 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Tue Nov 10 12:01:40 2009
Thread 1 advanced to log sequence 800
Current log# 1 seq# 800 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 800 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Wed Nov 11 04:00:28 2009
Thread 1 advanced to log sequence 801
Current log# 2 seq# 801 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 801 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Wed Nov 11 22:00:38 2009
Thread 1 advanced to log sequence 802
Current log# 1 seq# 802 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 802 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Thu Nov 12 21:00:34 2009
Thread 1 advanced to log sequence 803
Current log# 2 seq# 803 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 803 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Fri Nov 13 13:29:32 2009
Thread 1 advanced to log sequence 804
Current log# 1 seq# 804 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 804 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Sat Nov 14 05:31:33 2009
Thread 1 advanced to log sequence 805
Current log# 2 seq# 805 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 805 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Sat Nov 14 23:00:39 2009
Thread 1 advanced to log sequence 806
Current log# 1 seq# 806 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 806 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
Mon Nov 16 00:00:48 2009
Thread 1 advanced to log sequence 807
Current log# 2 seq# 807 mem# 0: +DATA/mvdbcg/onlinelog/group_2.262.698005981
Current log# 2 seq# 807 mem# 1: +FLASH/mvdbcg/onlinelog/group_2.258.698005983
Mon Nov 16 22:00:16 2009
Thread 1 advanced to log sequence 808
Current log# 1 seq# 808 mem# 0: +DATA/mvdbcg/onlinelog/group_1.261.698005981
Current log# 1 seq# 808 mem# 1: +FLASH/mvdbcg/onlinelog/group_1.257.698005981
"
What is the problem with db_recovery_file_dest_size ?
Could I have problem about this ?

Regards

Attachment: alert.log
(Size: 4.04KB, Downloaded 1559 times)

Report message to a moderator

Re: message in alert.log [message #431469 is a reply to message #431468]

Tue, 17 November 2009 08:33

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just an information for you.
You don't need to post 100 lines when only 5 are useful.

Regards
Michel

[Updated on: Tue, 17 November 2009 08:34]

Report message to a moderator

Re: message in alert.log [message #431479 is a reply to message #431468]

Tue, 17 November 2009 10:08

mamingui
Messages: 83
Registered: July 2006

Member

Sorry Michel,

You're right. Excuse me guys.

Report message to a moderator

Re: message in alert.log [message #431489 is a reply to message #431468]

Tue, 17 November 2009 11:37

mamingui
Messages: 83
Registered: July 2006

Member

Ok,

So someone can explain me this :" Wed Nov 04 21:54:42 2009
db_recovery_file_dest_size of 952861 MB is 0.17% used. This is a
user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup"

Thanks

Report message to a moderator

Re: message in alert.log [message #431493 is a reply to message #431489]

Tue, 17 November 2009 12:19

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It says exactly what is written.
Explain what you don't understand.

Regards
Michel

Report message to a moderator

Re: message in alert.log [message #431552 is a reply to message #431468]

Wed, 18 November 2009 01:48

mamingui
Messages: 83
Registered: July 2006

Member

I just want to know If I have to increase size db_recovery_file_dest_size to avoid any issue.
Clearly, I want to know If this is a warning which can affect my database or not.

Regards

Report message to a moderator

Re: message in alert.log [message #431553 is a reply to message #431552]

Wed, 18 November 2009 01:59

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is NOT a warning, it is just an INFORMATION message.

Quote:

just want to know If I have to increase size db_recovery_file_dest_size to avoid any issue.

What does the message says? Just read it.

Regards
Michel

Report message to a moderator

Re: message in alert.log [message #431683 is a reply to message #431468]

Thu, 19 November 2009 02:12

mamingui
Messages: 83
Registered: July 2006

Member

Thank you Michel,

Excuse me but I want to know if you're french because you have a french name.

Thank again for your help.

Report message to a moderator

Re: message in alert.log [message #431702 is a reply to message #431683]

Thu, 19 November 2009 03:35

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just read my location.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 9.2.0.4.0 on Windows
Next Topic:	Recover db manually

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 17 18:16:52 CDT 2026