Re: 24x7 database

One piece of advice: Get some help.

If you are looking at a system of this size and complexity (we run a few similar systems) and are asking such basic questions - and no offence, BTW, you have every right to ask - I really think you are out of your depth. The issues surrounding this system will be complex, but nothing that can't be managed. Don't look at a few postings to a newsgroup for your answers.

Go away and plan. Get some training and consultancy. Then test. And test again.

Sorry to be so hard. But I've seen people fail before in this type of thing and the results aren't pretty.

Try reading the Oracle Database Administrators Guide for an overview of hot-backups if you want an intro., but treat it as just that, an intro, not a solution. You might also want to look at Oracle Backup Manager and other thrid party backup tools that integrate with Oracle.

One other point, try and separate your 'static' data into read-only tablespaces, then you won't have to back up so much...

Later,

Steve Phelan.

tammy.adler_at_ipaper.com wrote in message <6ek8u5$3gh$1_at_nnrp1.dejanews.com>...
>I am interested in hearing from dba's in a 24x7 environment, large
 database.
>Currently we have a 12 hour maintenance window each weekend. They are
 going
>to shorten this to a 4 hour window 3 weekends of the month, with no outage
 on
>the month-end. By fall, it is requested to be true 24x7, with scheduled
>outages every 6 months.
>
>This is a SAP application...the database is 150GB and growing
 rapidly...will
>probably double by year's end. The box is the IBM Raven, with AIX 4.3.
>
>How much housekeeping should I do in advance? What else should we do in
>preparation. Can a system be truly 24x7 without any scheduled down-time?
>What problems can we expect?
>
>E-mail or post your replies.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Tue Mar 17 1998 - 00:00:00 CST