Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Controlfile older than DBF files
Hi Cyntia:
Try to use the restored data-files and the new control file you just have recreated.
With this situation try to startup your database. When you give this error:
"the system01.dbf file needs media recovery." Try to do a restauration using (Note that it could be any syntax error):
svrmgr> connect internal svrmgr> startup mount svrmgr> recover database or recover database until cancel followed by cancel; svrmgr> alter database open resetlogs;
You can try to do a datafile recovery for system01.dbf, but you will have
the same error message for all
the datafiles of your database. So is better to do a database recovery.
Note that the procedure could be different in any release of Oracle Server. If it does'nt work, look at you documentation about media recuperation procedures.
Good Luck.!!
Albert Borrull
<aborrull_at_sgosoft.com>
SGO. Software, S.L.
simbl <simblit_at_yahoo.com> escribió en artículo
<01bdc522$46a4b040$a07015a5_at_pc160>...
> Hi,
>
> I've backed up my database when it was up and running, thus the
controlfile
> is no longer good.
> Worst, the system is performing some backup tasks during the backup.
> Using this copy, I need to do a restoration.
>
> The error says that "the controlfile is older than the DBF files"
> So I tried to recreate a new controlfile but the next error says
> "the system01.dbf file needs media recovery."
>
> I've even used a newer copy of the system01.dbf and tried to bluff the
> system, but still it is not able to open the databse.
> I'm dead meat !
>
> My database has no Archivelog turned on, is there any way I can
manipulate
> the control file? or any other files?
>
> Desperately need help,
> Cynthia Tan
>
Received on Tue Aug 11 1998 - 11:02:16 CDT