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

Home -> Community -> Usenet -> c.d.o.server -> Re: Rman logfile restore and catalog behaviour

Re: Rman logfile restore and catalog behaviour

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 05 Jul 2007 06:51:20 -0700
Message-ID: <1183643479.367560@bubbleator.drizzle.com>


Neil Cudd wrote:
> Hi there,
>
> this could get confusing so bare with me :
> AIX 5.3 Oracle 9.2.0.7
>
> It's been decided to move the datacentre half way around the world
> with minimal downtime.
> We are backing up using RMAN to a datacentre in this hemishpere.
>
> So the backup tapes were exported and sent to far away to be imported
> to the tape server on the remote site (too big to be sent down the
> wan).
>
> The database is restored at the far side and put in recovery mode,
> rolling forward, catching up on the logfiles until the cutover date
> when the local DB server is shutdown - 30 days time.
>
> So I am restoring archivelogs - via rman - from 5 days ago to send
> down the wire to be applied to remote copy.
>
> However, our daily archive log rman job is now complaining that it
> cannot find log sequence #### - this being the first of the old
> archive logs that I restored localy to send down the wire. (I restored
> then deleted - not wanting to crowd the archive log area.
>
> What am I doing wrong ? (no asides on startegy - I didn't decide it,
> just left to apply it).
>
> Many thanks for any help.
> Neil

Do it again and don't delete.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 05 2007 - 08:51:20 CDT

Original text of this message

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