| Recovering Database [message #167792] |
Mon, 17 April 2006 02:35  |
raakeshverma
Messages: 1
Registered: April 2006
|
Junior Member |
|
|
If situation occurs regarding oracle database 8i/9i that database is running and unfortunately control file and online redo log file are being deleted.At this situation how can i get know about this problem and how can i recover database.
(In both the cases we don't have multiplexes control file or redo log file)
|
|
|
|
| Re: Recovering Database [message #167890 is a reply to message #167792] |
Mon, 17 April 2006 14:19  |
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
|
Member |
|
|
>> how can i get know about this problem
database will crash
>> how can i recover database.
do you have any archives available plus backup control file ?
|
|
|
|
| Re: Recovering Database [message #169262 is a reply to message #167792] |
Tue, 25 April 2006 23:54 |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
If backup is exists, following the recovery processes to recover your db.
If there is no backup, try to recreate controlfile using commandd "CREATE CONTROLFILE REUSE DATABASE..." to recreate the controlfile and then open the database. If it is failed, I guess the only thing to do is contact oracle customer representation.
Alex zeng |Skype me: hans9zeng
|
|
|
|
| Re: Recovering Database [message #169895 is a reply to message #167792] |
Sun, 30 April 2006 03:27 |
lakher
Messages: 14
Registered: April 2006
|
Junior Member |
|
|
if you have database backup，you can recreate controlfile，mount the database and recover database using backup controlfile until cancel。then resetlogs open database，but lose some data。
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
