pre and post execution scripts on HP Data Protector (463 Views)
Reply
Regular Advisor
Emad Omar
Posts: 110
Registered: ‎09-06-2004
Message 1 of 3 (463 Views)
Accepted Solution

pre and post execution scripts on HP Data Protector

[ Edited ]

Hi,

 

I have a request from our customer to activate the pre and post execution scripts for backup job; in order to start and shutdown oracle or SQL database automatically.

Please advise if we need any type of HP DP License to implement this option and how can we get these scripts.

 

Regards,

Emad  

 

 

P.S. This thread has been moevd from Storage > Automated Backup to Data Protector Support and News Forum. - Hp Forum moderator

Please use plain text.
HP Expert
Stewart_Macleod
Posts: 44
Registered: ‎09-02-2013
Message 2 of 3 (439 Views)

Re: pre and post execution scripts on HP Data Protector

You do not need any extra DP license in order to use Pre and post exec scripts.

Your customer's Oracle and/or SQL Database Administrator (DBA) should write the scripts to shutdown, and restart either Oracle and/or SQL as required.
Please use plain text.
Honored Contributor
danielbraun
Posts: 683
Registered: ‎07-07-2010
Message 3 of 3 (439 Views)

Re: pre and post execution scripts on HP Data Protector

Hi,

 

when Oracle is shutdown before the backup, you do not need any license to backup the ORADATA files. You have to create two script placed in C:\program files\omniback\bin or /opt/omni/lbin. The scripts must include the commands to stop or start the database.

 

I personally recommend to backup Oracle databases using the online integration (license required) as it gives you more flexibility in case of restores. If not applicable you can use a custom rman script too, to dump the database into filesystem before the backup is done. In this case you do not need to shutdown the database.

 

Best regards

Daniel

-----------
Please assign Kudos - How to assign...
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation