Re: Recovering from lost controlfile.

From: Mohamed Buhari <mbuhari_at_assigncorp.com>
Date: 27 Jan 2000 21:08:03 EST
Message-ID: <3890FA01.21D6A2DF@assigncorp.com>

>>>>>dbf files from yesterday.

dbf files from today.
redolog files from yesterday through the last successful shutdown. control file from today. <<<<<<<

1. If it is in archivelog mode : You need the following

>>>dbf files from yesterday<<<<
>>>control file from today is ok or backup controlfile taken using "alter
database backup controlfile command" <<<
>>>All archived logfiles ( not redologs ) since your yesterdays dbf file
backup<<<

If You meet this requirement, you can go for either complete recovery (only your current control & redologs are intact ) or cancel based recover ( If U lost your current controlfile and redo log groups ) or timebased recovery

2.If it is in noarchivelog mode :

The best solution is to restore your previous cold backups ( backup of all controlfiles,redologfiles and datafiles backup taken after a clean shutdown ).If U only have backup of redologs and datafilebackups , current controlfile cannot be used and you require only backup controlfile. If U dont have Backup controlfile. If U dont have a backup control file, atleast U must have a trace file ( created using "alter database backup controlfile to trace" ). If U dont have anything about controlfile, U must write down complete existing file

structure and use "Create controlfile reuse database ..................."

command to recreate your controlfile. Then go for cancel based recover.

refer documentation for exact syntax.

Mohamed
DBA You need

dmoose wrote:

> Recently the backup script for the oracle database had trouble backing up
> the controlfile.
>
> These are the parts I have:
>
> dbf files from yesterday.
> dbf files from today.
> redolog files from yesterday through the last successful shutdown.
> control file from today.
>
> When doing a media recovery the recovery routine is asking for a redolog
> from three days ago, even though I have a successful (minus the control
> file) backup from yesterday.
>
> Can I use yesterday's dbf files, today's control file and the redo files to
> get a point in time recovery?
>
> Can I force a database open to get an export?
>
> Are there other options?
>
> Please reply via newsgroup or mail (but pull the nospam- out of the return
> address.)
>
> Thanks
Received on Thu Jan 27 2000 - 20:08:03 CST