Re: Online in a 24x7 Setup. How?

zandy wrote: > > Can anyone give me pointers on how to configure > Online in a 24x7 OLTP Setup ? > What are the issues regarding Backup, Restore ? > > Notes : > ODS ver 7.23 > Machine: Pentium 200 1 CPU > Memory 128 MB > Application : Point Of Sale > Ave. Transactions /day = 5000 > No Of users = 5 > > -- > Keeping me busy : > Porting D2 C/S apps to D3 3-tier > Email : zandy@skyinet.net What is your OS? What backup devices do you have? How large is your database? What is acceptable loss of data in the case of crash (none, I suppose). Of uptime? But generally, you do a level-0 backup once a week or more often, and level-1 and/or 2 backups once a day (during lull in processing - it is online backup, but it does consume quite some resources). Then you do continous backup of logs to tape (or mirrored disks). Use rather small log files, so that even in the case of total disk crash, you won't lose too much (logs go to tape when they fill up, or sooner if you manually switch to next one.) Also consider mirroring your disks (either using Informix or OS mechanisms - details of preffered setup depend on OS details, type of volume manager used etc). RAID will make data safer, but then you lose table partitioning optimizations etc. Another thing to keep in mind: if you are 7x24 shop, you will not have opportunity to reorganize your database. So, plan things like extent sizes, table partitioning, use of different dbspaces etc. most carefully. HTH Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+