backing up standby db

From: Phillip Tien <tienp_at_wholefoods.com>
Date: Tue, 04 Nov 2003 14:15:55 -0600
Message-ID: <3FA808FA.51832804@wholefoods.com>

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

Received on Tue Nov 04 2003 - 14:15:55 CST