| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
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
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 at10/24/2005 10:42:57
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 26 2005 - 16:23:50 CDT
 |
 |