Re: backing up standby db

Phillip Tien wrote:

>Hello,
>
>I'm trying to back up my standby database through rman and I'm running
>into a RMAN-00600 error. I've already filed a tar with metalink but I
>was hoping to see if anyone out there has had experience with backing up
>a standby database. Here's my situation:
>
>Server A houses the primary database in Datacenter A. Server A backs up
>to tape library A. Primary database has catalog on rman_A, which also
>resides on server A.
>
>Server B houses standby database in Datacenter B. Server B backs up to
>tape library B. Standby database has catalog on rman_B, which also
>resides on server B.
>
>What I'm trying to do is back up the standby database. I don't want them
>sharing the same catalog on the same rman database because then it would
>defeat the purpose of having backups on different datacenter tape
>libraries. I'm trying to build a fault tolerance scheme where I can back
>up the standby database in location B and do auxiliary refreshes of
>other databases in location B. The issue is that the database in
>question is rather large, so doing auxiliary restores from Datacenter A
>to Datacenter B is very time consuming due to network bottlenecks. By
>backing up the standby at location B and thus doing auxiliary restores
>locally would greatly enhance the time factor as well as add a layer of
>fault tolerance since if location A ever blew up, I would still have
>location B as fail safe. Here's the simple rman backup script I'm
>executing:
>
>run {
> allocate channel t1 type 'SBT_TAPE';
> allocate channel t2 type 'SBT_TAPE';
> allocate channel t3 type 'SBT_TAPE';
> allocate channel t4 type 'SBT_TAPE';
> allocate channel t5 type 'SBT_TAPE';
> allocate channel t6 type 'SBT_TAPE';
>backup
>tag fd_cold_level_0
>format 'fd_df_%U'
>(database);
>}
>
>This is the error it generates when this script is executed. Keep in
>mind this script is used to back up all my other databases so I know it
>works.
>
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-00601: fatal error in recovery manager
>RMAN-03012: fatal error during compilation of command
>RMAN-03028: fatal error code: 600
>RMAN-03013: command type: backup
>RMAN-00600: internal error, arguments [6960] [] [] [] []
>
>
>Any help would be greatly appreciated. Please copy tienp_at_wholefoods.com
>with any replies. Thanks.
>
>--
>Phillip
>
>

Version and edition information is essential.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)