Chris,

Recreating the controlfile does not reset the redo logs, it's only when
you open the database with resetlogs that it does. If you are just
recreating the controlfile you should not have to open with resetlogs.
However if you are renaming the database with your controlfile or doing
incomplete recovery with the recreated controlfile then you will have to
open with resetlogs.

Your specific situation usually happens when you recreate the controlfile
and the database was not shutdown normally (shutdown abort or a crash) and

there are still commited transactions that have redo records in the
current online redo logs that were not written to the datafiles (and since

it's the current redo it is not archived yet - remember that the archive
logs are just copy of online redo logs)

Recover the database; i.e

recover database using backup controlfile (until cancel);

When it prompts for the "future" archive log, which is actually your redo
- just enter the full path of your online redo log. When recovery is
complete:

You can open or open resetlogs if it is incomplete recovery.


"Chris Ermlich " <oracledba-ezmlmshield-x91958203.[Email address protected]
wrote on 05/07/2007 04:12:31 PM:

> Ephraim,
>
> Could you explain a bit more on how to "apply the online redo logs" ?
>
> I ran into a similar situation that Yejide described.
>
> I had rebuilt the control file using the script that Oracle provides
> when you issue a:
> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
>
> However, using that script the control file gets rebuilt and so do
> the online redo logs.
>
> How would I apply the online redo logs since they got replaced as well
??
>
> Thanks,
>
> Chris.
>
> -----Original Message-----
> From: Ephraim V Malag [mailto:oracledba-ezmlmshield-x16508657.[Email
> address protected]
> Sent: Monday, May 07, 2007 1:10 PM
> To: LazyDBA Discussion
> Subject: Re: overwritten controlfile
>
> Apply the online redo logs when it prompts you for the "future" archive
> logs. If you are not sure, apply it one by one. Oracle knows what it
needs
> as it knows what the next SCN required.
>
>
>
> "Yejide Adetiba \[ MTN - Ojota \] "
> <oracledba-ezmlmshield-x79644146.[Email address protected] wrote on
> 05/07/2007 02:02:21 PM:
>
> > Hello All,
> >
> >
> >
> > My test environment database controlfile was accidentally overwritten
> > with the controlfile of the standby database. I recreated the
> > controlfile and tried to apply the arch files, but it was asking for
> > arch files in the future.
> >
> > Please, has anybody experienced this before, please help.
> >
> >
> >
> >
> >
> > Cheers



---

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

Oracle LazyDBA home page