Operating System - HP-UX
1820635 Members
1881 Online
109626 Solutions
New Discussion юеВ

Backup Oracle DB in ServiceGuard Env

 
Doug Hruzek
New Member

Backup Oracle DB in ServiceGuard Env

I am looking for a script that will do the following:
1.cmhaltpkg -v pkgname
2.vgchange -a e vgname
3.mount -F vxfs /dev/vgname/lvol /mount_point
4.omnibackup runs a backup
5.umount /mount_point
6.vgchange -a n vgname
7.cmrunpkg -n nodename -v pkgname
3 REPLIES 3
Phani Yenugu_1
Occasional Advisor

Re: Backup Oracle DB in ServiceGuard Env

Which type of backup do you want to run using Omniback? You could use oracle
utilities like EBU for 7.x and RMAN for 8.x databases to integrate with
omniback and do the backups (offline, online and archive) at the database level
so that they are consistent. When you do such backups you could just specify
the name of the virtual server (like testdb.xyz.abc.com) where the db package
is running in the client barlist in Omniback. Omniback picks it up whereever
the db is running at that time. You don't need to really shutdown the package
to do any offline backup. you could just put the package in maintenance mode in
the pre-exec script of omniback and take it out of the maintenance mode in the
post-exec script.

Doug Hruzek
New Member

Re: Backup Oracle DB in ServiceGuard Env

To ensure a complete backup of the databases. We have a script that shutdown
the DB and Omniback runs a backup job on the DBAs mount points. Our DBs are not
24x7 yet. I thank-you for responding to my question.
Doug Hruzek
New Member

Re: Backup Oracle DB in ServiceGuard Env

What do you mean by: put the package in maintenance mode in the pre-exec script
of omniback and take it out of the maintenance mode in the post-exec script.