Hi all,

We are running BaaN under HP Unix / Oracle 8i. For the daily backups we are doing the below

1. creating sequential dump of tables through BaaN Session (activated through Job)

2. Exporting the Oracle Database through Oracle export utility

exp full=y file=/d02/bkp/expfullsys.dmp compress=y grants=y indexes=y rows=y constraints=y log=/d02/bkp/expfullsys.log triggers=y

3. Complete UNIX System backup (through SAM)

Because of these jobs, the system is not available daily between 11 pm and 6 am.


My question is

1. Is these three types of backup is necessary everyday?
2. If not what alternative is recommended?
3. Can Oracle export and BaaN Job run at the same time?
4. If it runs at the same time, will the data be backed up properly (by BaaN dump & Oracle Export?)
5. Which of these backups is most reliable?

Now since the data is growing up fastly and more time is taken to complete the backups, i need to revise these backup schedules

hence, I welcome your suggestion

Regards

Hi Nizamudeen,

We are on HP-UX / Informix IDS

1-We are creating sequantial dump of tables once a week because we have only time for backup on sunday nights and it takes over 12 hours. If I had the time would do it more than once a week.

2-every day a full backup of informix (ontape -s)
3-once a week fbackup (fbackup -f /dev/rmt/1m -i /)
4-once a month make_recovery backup (make_recovery -v -A -d /dev/rmt/0m)
5-and export data dictionary from baan (depending on created new sessions, reports ..)

what I can offer to you is taking make_recovey backups .You can recover your UX os for OS crash

Caner

Hi Caner,

is it also not important to run "Reorg. Tables" on a regular basis? if yes than what should be the frequency?

Actually, I am in a process to define a backup-recovery process for my company and ur post has helped me..

we are also on HPUX/informix. Could u suggest any thing for HPUX-Informix tuning may be ur personal experiences or any book ..

Thanks in advance.

Hi guys,


One question about re organise tables..

Will running the session reorganise tables with BaaN running on Oracle database / Informix database has the same desired result as running the session on Tbase tables ?

Regards

First look at your hardware redundancy, do you have enough redundancy to protect your envionment.

From what I see, I would probably recommend the following backup strategy.

1. Daily hot, incremental Oracle Backups. As time and days permitting do cold backups.

2.Weekly - Shutdown the database and Baan Envionrments, and do a cold backup of the system. Do your Oracle exports and Baan bdbpres, if truely needed.

Hi nizamudeen,

i am a little bit confused about your backup-strategy.
Why don't you use the feature of oracles archived logfiles :confused:

PB

Hi,

Yes, I agree that the backup of oracle archived logfiles is good. but i fear that it will reduce the performance since each transactions will be archived (we have remote loactions and hence the access speed from those locations will be affected if i enable the archive log feature)

also i am worried about the disk space.

Regards

Hi,

Yes, I agree that the backup of oracle archived logfiles is good. but i fear that it will reduce the performance since each transactions will be archived (we have remote loactions and hence the access speed from those locations will be affected if i enable the archive log feature)

also i am worried about the disk space.

Regards

Nizamudeen,

It will depend on your environment sizing whether archive logging will impact performance dramatically or not. Disk space should not really be a concern as you can move the archive logs to tape at any time you want.

Hi,

oracle loggs each transaction all the time at the redo-logs.
The only diffrence by using archivedlogs is the archiving of the full redologs by copying the redologs into new files.
By using the archivedlog-Feature you can use your last offlinebackup in addition to the saved archived logfiles to recover the oracle database up to the last transaction you saved.
This makes you able to have an uptime as long as you need before your next offlinebackup.
Example:
- offlinebackup every Sunday,
- continous (or daily)backup of the archived logfiles
...if the system crashes on wednesday you put in the last offlinebackup and all logged (and saved) transactions. The result is a database which is as close as you need to the livesystem.

You can backup the archived logfiles to any device you need.
One important thing you should look for is the mean time to recover (MTTR).

PB

Hi guys,

Thanks for all your inputs. It will really help me in re desiging my backup strategy.

If i have any queries, will come back here

Regards

Hi Nizam,

I'm also planning for a backup strategy to improve operation of our Baan system. We're running on NT platform.
We plan to do the following:-

Baan live server db (Archiving turn on)
|
|---> SAN/NAS (Archive logs, disks are now relatively inexpensive)
|
|---> Standby Baan Server (DB Created from archive logs)


Advantages
========
1) Increased operating hours of Baan Live Server (no downtime for backup processes)
2) Improve backup process (ie hotbackup/online backup)
3) Improve backup/recovery process (ie to poin of failure)

Disadvantages
===========
1) Requires a little hardware investment