Manually fix archive gaps?

From: Frank Foss <fozzie_beer_at_hotmail.com>
Date: Tue, 30 Sep 2003 14:21:15 -0700
Message-ID: <blcs27$aivdm$1@ID-190416.news.uni-berlin.de>

We currently have a Primary/Standby database set up. Both are running on a 2-node Compaq Tru64 Unix clustered servers.

The standby was created the hard way (using ftp, not RMAN) and replication basically works.

RMAN is set up to run against a Legato NetWorker server, the primary database and standby database are backing up to separate Legato servers on different sites.
We have RMAN scripts that backs up the primary database, and the archive logs using
UNTIL TIME sysdate-5 DELETE INPUT
We thought keeping logfiles on disk for 5 days would be a good start.

Recently, an archive gap has developed, quite a significant one, about 70 logfiles missing.
I have no idea why this happened, the database is in test anyway.

Is it possible to:
* Retrieve them from Legato to local disk, using RMAN, only placing files on
disk
* Copy them to the Standby server

Register logfiles manually
Bring Standby up to date, and restart managed recovery

I've been looking at the RMAN user guides, but haven't really found any scenario that covers this.

Any hints/pointers/links appreciated

Frank Foss
Junior DBA Received on Tue Sep 30 2003 - 16:21:15 CDT