rman or not?

[DavidH_2]

Hi,
We have 2 N-Class Server and oracle8.1.6(about 30GB,8 instances) running on 11,
At the moment we use HP business copy and omniback to do hot&cold backup, we already have cron job and ksh scripts to do maintain job,I am wondering if it is necessary to change to use rman, I know there are many new features in latest version. if I do,why?
I have been to few company they are running oracle on hp and did not use rman either.

Also, can anybody give me some ideas how to integrate rman,business copy and omniback togather.

Thanks

[Joseph T. Wyckoff]

Omniback requires RMAN for Oracle 8 hot backups, so there is a pretty good chance you are already using it.

Within Omniback you actually list out the RMAN comands that you want executed, Omniback starts RMAN, and then Omniback listens to 'pipes' and records the data sent by RMAN.

I suppose if you are using OB II 2.55 you might have cobbled together a hot backup using EBU for an Ora 8 database... but that is not supported.

Good Luck.

[Joseph T. Wyckoff]

When you say business copy - I am a little fuzzy - but if we are talking either EMC or XP256 / XP512 / Surestore E - there is an available integration that might meet your needs.

The XP stuff is available with OB II 3.1 and later. The EMC integration was available earlier - but I don't know when it first became available.

The bad news is that this is an additional license (to use our 'integration') and a pretty hefty chunk of change. See your sales guy...

[Printaporn_1]

Hi,

RMAN is recommend Oracle tools for Oracle8, Then if you have large database it better using Rman and integration with Omniback for easy media management.

[Volker Borowski]

Hi,

rman requires OBII ONLINE filebackup option for UNIX on UNIX-Hosts.
If you have good scripts, to set tablespaces to backupmode in preexec and of in postexec, you can go with a simple filesystem backup.

You should be familiar with oracle recovery,
as you have to do this manual, and also you need to organize archive-log handling, wich is more comfortable with rman, as you have delete options.

Just my 2 ?
Volker

[DavidH_2]

Thanks for replay,
We have Disk array XP256 and use business copy to do disk mirror(can do quick restore db file and recovery db when has db failure), Omniback is used to do file system backup(copy hotbackup data file to type), I'd like to switch to RMAN.

Can someone post configuration guide or scripts which can give me some ideas how to do it?

Thanks

[Printaporn_1]

Hi,

Please start from

- Oracle backup & recovery manual
and
- OBII integration guide have enough information for configuration.

somethings not in document is

# you have to use orapwd otherwise when configure with util_oracle8 will got error insuffient priviledge.