Re: DB Restore

"mwallace" <noway_at_mycomp.oth.org> wrote in message news:<Ycms7.3$Lc1.3374_at_news.lhr.globix.net>...
> Need help with a restore please.
> According to our networks department, the backup software on the server
> would have no problem backing up the database on the server. Server went
> down. Restored from backup and what do you know, no control files...
> So besides me being stupid not to check etc, etc... I need help to
> recover...
>
> Recreated control files with the
> {create controlfile} command
> this seemed to work ok.
>
> Now can't get the database to open.
> tried the following
> startup pfile=... open recover
> and recieve error
> ORA-01610: recovery using the BACKUP CONTROLFILE option must be used
>
> tried
> RECOVER DATABASE USING BACKUP CONTROLFILE
> and then it is looking for files ...\RDBMS\ARC66567.001 to apply against the
> database.
> which we don't have so it fails again...
>
> I don't care about any app data, I just need to get pl/sql code, and table
> layouts etc out of the DB.
> This information has been static for at least two weeks before the DB went
> down. So it is definitly saved and not sitting in a redo log or anything.
>
> I basically need to force the database to open. I don't care about applying
> redo-logs, etc,etc ...
>
> Please Help....
> Thanks
> Mark

Hi Mark,

If you dont care about data integrity or any other checks or doing it the supported way, you can use this parameter in the init.ora file and startup the database normally (no need for the resetlogs option).

_allow_resetlogs_corruption=true

The database will not ask for any archive logs, but will open in an in-consistent state. Whether you'll actually get everything that you want, I dont know. You'll have to rebuild your database from scratch, of course. Dont forget to test your backups.

Murali Received on Wed Sep 26 2001 - 21:00:16 CDT