General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE 9.2 Integration of RMAN with HP Dataprotector.

vish_1
Occasional Contributor

ORACLE 9.2 Integration of RMAN with HP Dataprotector.

Hi ,
I have been going through this documentation
http://ovweb.external.hp.com/ovnsmdps/pdf/b6960-90082.pdf
to implement RMAN backup solution using Dataprotector.

A particular statement causes some concerns!

Backup Flow Before a backup session begins, the Oracle8/9 Target Database instance
is switched into *backup mode*.

Why would we need to put the DB in BACKUP MODE ??

Any thoughts ?
Cheers
Vish
5 REPLIES
Steven E. Protter
Exalted Contributor

Re: ORACLE 9.2 Integration of RMAN with HP Dataprotector.

In order to get a clean usable copy of the data in the Oracle database you need to stop updates at least long enough to get a snapshot.

There are probably other ways to do it.

On HP-UX you can set up a OnlineJFS snapshot that allows for a cold backup of the database after a quick shutdown/restart sequence.

That facility does not exist on Linux.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
vish_1
Occasional Contributor

Re: ORACLE 9.2 Integration of RMAN with HP Dataprotector.

Thanks Steven for taking time to reply to me. Whilst I agree with you on the basic logic behind stopping updates for a backup, I differ and want to high-light a feature of RMAN which does not require the the database or a tablespace to be in backup-mode. RMAN removes this previous necessity and made it easier with the backups. However I was quite surprised to read about it on a Integration document ( mentioned twice ). Is this fact incorrect on the document due to HP's lack of knowledge on the subject or are they talking about how RMAN works internally ( we do not have to issue any separate commands to put a tablespace in backup mode prior to copying ). Or am I completely wrong ?? Dataprotector would require us to manually put a tablespace in backupmode whilst doing a RMAN backup ??

Has anyone implemented a solution before and please throw me some light on this .


My environment is Solrais 64 bit (9) , Oracle 9.2.04 and HP EVA and Dataprotector 5.1 on SAN.

Thanks again Steven for your reply.

Thanks
Vish
Kari Pannila
Frequent Advisor

Re: ORACLE 9.2 Integration of RMAN with HP Dataprotector.

They just have forgotten that statement in the documentation. It was true those days when doing online backups was done by copying files with tar or some similar tool.

You can see from DP templates what RMAN commands are used during backup/restore.

I have just tested DP with evaluation license and it seems to work OK.
Kari Pannila
vish_1
Occasional Contributor

Re: ORACLE 9.2 Integration of RMAN with HP Dataprotector.

Thanks Kari Pannila ,

I was a bit concerned , Now I can proceed on to try out the implementation.

Celso Medina Kern
Trusted Contributor

Re: ORACLE 9.2 Integration of RMAN with HP Dataprotector.

Hi,

I´ve just exited Oracle training and there is no way to make a valid backup without putting tablespaces in backup mode. Data Protector does this automatically when integrated with RMAN in an online backup. You do not need to worry about that.

Oracle integration is the most often integration used with DP, since release 7.X with EBU. There is no possibility that this solution does not work by a lack of HP knowledge concerning Oracle DB backup tool.

Regard
God bless pessimists, they did the backup!