RE: Resuming an aborted RMAN database duplication

Extract them (restore archive log) and then apply manually.

RF


Robert G. Freeman
Oracle Press Author
Principle Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Collaborate '07
Come join my APEX University Session
and Join me to talk about Evolutionary Database Development!!
The LDS Church is Hiring DBAs! Contact me if you are interested!


  -----Original Message-----
  From: jayaraj rengarajan [mailto:jayaraj.rengarajan@xxxxxxxxx]
  Sent: Thursday, April 19, 2007 6:34 PM
  To: robertgfreeman@xxxxxxxxx
  Cc: don@xxxxxxxxx; oracle_l
  Subject: 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@xxxxxxxxx> 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@xxxxxxxxx> 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

Other related posts: