Home » RDBMS Server » Server Administration » BLOB are missing (ORACLE 11G R2 (11.2.0.1.0), ASM , SOLARIS 10, RAC of two Nodes)
BLOB are missing [message #548410] Thu, 22 March 2012 01:27 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
we have received an arror on 7 Mar 2012 which is is follows

ORA-1692 : unable to extend lobsegment schema1.Sys_LOB0000126620000004$$ Partition sys_Lob_p265 by 8192 in tablespace DIF-M12


the above error was reported in alert log at 1150 hrs and then a file was added by the local DBA at 1820 hrs i.e after 6 hours.

Now my query is that is there any relation of this error with the BLOB missing from database or if not so what harmful effect there may be on Database as datafile was added after 6 hours

secondly when i see the DF_M12 tablespace usage at EM so its total size is 86 Gb and used is 76Gb but when i see its datafiles so it shows a different story which is opposite to the reported used space i.e only one datafile is showing 25g and rest are not showing any space which means that something is missing so i doubt it is this may be the reason of missing blob or not


kindly comment and guide

Regards
Re: BLOB are missing [message #548414 is a reply to message #548410] Thu, 22 March 2012 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you receive this error the statement is aborted and rolled back and so did nothing.

Do not explain what you see, SHOW us: copy and paste what you do and get.

Regards
Michel

[Updated on: Thu, 22 March 2012 01:47]

Report message to a moderator

Re: BLOB are missing [message #548420 is a reply to message #548414] Thu, 22 March 2012 02:04 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
Hi,

Quote:
When you receive this error the statement is aborted and rolled back and so did nothing.


No, i do not receive such error

and secondly i do not perform any command but i will post the alert log and i will also post the screen shot of tablespace DIF_M12 which shows the datafile used space which is contradictiry to usage statistics shown on EM and on sql


Regards
Re: BLOB are missing [message #548427 is a reply to message #548420] Thu, 22 March 2012 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
No, i do not receive such error

Quote:
we have received an arror


Which one is true?

Quote:
and secondly i do not perform any command


You perform no command and Oracle returns you an error?

Regards
Michel
Re: BLOB are missing [message #548436 is a reply to message #548427] Thu, 22 March 2012 04:44 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
OP didn't get the error - they saw it in the alert log.
Someone else did something and got the error.
Re: BLOB are missing [message #548437 is a reply to message #548436] Thu, 22 March 2012 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh! This is a misunderstanding, thanks to clarify.
I meant "you" as anyone using the database and he understood it as himself.


Regards
Michel
Re: BLOB are missing [message #548747 is a reply to message #548437] Sun, 25 March 2012 14:16 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
well its not difficult to understand ? important things is suggestion and advice which is the sole purpose of my post not who did what and bla bla.

have you got any advice ??

Regards
Re: BLOB are missing [message #548748 is a reply to message #548747] Sun, 25 March 2012 16:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>tablespace DIF-M12
>DF_M12 tablespace
Is either above correct?

Is COPY & PASTE broken for you?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: is it a full checkpoint or incremental checkpoint?
Next Topic: Verify Rebuild index
Goto Forum:
  


Current Time: Fri Mar 29 00:37:39 CDT 2024