Re: Control files time stamp

The Safest thing would be to rebuild the control files. In order to do that, you may want to startup, mount (but not open, which you cannot anyway) the database (if possible), and backup control file to trace. that will give you a script to re-build the control file again.

Alternatively, if you already have some old control file backup, and if the database has since not changed much (in terms of additional data files, renamed files etc.) you should be able to use such a control file to rebuild a new control file.

As a last resort, you can build a control file on your own, provided you have all the information necessary for creating one (for example, the name of instance, and each and every data file, log file, with complete destination path etc.). You have to be extra careful while doing so. Good luck!

You should be able to find a sample control file creation syntax in any standard Oracle document, if not, some of us would be happy to help.

 Good luck!

Umesh Tiwari

In article <01bd17cf$3638c080$62fd41c2_at_default>,   "Eliseu Angelo" <eangelo_at_mail.telepac.pt> wrote:
>
> Hello,
>
> A few days ago, a lamme guy filled my database with crap, since i found it
> easier to restore the previous day backup, then cleaning the db manualy, i
> did so.
>
> After the restore ( with the arcada backup) i found that i was unable to
> put the database online again.
>
> I got a msg telling that my control files are newer then the database.
>
> If you now how can i bypass this problem please reply.
>
> Thanx a lot
>
> EA

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet