RE: Backup flash recovery area on shared storage from alternate host?
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxx>
- To: <jeremiah@xxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 14:21:17 -0700
Jeremiah,
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...
Best!
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Co-Author: Oracle Database 10g Insider Solutions
http://www.samspublishing.com/title/0672327910
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeremiah Wilton
Sent: Monday, October 24, 2005 11:31 AM
To: ORACLE-L
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?
Thanks,
Jeremiah Wilton
http://www.ora-600.net
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
