| database not opened [message #70660] |
Thu, 11 July 2002 00:47  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
|
In oracle 8i. the database files/tablespace files created for the users were lost. it gives error message on svrmgrl startup function. the 'C:citizen.ora'file missing. What is the solution for recovery of other users database.
|
|
|
|
| Re: database not opened [message #70664 is a reply to message #70660] |
Thu, 11 July 2002 05:36  |
christopher
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
It depends.
Do you have a backup of the lost files?
Do you archived log files?
If the answer is yes to both,then
1) restore lost datafiles from backup
2) perform recovery
If the answer is no to either one, it depends how important everything else in the db is.
--if no archived logs, then you can restore everything to your last backup. This means all changes since that backup are lost.
--if you have no backup, offline drop of the datafile and everything in the datafile will be lost. then open the database and drop the tablespace.
|
|
|
|
| Re: database not opened [message #70774 is a reply to message #70660] |
Mon, 22 July 2002 03:31 |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
|
If you have the backup of all the datafile, controlfile and archivelog then only you can recover the database up to the time, on else you can recover the database (if you have offline backup) up to your last backup
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
