Re: Resuming an aborted RMAN database duplication

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