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
>
>
>
>
>
> NOTE: This e-mail message is subject to the MTN Nigeria disclaimer see
> http://www.mtnonline.com/contact/disclaimer.asp
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


---

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.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page