OraFAQ Forum: Backup & Recovery » Database got shutdown due to shortest storage in OS

Home » RDBMS Server » Backup & Recovery » Database got shutdown due to shortest storage in OS (db10g)

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

Database got shutdown due to shortest storage in OS [message #423784]

Mon, 28 September 2009 04:05

sbldba
Messages: 4
Registered: September 2009
Location: Dhaka

Junior Member

Hi
we have got the error unable to extent the datafile due to shortage storage..to resolve the problem we have done the following step:

1. move the one data file size 27gb to another location
2. changed the control file according to new location
3. trying to open the database using alter database open.its through the error... recover needed for datfile pin19.dbf
4. after that we have execute the command like recover datafile pin19.dbf
then its through the error like "ORA-00280: change 545701132 for thread 1 is in sequence #65143

so we are not able to open the database as of now.. one more thing is: our database is "no archive log mode".

if someone can help regarding this issue then it would be highly appreciable

Report message to a moderator

Re: Database got shutdown due to shortest storage in OS [message #423793 is a reply to message #423784]

Mon, 28 September 2009 05:21

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

Senior Member
Account Moderator

ORA-00280: change %s for thread %s is in sequence #%s
 *Cause:  This message helps to locate the redo log file with the
          specified change number requested by other messages.
 *Action: Use the information provided in this message to specify the
          required archived redo log files for other errors.

You didn't say if you shut down or not the database before moving or during move and what kind of shutdown.
(Anyway, you did it wrong, there is no need to recreate the control file when you move a datafile.)

Regards
Michel

Report message to a moderator

Re: Database got shutdown due to shortest storage in OS [message #423835 is a reply to message #423793]

Mon, 28 September 2009 09:52

sbldba
Messages: 4
Registered: September 2009
Location: Dhaka

Junior Member

dear Michel
we have moved the datafile after shutdown the database. but problem is this is a production database so now if we do any wrong thing we will loose billion of data . so can you advice us what can we do to make the database up and running.

thanks
pappu

Report message to a moderator

Previous Topic:	IMP Error IMP-00058: ORACLE error 1034 encountered
Next Topic:	ORACLE data block corrupted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 17:21:23 CST 2024