offload backup to standby

From: hrishy <hrishys_at_yahoo.co.uk>
Date: 5 May 2004 04:47:51 -0700
Message-ID: <4ef2a838.0405050347.3f5ee19e@posting.google.com>

Hi All

Suppose i have a 3Tb database on the following version of oracle

a)9iR2
b)817
c)7.3.4

In 9i R2 we can use datagaurd and releive the primary database and make it available whil the backup window of say 15-18 hours can be utilized without disturbing production on the datagaurd database.

I was just wundering can we do anything similar on 817 and 7.3.4 versions of standby databases ?

Can i create a standby database for 7.3.4 and 8.1.7 and then take a hotbackup of the secondary databases do a couple of log switches on the primary move it to secondary server and backup them as well.. Has anybody implemented such a scenario.

I am asking this question out of curiosity wundering anybody has done this kind of a thing?

regards
Hrishy Received on Wed May 05 2004 - 06:47:51 CDT