Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Resuming an aborted RMAN database duplication
Bob-
If archived logs backup are thr' RMAN, How would you apply these archived log backup pieces manually for PTR ?
Thanks
Jay
On 4/16/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
>
> If the datafiles were restored successfully, then it's
> just a matter of manually restoring any needed
> archived redo logs to the new database and applying
> them manually. Then open the database. You will have
> to do this as a point in time recovery, and just
> recover to the last archived redo log sequence that
> you restored.
>
> You may also want to reset the DBID if RMAN has not
> done so already.
>
> Robert
>
> --- Don Seiler <don_at_seiler.us> wrote:
>
> > This weekend I was running an RMAN database
> > duplication to migrate our
> > development instances from 32-bit server with
> > file-based storage to
> > 64-bit server using ASM. I've done this once
> > already and it went
> > virtually fine.
> >
> > However this time we got errors while RMAN was
> > restoring the archived
> > logs. I presume that archived logs would be towards
> > the end of the
> > process, and this was already after 6+ hours. We
> > believe the error to
> > be due to a bug in the failover logic in the qlogic
> > drivers, and have
> > disabled it for now. Reissuing my command basically
> > started the
> > process over from scratch.
> >
> > I'm wondering if there is a method available to have
> > the DUPLICATE
> > DATABASE or maybe just manually, restore the
> > remaining archived logs
> > and then move on to recovery and database opening.
> > It seems silly to
> > have to do another 6 hour datafile restore.
> >
> > I could swear that RMAN did know when files didn't
> > need to be restored
> > and would skip over them. Perhaps that was for a
> > "restore database"
> > command.
> >
> > --
> > Don Seiler
> > oracle: http://seilerwerks.blogspot.com
> > ultimate: http://www.mufc.us
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> Robert G. Freeman
> Author:
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Features (Oracle Press)
> Oracle Replication (Rampant Tech Press)
> Mastering Oracle8i (Sybex)
> Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>)
> Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 19 2007 - 19:33:32 CDT