Re: How to reduce the resync time about Oracle 8i DB with BC (1056 Views)
Reply
Regular Advisor
public
Posts: 132
Registered: ‎06-06-2003
Message 1 of 2 (1,056 Views)

How to reduce the resync time about Oracle 8i DB with BC

[ Edited ]

I have a HP-UX 11.11 server with XP12000 storage and BC(Business Copy) machanism and a Oracle 8i DB which have 300 tablespaces.
There are 4 times per day of resync jobs.
I create standby control file and alter all tablespaces begin backup when BC resync.
After split of BC using at-time-split mode, I alter all tablespaces end backup.
After that, I can open a read only standby DB at backup site for reporting service. If DR happen, I can apply DB's archive log files to standby DB and change it to be a product server.
But it takes a long long times(over 1hr) when I alter all tablespaces begin backup.
Is there any solution which can match my request(reporting and apply archive)?
Or, how to speed up the "alter tablespace XXX begin backup"?

 

P.S. This thread has been moved from Business Recovery Planning to HP-UX > databases. -HP Forum Moderator

Honored Contributor
Eric Antunes
Posts: 1,944
Registered: ‎06-15-2003
Message 2 of 2 (1,056 Views)

Re: How to reduce the resync time about Oracle 8i DB with BC

Hi,

"But it takes a long long times(over 1hr) when I alter all tablespaces begin backup."

Why do you use "begin backup"? Don't you use RMAN?

In what kind of filesystems are your redolog files? RAID 1+0, RAID 0+1, RAID 5, RAID 10, etc...

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.