You can *attempt* this ***COMPLETELY UNSUPPORTED*** trick on another server (I have no idea if it'll work):

1) restore datafiles from the "hot" backup, init.ora

2) edit init.ora adding following 2 parameters:
_allow_resetlogs_corruption = true
_corrupted_rollback_segments =(<<list your rollback segments here, i.e. RBS0, RBS1, RBS2, RBS3, etc >>)

3) backup controlfile to trace resetlogs on source DB

4) startup nomount;

5) create controlfile (using the trace file/script generated in step 3)

6) recover database using backup controlfile until cancel;

7) cancel

8) alter database open resetlogs;

Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Ungaro Matt [mailto:oracledba-ezmlmshield-x21579806.[Email address protected]
Sent: Mon 8/6/2007 16:25
To: LazyDBA Discussion
Subject: Recover Hotbackup of database not in archivelog mode.



I have a hotbackup of a database that I need to recover. The database was not
in archivelog mode, and I need to recover a backup copy from 8/1. It's now
8/6, so redo logs will not be an option. Forgive my lack of specificity, I'm
rather new to this, and am in a sticky situation. Any information that is
required to help with this, please ask and I will provide. Thanks in advance
for any assistance that can be provided.

Matt


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page