"cmrunserv" command.

[Rajesh SB]

Hi Experts,

I want to take a backup of a Database, which is running on HA Cluster. This database is monitored by a script.

My plan as below to take backup without halting the package.

1.Halt the monitor service by
# cmhaltserv
2. Lock the Database to take backup.
# lock -db
3. Taking snapshot of Database mountpoint using Online JFS.
# mount -F vxfs -o snapof= /dev/vgsnp/lvsnp /BACKUP
4. Unlock database
# unlock -db
5. start the monitor service
# cmrunserv

I am not able to run the service again using "cmrunserv" command.
When you execute this command, says the file is existing.
Is there any way to rerun the Service.

Yours valueable input is highly appreciated.

Thanks & Regards,
Rajesh

[Michael Steele_2]

You're using unsupported commands, 'cmrunserv'. You need to be using 'cmrunpkg package_name' and 'cmhaltpkg package_name'.

Refer to 'cmviewcl -v' if you don't know the package names.

I believe service's are meant to connect the package.conf and package.cntl files only.

[Michael Steele_2]

For reference, this is a very good thread:

http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0x3b7c1cc6003bd6118fff0090279cd0f9%2C00.html&admit=716493758+1065995421502+28353475

[Tricia Sambrano]

Rajesh,
As far as the cmrunserv, I concur with the above reply. As for your underlying question; You need to build into the monitoring script the ability perform maintenance (i.e. the ability to take down the database).
This is usually done by setting a MAINTENANCE flag (file). A suggestion would be to have the script check of the MAINTENANCE file existence at which time the script will not check for the processes.
If you did not create the monitoring script, this may have already been done- it's fairly standard in the SG installations that I do and have modified.
Good luck,
Trish

[Sritharan]

Hi,

like others I'll also prefer using the cmhaltpkg and cmrunpkg.If i'm not mistaken if you halt the monitoring service it would halt the package also right?
In our case
1.halt the package
cmhaltpkg -v
2. mount the dirs manually(script)
vgchange -a e vg1
vgchange -a e vg2
vgchange -a e vg3
vgchange -a e vg04
mount /dev/vg3/lvol01 /stage1
cmmodnet -a -i 10.2.11.141 10.2.11.0

3. Do the database maintenance

4. umount the dirs manually (script)
umount /stage1
umount /ifmx
umount /dump
umount /stage2
vgchange -a n vg1
vgchange -a n vg2
vgchange -a n vg3
vgchange -a n vg04
cmmodnet -r -i 10.1.1.121 10.2.10.0

5.Start up back the package
cmrunpkg -v

Thanks & Regards
Sri

[T G Manikandan]

you have to use cmhaltpkg.
This will inturn call cmrunserv.

[Jakes Louw]

Heck, wouldn't it be easier just to stop the database and then do the backup, or am I missing something here?
Why not just execute the DB stop script that (I assume) is in the package shell script?

[Rajesh SB]

Thanks for your valuable comments on this.
Finally, I decided cmrunserv is not possible in command line and also not right way of usage.

I am going to restart the package, once task is over.

Cheers,
Rajesh

[Sanjay_6]

Hi Rajesh,

If this is an oracle database, have you looked into the possibility of taking a db backup in hot backup mode. If not you can explore that option.

Hope this helps.

Regds

[Jakes Louw]

Sanjay,
I assumed that he wanted a cold backup.
I still think that shutting the whole package for a backup is counter-productive.

[Sanjay_6]

Jakes,

It doesn't look like he is planning on a cold backup. If so then the idea of maintainence flag suggested by other forum members is a good one.

Thanks
Sanjay

[Rajesh SB]

Hi Folks,

I am looking for cold backup.
So that, planing to lock the database, before starting backup.
I am using QTIP/TQL database.

Thanks for your valualbe time spending on this issue.
We have decided to take backup by halting the application/Package.

Cheers,
Rajesh

[melvyn burnard]

There is a 3 day Advanced MC/ServiceGuard course, run by HP Customer Education, that has a module all about creating and using Maintenance Flags, and one of the labs used is to do this with an Oracle Database.
It might be worth atending this course, if it is available in your area.