Hello All,

This is what our customer wants to know.
They are using windows NT 4.0 server and oracle database with Baan5.0b.
Their system is runnung 24 hours, but the operator is not working for all day long.
They think the time, from am 2:00 to am 4:00, is the best suitable backup time, but the operator is not be able to do the system backup everyday due to working time. And they also have concern about the duration time for backup, because their data is increasing so fast.

So they want to know how other customers(including global customers) are doing the system backup and are there any utilities or 3rd party software and so on ?

Hi Kong,

We are running Baan on Unix, so we are using shell command for taking backup on off times.

And as you people are on NT, what I think is you can take backup by job managment.

rgds,
Abhivyakti

Hey! Kong,
I am not on Oracle, but like SQL, there must be some feature in Oracle to schedule different types of backup.
Also, advice them for cold backups.

Oracle need not be brought down for doing a backup. Online backup of database can be done during the slack time of the operation.
What is the Oracle version ?
If Oracle is 7.3.x then you have to use custom scripts to do backup.
If Oracle version is 8 or 8i, you can use 'RMAN' to do backup. RMAN (Recovery manager) is a Free utility provided by Oracle for doing backups.
If you wish to backup to tape, then you have to use some Media Management software (such as Brightstor (or ArcServe), Netbackup from Veritas) which integrates with RMAN to do the backup. If these Media Management software is used, then it will have all the scheduling also. So, the backups can be scheduled to run during any time of the day unattended. However, if the size of the database is more than the size of the tape, then you need to use a tape library for unattended type backups. You can also use RMAN to backup the database to disk. After the database is backed up disk, those files can be backed up in any traditional method. For backing up the data to disk, you can use combination of scripts and schedule the scripts using Windows Scheduler.

ArcServe (or Brightstor) can backup Oracle database with or without using RMAN.

ArcServe (or Brightstor) is from Computer Associates and
Netbackup is from Veritas Software.

I hope this helps you.

Dear All,

Thanks for your kind information.

Best regards,
CM Kong

hi,

u can also user schedulers to excute some batch files.
u can download schedulers from www.download.com available as free.