We are having SUNSPARC 2.5.1 with oracle 8.0.5 B40c4 with 50 users. We are considering to buy a backup software (Veritas Netbackup or Bakbone Netvault ).

We wish to know following matters.

1. If the backup frequency is half an hour ,does that affect the system performance in general.
2. In case of hard disk failure, do we need to relicence Baan .
3. In case of other hardware like CPU crash , do we need to re-licence baan if we have hard disk raw backup.
4. Does oracle have any problem with raw hard disk back (at the time of restore in case of disaster)
5. How does one restore few tables of Baan selectively in normal course without disaster. (looking for steps).
6. If we go for such software , does this eliminate the need for Sequential table dumps.
7. Any comparative analysis between Veritas and Bakbone (wrt market share , reliability , pricing etc)

imho ... :

1. No
2. No
3. Yes
4. No (if offline)
5. You'd need to restore to a dummy database then export/import relevant tables
6. Depends why you're doing sequential table dumps
7. don't know

1. If the backup frequency is half an hour ,does that affect the system performance in general.

)Depending upon the IO overhead placed on the system by the backup

2. In case of hard disk failure, do we need to relicence Baan .
3. In case of other hardware like CPU crash , do we need to re-licence baan if we have hard disk raw backup.
If the root disk is lost, so that the inode changes, then Baan must be relicensed.

4. Does oracle have any problem with raw hard disk back (at the time of restore in case of disaster)

Most Oracle sites are using file systems so they can backup/move files easily. Raw devices require RMAN backups, but this is generally the method used for hot backups.

5. How does one restore few tables of Baan selectively in normal course without disaster. (looking for steps).

This will require an export file, or a restore to a second instance. You would then copy the tables from the export or the restore instance. You cannot restore a single table from a RMAN backup.

6. If we go for such software , does this eliminate the need for Sequential table dumps.
No.

7. Any comparative analysis between Veritas and Bakbone (wrt market share , reliability , pricing etc
Veritas has over 50% of the US backup market share. I have never used Bakbone (or even heard of it) before now. I have used TSM, Legato, Omniback, ArcServe, Backup Exec and Veritas. Depending on your platform, there are strengths and weaknesses to each. However, there is no such thing as a trouble-free backup solution. There are always problems and the basic discipline of testing restores can never be taken for granted.

-- Jim