Home » RDBMS Server » Server Administration » FRA space cross thresold limit (Oracle 11.2.0.4.0 , Linux 2.6)
FRA space cross thresold limit [message #621374] Tue, 12 August 2014 23:52 Go to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Hi,

I received below alert
Quote:
Disk group PR01_FRA has used 91.38% of safely usable free space

Please see my findings below.
SQL> SELECT Name, (SPACE_LIMIT/1024/1024/1024) Space_Limit_GB, SPACE_USED/1024/1024/1024 Space_Used_GB, SPACE_RECLAIMABLE, NUMBER_OF_FILES FROM V$RECOVERY_FILE_DEST;
NAME                           SPACE_LIMIT_GB SPACE_USED_GB SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------------ -------------- ------------- ----------------- ---------------
+PR01_FRA                                100    49.1435547                 0             581


SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP where name='NPSRR_FRA';

NAME                           TYPE     TOTAL_MB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
------------------------------ ------ ---------- ---------- ----------------------- --------------
PR01_FRA                      NORMAL     122838      18286                   20473          -1093

SQL>


It looks like FRA has enough free space in database.Unsure why i received this FRA alert.

Regards,
Re: FRA space cross thresold limit [message #621375 is a reply to message #621374] Tue, 12 August 2014 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 23137
Registered: January 2009
Senior Member
>Unsure why i received this FRA alert.
ask the responsible DBA why the alert was sent.
Re: FRA space cross thresold limit [message #621376 is a reply to message #621375] Tue, 12 August 2014 23:57 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
ask the responsible DBA why the alert was sent.

You are also a DBA right? why cant you answer this ?

[Updated on: Tue, 12 August 2014 23:58]

Report message to a moderator

Re: FRA space cross thresold limit [message #621377 is a reply to message #621376] Tue, 12 August 2014 23:59 Go to previous messageGo to next message
BlackSwan
Messages: 23137
Registered: January 2009
Senior Member
ora_2014 wrote on Tue, 12 August 2014 21:57
Quote:
ask the responsible DBA why the alert was sent.

You are also a DBA right? why cant you answer this ?

because I am not the one who coded the alert.


It is YOUR system & your database & we don't know what YOU have done on it.
Re: FRA space cross thresold limit [message #621378 is a reply to message #621377] Wed, 13 August 2014 00:05 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
>It is YOUR system & your database & we don't know what YOU have done on it.
ok you dont know how the alert triggered.But you the answer for it right ?
Re: FRA space cross thresold limit [message #621381 is a reply to message #621378] Wed, 13 August 2014 00:07 Go to previous messageGo to next message
BlackSwan
Messages: 23137
Registered: January 2009
Senior Member
ora_2014 wrote on Tue, 12 August 2014 22:05
>It is YOUR system & your database & we don't know what YOU have done on it.
ok you dont know how the alert triggered.But you the answer for it right ?

Ignore the alert since it is erroneous.
Re: FRA space cross thresold limit [message #621383 is a reply to message #621381] Wed, 13 August 2014 00:24 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Thanks Blackswan for your quick reply.

[Updated on: Wed, 13 August 2014 00:24]

Report message to a moderator

Re: FRA space cross thresold limit [message #621385 is a reply to message #621383] Wed, 13 August 2014 00:27 Go to previous messageGo to next message
BlackSwan
Messages: 23137
Registered: January 2009
Senior Member
unless it is real
Re: FRA space cross thresold limit [message #621387 is a reply to message #621385] Wed, 13 August 2014 00:37 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
<unless it is real
What do you mean by real here ?
Re: FRA space cross thresold limit [message #621388 is a reply to message #621387] Wed, 13 August 2014 00:40 Go to previous messageGo to next message
BlackSwan
Messages: 23137
Registered: January 2009
Senior Member
alert is legitimate.
Re: FRA space cross thresold limit [message #621391 is a reply to message #621388] Wed, 13 August 2014 00:46 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
<alert is legitimate
See what i posted all is true so far. If you still don't trust me, i cant do anything.
Re: FRA space cross thresold limit [message #621399 is a reply to message #621391] Wed, 13 August 2014 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 59981
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

We can't trust you as you don't know what you post.
We can't trust you as you already lied so many times.

Re: FRA space cross thresold limit [message #621401 is a reply to message #621399] Wed, 13 August 2014 01:47 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
<We can't trust you as you don't know what you post.
<We can't trust you as you already lied so many times.

Hey Michel,
Good morning sir!! I was waiting for you.

<We can't trust you as you don't know what you post.
Yes i know what i posted.Thats why Blackswan was able to answer my question.
<We can't trust you as you already lied so many times.
I already told you multiple times not to interfere in thread i open.But still you do the same.

Now please allow other gentlemans who are interest to answer my question.

[Updated on: Wed, 13 August 2014 01:50]

Report message to a moderator

Re: FRA space cross thresold limit [message #621402 is a reply to message #621401] Wed, 13 August 2014 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59981
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I forbid no one to answer your question.
You have no right to tell me what I can do with your question.

And, indeed, you don't know what you post, just read what your round trips with BlackSwan and try to understand it... if you can... but it seems you don't even understand what you post.

Re: FRA space cross thresold limit [message #621410 is a reply to message #621402] Wed, 13 August 2014 02:40 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
<I forbid no one to answer your question.

Indeed you have no rights on others to prevent to answer my question.
I dont need your suggestion at all.

Please leave my thread.
Re: FRA space cross thresold limit [message #621415 is a reply to message #621410] Wed, 13 August 2014 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59981
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Dumby Fraudy,

It is not YOUR thread and you have no right to tell someone to do or not do something.

Re: FRA space cross thresold limit [message #621423 is a reply to message #621415] Wed, 13 August 2014 04:40 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Michel,
Quote:
It is not YOUR thread and you have no right to tell someone to do or not do something.

I apologize for that.You have helped me a lot in many situations and database issues.I should not have talked like that.
I know are you the senior most person and have right to guide me.

I hope i can now post new questions and get answers to my questions in this forum Smile

Regards,

[Updated on: Wed, 13 August 2014 05:23]

Report message to a moderator

Re: FRA space cross thresold limit [message #626335 is a reply to message #621423] Sun, 26 October 2014 09:36 Go to previous message
madhusmita.chakraborty
Messages: 2
Registered: January 2014
Location: Bangaluru
Junior Member

Check if a maintainace script is running for the database (Maintainance Script : deletes all the archives which already have been backed up),
Sometimes this script is responsible for automatically clearing your FRA area.
Previous Topic: How to set password login / as sysdba sqlplus on database oracle 11g
Next Topic: Rollback Session
Goto Forum:
  


Current Time: Thu Dec 18 09:33:55 CST 2014

Total time taken to generate the page: 0.09625 seconds