| Database Problem [message #57167] |
Sat, 24 May 2003 00:38  |
K Suresh Babu
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
We have encountered a problem for our oracle database
,one of our redolog files was corrupted and until now
I tesed many many ways for openning database but I was
not successful and the database is in mount mode.
could you please lead me and suggest an new way??
an important note is we do not have any backup for our
redo files.
|
|
|
|
| Re: Database Problem [message #57171 is a reply to message #57167] |
Sat, 24 May 2003 15:59  |
Viji Murthy
Messages: 2
Registered: May 2003
|
Junior Member |
|
|
You cannot use a current controlfile and current datafiles to do incomplete recovery. If you are missing your online logs then your recovery is going to be incomplete. Your option is to verify all files have the same checkpoint_change# before begining recovery.
SQL> select file#, checkpoint_change# from v$datafile;
If they are all the same then use recover until cancel.
SQL> recover until cancel using backup controlfile;
cancel
SQL> alter database open resetlogs;
Make sure the directories for the redologs exits before resetlogs and they will be generated by the database automatically at open.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
