Home » RDBMS Server » Backup & Recovery » restart database
restart database [message #471957] Wed, 18 August 2010 01:04 Go to next message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
hi all,

i have add one more datafile to my undo tablespace and after that i shutdown the database and remove that datafile physical from os.create control file and remove the entry of that datafile and try to start but showin error ora-01173
now dont have that deleted file with me and i need to up the database .please help me out
Re: restart database [message #471966 is a reply to message #471957] Wed, 18 August 2010 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think we know all the error numbbers by heart?
ALWAYS put the complete error message.
ORA-01173: data dictionary indicates missing data file from system tablespace
 *Cause:  Either the database has been recovered to a point in time in the
    future of the control file or a datafile from the system tablespace was
    omitted from the create control file command previously issued.
 *Action: For the former problem you need to recover the database from a
    more recent control file.   For the latter problem, simply recreate the
    control file checking to be sure that you include all the datafiles in
    the system tablespace.


Most solutions depend on your Oracle version number, ALWAYS post it, with 4 decimals.
Most solutions to restore/recover depend on your backup strategy, ALWAYS post it.

Regards
Michel

[Updated on: Wed, 18 August 2010 01:29]

Report message to a moderator

Re: restart database [message #472091 is a reply to message #471966] Wed, 18 August 2010 13:36 Go to previous messageGo to next message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
sir ,
as clearly mention that i drop one undo datafile and i changed the control file according to that and recreated it in database . After that database ask media recovery for system tablespace .
i have done media recover with " RECOVER DATABASE " command
it show recovery completed .
but when i try to open the database , using
"ALTER DATABASE OPEN " , it get terminate .
Re: restart database [message #472092 is a reply to message #472091] Wed, 18 August 2010 13:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>"ALTER DATABASE OPEN " , it get terminate .
what clues exist within alert_SID.log file & possible trace file?
Re: restart database [message #472338 is a reply to message #472092] Fri, 20 August 2010 01:07 Go to previous messageGo to next message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
as u may come to knw that what i have done ,
actually i delete one datafile which is of undo tablespace at os level .
and start up the database ,but at startup it asking for that deleted file and remove that file from hard disk .so there is no chance to make it available .
i recreate the control file and remove the entry of these undo datafile and recreate controlfile . and able to start the database at mount mode .
then i enter "alter database open "
it asking for media recovery for system file and
i do "recover database it show me recovery completed "
then again i try to open the database in
"alter database open resetlogs ;"
it wait for some time and terminate forcefully.


please help me out or if you have any test env with u .please try it and please provide me solution .Sir i am great hope from u

thanks
Re: restart database [message #472343 is a reply to message #472338] Fri, 20 August 2010 01:23 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Most solutions depend on your Oracle version number, ALWAYS post it, with 4 decimals.
Most solutions to restore/recover depend on your backup strategy, ALWAYS post it.


And don't use IM speak like "u".

Regards
Michel
Previous Topic: Recovery of a Noncritical Data File in Archivelog Mode
Next Topic: Offline Datafile
Goto Forum:
  


Current Time: Thu Mar 28 05:39:59 CDT 2024