Re: Copy cntrl and redo logs for standby & reports db

Thanks for the info Roy,

But...

> first, I'm not sure that you can use the "standby" server as a
> "reports" server at the same time, as the "standby" server is not open
> for use (at least not in 7.3.4), it is in recovery mode instead.

Can you not recover the standby, say, every 12 hours, and use that for the reports server?

> To create your standby server you have to do more than just copy the
> redo logs and control files ... the standby must be created from a
> backup copy of the existing server. Also, you must use the CREATE
> STANDBY CONTROLFILE on the existing server and use that control file
> to startup your standby.

I was expecting to copy the datafiles to the standy first (as a one off job) then at regular intervals copy the new redo logs and the control files over and then recover and open the database. What I was wondering is, is there going to be a problem if the datafiles are on a different RAID type and/ or in different locations, i.e. is the redo log data that low level that it refers to the binary image on the disk?

I can put up with having the same locations on both servers if having different causes a big problem but I would like to get away from RAID5 at a later stage, going to RAID10. And to do this, once the standby is up and running, I was going to swap the production box and standby. I could then compare timings for various dataloads (RAID5 vs RAID10). I suspect that RAID10 will be much faster (as our app is very write intensive). I would then rebuild the old prod server as RAID10 where appropriate and swap back when all was well.

What do you reckon?

Cheers
Tony

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 18 1999 - 04:32:39 CDT