Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup flash recovery area on shared storage from alternate host?

RE: Backup flash recovery area on shared storage from alternate host?

From: John Kanagaraj <>
Date: Wed, 26 Oct 2005 14:21:17 -0700
Message-ID: <>


If this is a SAN based FRA, can you not use a technology such as ShadowImage (HDS) or BCV (EMC) to split the mirror and *mount* it (not NFS) as a filesystem on another host that has access to the tape drives? (any host is ok but you kill two birds with one stone if this is the standby host) Note that the FRA by default is not only the backup area, but has the archive logs, flashback logs, etc, so you cannot take it offline. Offloading such work requires a *complete* detach - via a mirror such as what I describe above...

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Co-Author: Oracle Database 10g Insider Solutions  

-----Original Message-----

[] On Behalf Of Jeremiah Wilton Sent: Monday, October 24, 2005 11:31 AM
Subject: Backup flash recovery area on shared storage from alternate host?

Environment: 10gR1 Solaris 9

I am using RMAN backups to a flash recovery located on a shared NFS volume.

In order to reduce load on primary hosts during subsequent backup to tape, I would like to back up the flash recovery area to tape using an alternate host. In this case, I would like to use the standby (physical dataguard) host, which has the flash recovery area mounted via NFS.

If I specify the primary as the target database, then RMAN starts a server process on the primary that reads from the FRA and ships over SQL*Net to the standby which writes to tape. Obviously this is not what I am looking for, since I still impose significant load on the primary.

When I specify the standby as the target database, RMAN can't see the FRA backups, and encounters the error:

RMAN> list backup summary;

RMAN-03002: failure of list command at 10/24/2005 10:42:57
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at
10/24/2005 10:42:57
RMAN-20070: invalid log history sequence#

Metalink advises that people using standby for backups use a separate recovery catalog from the primary. Obviously, if I use a separate catalog, then RMAN won't be able to see the backups in the FRA in order to write them to tape.

Has anyone successfully backed up their FRA or done something similar using shared storage from an alternate host using RMAN?


Jeremiah Wilton


-- Received on Wed Oct 26 2005 - 16:23:50 CDT

Original text of this message