Effectivelly that's work and increment from 238917182 to 238917183
But I can't usually apply other archive to arrive until time <...>

SVRMGR> recover database until time '2006-07-10:07:00:00' using backup contro
lfile;
ORA-00279: change 238917182 generated at 07/07/2006 19:32:43 needed for thread 1
ORA-00289: suggestion : /proddata/arch_prd/arch/ameprd_1_306.arc
ORA-00280: change 238917182 for thread 1 is in sequence #306
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/proddata/oradata/omda/system/redo/redo01a.log
Log applied.
Media recovery complete.

And after

SVRMGR> recover database until time '2006-07-10:07:00:00' using backup controlf
ile;
ORA-00279: change 238917183 generated at 07/07/2006 19:32:43 needed for thread 1
ORA-00289: suggestion : /proddata/arch_prd/arch/ameprd_1_306.arc
ORA-00280: change 238917183 for thread 1 is in sequence #306
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00326: log begins at change 238992508, need earlier change 238917183
ORA-00334: archived log: '/proddata/arch_prd/arch/ameprd_1_306.arc'
SVRMGR>

Thkx for help

Omar ACHANDAIR



-----Message d'origine-----
De : Bryan Gilchrist [mailto:[Email address protected]
Envoyé : jeudi 27 juillet 2006 18:58
À : Omar Achandair
Objet : RE: URGENT -apply archive log on a database after being renamed- !!

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


Omar, try a redo file instead of the .arc file...

/proddata/arch_prd/arch/ameprd_1_305.arc

Bryan Gilchrist


Oracle LazyDBA home page