backup solutions

[sharif naser_1]

Hi guys ,
I have seen some backup solutions which does
a replication & backup . the implementation is
simple ,no need for any integration besides that the recovery process is up to the last second then what is the use of ob2 which does only a backup .
any help is highly appreciated

Regards
S.N.

[Alexander M. Ermes]

Hi there.
Depends, what you want.
If you need a tool, that does backups of any kind ( hot backups, cold backups, special setup for filesystems etc. ), with a relatively easy to handle interface ( GUI and command line ), take OB2. For the recovery of systems gone down, you can use Ignite ( make_recovery ). We use these tools for years now without any major problems.
Rgds
Alexander M. Ermes

[eran maor]

Hi

1. you can use the ignite to backup your vg00
with make_recovery

2. you can use the fbackup to backup all the other file system that you have

3. hp omniback is a openview product for doing backup and can be install on the system (nt,hpux) but it cost money .

dont know about a third party that is doing what you ask about one process but the perfer method to backup is tar or fbackup and the system to backup with ignite .

but you can ask about omniback that can backup all your system if you have the right license .

hope i help

[Magdi KAMAL]

Hi Sharif,

1. If you want to save Unix and all files under volume group vg00 which is respresented by the original internal disks, so really you need to use the Ignite solution ( The command is :
make_recovery -A -d /dev/rmt/0mn

-A : stand for the entire vg00
/dev/rmt/0mn : No-rewind device assumed to be 0m (could be 1m or whatever it is. )

You may do this backup each time you change the system config or any kind of changes that are stored within internal disks ( vg00 ).
This allows you to restore the entire environment if you have troubles ( internal disk crash, bad configuration, ... ).

2. If you want to save file systems:
You can use : tar, fbackup-frecover, cpio, dd ... it depends for which purpose and which quantity .

3. If you want to save heavy amount of data or Online data, you may use OmniBack II ( OB 2 )which can be integrated within Oracle, Sybase, Informix or SAP solution ( for oracle cold backup with streaming mode i could reach a speed of 28 GB per hour on a Quantum drive DLT 8000 ).
The OB 2 is very intuitive and easy to use GUI, you need first to go through the new concept and to undrestand how it works. You can mange as well distributed backup on different tape drives ( Media Pool ).

The session manager within OB 2 can initiate the ob2rman.exe which is an interface to communicate with the Oracle Recovery Manager RMAN for example ( I guess it's what you are looking for ! ).

I hope this could help .

[sharif naser_1]

Hi all ,
I meant to say one of the most important feature of any backup software is disaster recovery process if i find a product which spares me the effort of having long disaster recovery procedure which is not suitable for (24*7) environment like ob2 .
i have integrated ob2 with oracle8i ver. 8.1.6 but if some thing goes wrong the recovery process will take around 6 to 7 hours i have come across lifevault (replica & backup) & veritas volume replicator ( which mirrors data to remote locations over an ip network).
Do you think ob2 is suitable for disaster recovery in hetrogenous environment (24*7) .

[Magdi KAMAL]

Hi again,

Well, it's more precise right now.
1. You may play with the HP Autoraid : so you got the mirroring and the stripping, but attention you need to be less or equal to 50 % used to have your Autoraid running as Raid 0+1.
In this case, if you got a bad disk you can replace it live without downtime ( Hotswap disk ).
2. Beside that the Fiber Channel 60 could help in replicating data across geographical places ( till 20 kilometers ) with a high speed rate.
3. You need to consider for this availability of data ( 24*7 ) the MC Service Guard which deals with packages running on nodes in a cluster ( If you interested by this technologies, I can give you more details ).

[Alexander M. Ermes]

Hi there.
Now we have more details.
The speed of your recovery depends on the hardware, you use for backup purposes.
If you use DLT tech, ( DLT 7000 for sample )
and take a tape library you have a transferrate of 36 GB/hr on one drive.
We use tape libraries on several machines for the backup of Oracle databases and have OB2 as software.
Doing a cold backup on four tape drives gives me a window of 2hrs 50 minutes for 340 GB.
you can spread the files on the tapes and do a parallel restore of several filesystems in case of recovery and many more things.
We are satisfied with this product.
If you need more explanation, contact me at
Alexander_Ermes@web.de

Rgds
Alexander M. Ermes

[sharif naser_1]

Hi there ,
I will be more precise i have some applications like oracle financial , erp's & oracle on HPUX & NT i would like to have a recovery site by clonning the same production
environment to some other remote site .
how do i go about it ? do i have to go for san or some other thing ?
BTW Magdi i'm very much interested if you have some information .

thanks

[Alexander M. Ermes]

Hi there.
Back from my vacation think about this :
do an export of the production database
and keep the creation scripts, Oracle software and so on on a DDS tape ( weekly ? your deciosion ). For the system make a recovery tape. That would you the chance to recover a complete system.
Besides that can you create transportable tablespaces for the application ?
You could copy these to a different database and make a backup of this or just backup these files.
Think about it and let me know
( Alexander_Ermes@web.de )
Rgds
Alexander M. Ermes

[sharif naser_1]

Hi there,
well, the procedure given does not fit because
i have different applications & more than one database ,the environment is 24*7 & the volume of data is big around 3 terabyte .
in short i want a disaster recovery solution which replicates this environment to a remote site over ip network & performs synchronization to ensure data consistency .
disaster recovery process should be fast & minimal .
Regards
S.N.

[Bill McNAMARA_1 · Accepted solution]

You need to get an XP disk system with an extra called Business Copy XP.

It's worth it in the long run..

Later,
Bill

[James R. Ferguson]

Hi Sharif:

If you haven't looked at EMC2 SRDF you might want to do so. Start with this white paper:

http://www.emc.com/partnersalliances/pdfs/oracle8_srdf.pdf

...JRF...