| naivedya |
Posted: Nov 20, 2003 05:56:04 AM |
Total Post: 14
Joined: Jan, 2003
|
If Database is in Non-Archive mode and no Backup (DMP files)is available & Redolog files are lost, how do one get DB back ??
The following INIT.ora parameter may be required if your current redologs are corrupted or blown away.
_allow_resetlogs_corruption = true
PLEASE CONTACT ORACLE SUPPORT BEFORE USING IT. |
|
|
 vasu |
| Posted: Nov 25, 2003 09:59:50 AM |  |
|
Total Post: 50
Joined: Jan, 2003
|
It won’t be possible to restore database with out some kind of backup. IF only redolog files are lost then try to open database with resetlog.
Let me know how it goes.
Good Luck
Vasu
|
|
|
|
|
| naivedya |
| Posted: Nov 25, 2003 10:58:04 PM | |
|
Total Post: 14
Joined: Jan, 2003
|
Dear Vasu,
Database came to MOUNT stage but did not open & asked for Media Recovery, what do u suggest ?? RESETLOGS did not work, as I tried to OPEN the database, it gave me the above error.
This help I got was from internet only, but it worked.
At what Stage & command will u give for this ??, since without Opening I could not get the Export.
rgds
Naivedya
|
|
|
|
|
| Puneet |
| Posted: Nov 26, 2003 02:10:51 PM | |
|
Total Post: 73
Joined: Mar, 2002
|
Database will not be open until the scn of redo log files matches with the scn of control file. I think you can try 'recover database using backup controlfile;' command. It will ask for the redo log and you can use AUTO option if you don't have redo logs file.
You may create new control file also but check with Oracle support before doing any thing if you are on production.
Regards,
Puneet
|
|
|
|
|
| helen |
| Posted: Jan 13, 2004 08:25:40 PM | |
|
Total Post: 4
Joined: Jan, 2004
|
are you lost all online redolog files?
1.if you lost current redolog files you will data in lost current redolog file ,you can make resetlogs to keep database scn consist.
2.if you lost redolog files what is a number in a group,you can mount database ,make this number is offline from this group.
good lucky!
helen
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
