Re: Restoring Oracle Control Files

Thanx for your post Sybrand. I tried that however still no success.

The backup that i am trying to restore is a online backup taking using veritas backup exec 9.0. once i restore its puts all the files into the place except for the control file which is renamed as i mentioned in my previous post. So Shutdown the database, Do the Restore using veritas, and then Following you intructions i Copied the BECF<SID>.bak to 3 seperate files and renamed it CONTROL01.CTL CONTROL02.CTL and CONTROL03.CTL, Then I Use STARTUP MOUNT and then run the Recover database........cancel command after that i type cancel and then i the following

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oradata/epitest/system01.dbf'

however after getting those messages i still run the alter database open resetlogs and its gives me a message saying that more recovery has to be done to make it consistent .

I am not sure where i am going wrong and why the system01.dbf is not correctly being restored. Any Help will be higly appreciated

TIA, Jiga  

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<admd10ln0jn580nbfot572umscsq8m5uqm_at_4ax.com>...
> On 27 Jan 2004 12:22:11 -0800, jiggamanrocks_at_yahoo.com (jiggaman)
> wrote:
>
> >Hi,
> >
> >I am using Veritas Backup Exec For Windows Server V 9.0 and am trying
> >to restore a previously backed up database. All the Tablespaces, redo
> >logs and archive logs are restored fine. however the 3 control files
> >that were backed up were restored as one file "BECF<SID>.BAK". Now
> >according to the veritas manual once i have the .BAK file I am suppose
> >to refer to the "Restore Section - Loss on Non Mirrored Control Files"
> >in the oracle Administrators guide. However the Oracle Administrators
> >guide has no such section. it has a few things on recovery which is
> >using RMAN. however i dont know how to convert this .bak file that i
> >have into a .CTL file. also when i did a backup of the database there
> >were 3 control files and when i restore it there is only 1 which is
> >called becf<sid>.bak. what is the procedure i need to follow to get
> >this control file in place so that i can recreate this database. Any
> >and all help will be hight appreciated.
> >
> >thanx in advance.
> >
> >Jiga
>
>
> Likely this is a proper *binary* control file, with only the file name
> extention changed.
> Hence the only thing you need to do is to copy that file to the
> original locations (and yes, consequently you need to copy that one
> file to 3 different files).
> Then you need to
> recover database using backup controlfile until cancel
> followed by
> alter database open resetlogs
Received on Wed Jan 28 2004 - 14:49:24 CST