Re: Recovery: Nightmare Scenario

if you have the backed up controlfile you should be able to restore your database.
first please make a copy of all your datafiles,redo logs, init extra before you attempt
to do this
and i am assuming a few things so please make a cold backup of all datafiles and redo logs init etc .....NOW now before you continue

PLEASE READ THIS IN FULL BEFORE DOING ANYTHING first open up the backed up trace controlfile file delete everything on the top up to ]
# the following commands ....<<statement>> or send me your backed up controlfile
you should have a line that states
startup nomount
create controlfile REUSE database <<dbname>> noresetlogs archivelog maxlogfiles
.
.
.

maxloghistory
logfile
<< group information>>
datafile
<<datafile information...make sure all your datafiles are listed and are in the

correct location>>
RECOVER DATABASE
ALTER SYSTEM ARCHIVE LOG ALL
ALTER DATABASE OPEN you should log into svrmgrl
connect internal
then run this scrip
@script name<<path name maybe needed depending on where this file is located>>

if all your datafiles are intact this will create new controlfile for you and open up your database...
PLEASE then SHUTDOWN IMMEDIATE you database and MAKE A FULL COLDBACKUP then if you can get your database in archivelog mode

not sure what version your running or on what os but this should work AND AS STATED EARLIER MAKE A BACKUP OF ALL YOUR DATAFILES REDO LOGS INIT ETC>> Received on Tue Sep 12 2000 - 10:26:17 CDT