| restart database [message #471957] |
Wed, 18 August 2010 01:04  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 #472338 is a reply to message #472092] |
Fri, 20 August 2010 01:07 |
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 |
|
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
