Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to deploy a 24hrs , 7 days a week kind of database environment?
Only one choice - on-line backup. Your archive log mode of your database
instance should be turned on. Frequent backup is the most appropriate strategy
for your 24-hour database. For example, you can backup your tablespaces which
will be updated frequently in the morning, afternoon, and nighttime while once
per week for static tablespaces. Be careful to the number of archive log
files. Of course, you should also set up a testing database instance to test
if all backup files get no error.
Sunny Wong wrote:
> Greetings,
> This is a first time that our company are deploying a 24hrs , 7 days a week
> kind of database environment.
> Can anyone pls tell me what type of strategies shall I use in order not to
> have any downtime?
> What are the recommended backup strategies?
> Can Oracle running on NT server have this type of reliability?
>
> Thanks.
--
Best Regards,
Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)