Home » RDBMS Server » Backup & Recovery » message in alert.log (10G windows 2003)
message in alert.log [message #431468] Tue, 17 November 2009 08:29 Go to next message
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 1432 times)
Re: message in alert.log [message #431469 is a reply to message #431468] Tue, 17 November 2009 08:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
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 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Sorry Michel,

You're right. Excuse me guys.
Re: message in alert.log [message #431489 is a reply to message #431468] Tue, 17 November 2009 11:37 Go to previous messageGo to next message
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
Re: message in alert.log [message #431493 is a reply to message #431489] Tue, 17 November 2009 12:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
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
Re: message in alert.log [message #431552 is a reply to message #431468] Wed, 18 November 2009 01:48 Go to previous messageGo to next message
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
Re: message in alert.log [message #431553 is a reply to message #431552] Wed, 18 November 2009 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
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
Re: message in alert.log [message #431683 is a reply to message #431468] Thu, 19 November 2009 02:12 Go to previous messageGo to next message
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.
Re: message in alert.log [message #431702 is a reply to message #431683] Thu, 19 November 2009 03:35 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just read my location.

Regards
Michel
Previous Topic: Oracle 9.2.0.4.0 on Windows
Next Topic: Recover db manually
Goto Forum:
  


Current Time: Sun Dec 22 17:59:56 CST 2024