Re: Questions about Standby Database

If your system can loose 6 hours of data, I assume that it is a very critical one. I think you could save yourself a lot of efforts by implementing a DataGuard. You will probably still need to spend time studying and confiuguring it, but it is going to work for your benefit - it's a new technology, excitement, fun and an advantage for future job search :-)

If you choose to implement the scripts, any simple design, such as transfering by ftp and such from cron, will work. There probably will be some maintenance overhead, though. That worked for us for several years, until our business requirements became more strict, at which point we had to put more effort in the code.

Regs
AK

Jeffrey Keung wrote:

> Hi All,
>
> I am newbie in this news group and i would like to ask some questions
> here:
> Recently i am planning to setup a standby database at my company, and i
> am working on a
> architectural document about it.
>
> My setup will be as following:
> - Primary database, with ARCHIVELOG mode.
> - use cron jobs in HP_UX to copy the archived redo log files every hour
> to the standby site
> thru FTP and manually applied the log files every 6 hours.
>
> I have tested with the setup above and it works fine.
> Now, I need to brainstorm what problems i will faced when it come to
> production.
> However, i can only think of :
> - Log files failed to copy thru FTP and DBA need to recover the standby
> manually.
>
> Does anyone have any idea or foresee what problem i will faced for the
> above setup ?
> Thank you very much.
>
> Jeffrey
Received on Sun Oct 20 2002 - 01:49:42 CDT