Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Resuming an aborted RMAN database duplication

Re: Resuming an aborted RMAN database duplication

From: jayaraj rengarajan <jayaraj.rengarajan_at_gmail.com>
Date: Thu, 19 Apr 2007 20:33:32 -0400
Message-ID: <570313960704191733i33bc5540lf8b68b64e662ea31@mail.gmail.com>


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-l
Received on Thu Apr 19 2007 - 19:33:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US