Actually i've the problem :

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/proddata/arch_prd/arch/ameprd_1_306.arc
ORA-00326: log begins at change 238992508, need earlier change 238917182
ORA-00334: archived log: '/proddata/arch_prd/arch/ameprd_1_306.arc'

When I give the previous one, I ve this message:
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/proddata/arch_prd/arch/ameprd_1_305.arc
ORA-00310: archived log contains sequence 305; sequence 306 required
ORA-00334: archived log: '/proddata/arch_prd/arch/ameprd_1_305.arc'

That seems that oracle need a SCN 238917182 from a file whith seq 306 !!

Thkx for help


Omar ACHANDAIR


-----Message d'origine-----
De : Ephraim V Malag [mailto:oracledba-ezmlmshield-x30276197.[Email address protected]
Envoyé : jeudi 27 juillet 2006 18:31
À : LazyDBA Discussion
Objet : Re: URGENT -apply archive log on a database after being renamed- !!

Should not be an issue. Just format you log_archive_* parameter so that
your renamed database can find and know the format of your archive logs.

i.e recover database using backup controlfile until time ......



"Omar Achandair "
<oracledba-ezmlmshield-x96690173.[Email address protected] wrote on
07/27/2006 02:10:13 PM:

> Hi dba's
> I've renamed a database from a backup off 06-07-2006.
> 1- startup nomount (new name)
> 2- create a control file (new name) [database is mounted]
> Is there any way to apply the archive log of the source database in
> order to have the new database on the state of 10-07-2006. [I'm
> wondering if I could apply recover database until time .... ] But the
> problem is:
> -the archive-logs are from a database that has another name!!!
>
> Plz Plz help.
>
>
>
>
> Omar ACHANDAIR
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.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.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page