Absent Member.
Absent Member.
2015 views

Split BCV Backups

Jump to solution
We have SAP R/3 on oracle. Database is located on an EMC symmetrix.

We want to implement split BCV backups, but are unsure of the process. None of the documentation seem to provide you with a clear understanding on how it works. Installing the EMC integration only gives us the SPLIT command.

Both EMC and HP want to sell us additional software to handle the BCV split.

Is there anyway I can script this myself. I've used symmtools before to create and split bcv's but in those cases i unmounted the filesystems so all the buffers were flushed.

How do you safely split a bcv for an on-line backup without screwing up the filesystem on the bcv?

I was thingking of scripting the following
1) alter all tablespaces backup
2) switch oracle logs
this takes care of oracle, but not the filesystem buffers

3) split the bcv
4) mount the disks under temp filesystems
5) do a filesystembackup of the temp filesystems
6) unmount and re-create the bcv

Any ideas ?
John
0 Likes
1 Solution

Accepted Solutions
Absent Member.
Absent Member.
Hi John

We have this implemented acroos the same server, now here is what we do

1. Create BCV groups using PV and BCV
2. Merge them to the PV groups.
3. Take the database into backup mode.
4. Split the BCV's
5. Take the backup out of backup Modes.
6. remount teh BCV's
7. Take the backups.

I have detailes scripts for the same ,in case you want I can help you with the issue.


Manoj Srivastava

View solution in original post

9 Replies
Fleet Admiral
Fleet Admiral
Hi,

IIRC then there was a lot of documentation available on the SureStore pages of hp...

And to use split BCVs on the same HP-UX station you *must* use the command "vgchid" before using *vgchange* to activate any of them!
HP-UX would see all the disks of the split-off BCVs as belonging to the very same VG - and that would destroy everything...

HTH,
Wodisch
0 Likes
Absent Member.
Absent Member.
John,

Sure you can script it yourself... but you may end up with a hand crafted solution that is complex to maintain and clumsy to use. The advantage of the off-the-shelf solutions is that they integrate in a much tighter way with your enterprise backup product, and are therefore easier to support. Take a look at the documentation here on using BCVs with the SAP integration component of OmniBack...

http://ovweb.external.hp.com/ovnsmdps/pdf/b6960-90053.pdf

HTH

HTH

Duncan
0 Likes
Absent Member.
Absent Member.
Hi John

We have this implemented acroos the same server, now here is what we do

1. Create BCV groups using PV and BCV
2. Merge them to the PV groups.
3. Take the database into backup mode.
4. Split the BCV's
5. Take the backup out of backup Modes.
6. remount teh BCV's
7. Take the backups.

I have detailes scripts for the same ,in case you want I can help you with the issue.


Manoj Srivastava

View solution in original post

Absent Member.
Absent Member.
HI

You surely can create your own scripts to split-mount-sync bcvs.

- Split the bcvs using bcv commands (part of EMC timefinder software)
- modify VGID of bcvs (see man vgchgid)
- import BCV in to new volume groups
- mount BCVs
- run backup
- umount and export bcvs
- sync bcvs.

You will have to do error checking at each step to make sure all bcvs are split and mounted before backup starts.
If you use readymade packages or integrations this might be part of package.

Thanks.
Prashant Deshpande.
Take it as it comes.
Absent Member.
Absent Member.
Hi

Here is the process I use when setting up BCV backups, we always usually script this as it saves using the integration packages to Omniback or Legato which do virtually exactly the same, but for a nice price.

------

I always like to mount BCV's on a seperate dedicated backup server, as this takes the load of the production host/s, but this is not a pre-requisite.


So on my dedicated backup host

establish Symm device groups
switch Oracle redo log
backup Oracle control file
DB Tablespaces into Begin Backup Mode
split Symm device groups
DB tablespaces into End backup Mode
switch Oracle redo log

Import BCV devices into HPUX volume group
(need to use 'vgchgid, vgimport)

fsck lvols
mount lvols


Backup lvols using whatever method (omniback / networker / fbackup)

----

I always leave lvols mounted until next run of script as this is my first port of call for restore purposes.

Hope this help

regards

Chris







Absent Member.
Absent Member.
Scripting everything is not a problem. I've done this before, but when i do it manually i umount the filesystem before i split it. How can i guarantee the the filesystem im splitting off will be in a usable state and not in the middle of a massive write.

It doesnt matter is the datafile is inconsistent within the database, as i can use redologs to fix that up, but the filesystem is another problem all together. It seems splitting a mounter filesystem is looking for trouble as you have no way of making sure that your buffers a flushed.

Any ideas ?
0 Likes
Absent Member.
Absent Member.
HI
Your bcv file systems will not be mounted when syncing.
So either shutdown database or switch to backup mode and then split the bcvs.
While syncing back use fuser command to make sure bcv file system is not in use.

Thanks.
Prashant.
Take it as it comes.
0 Likes
Absent Member.
Absent Member.
Hi ,
can you please provide me with the detailed commands of spliting the bcv device and how i could remount them on the same host but under another mount point ?

or can you point me to a good resource discussing the details commands

thanks
0 Likes
Absent Member.
Absent Member.
If any one aware of this , there is a EMC perl script used to take the BCV backups and named hpux_backup ,


Here is the heading:
--------------------------

# bcv_backup
#
# $Id: hpux_backup,v 1.3 2003/03/24 20:03:36 root Exp $

...
---------------------------

Also there is a script final_final_wrapper script , that can be used with the folowing parameters :

# Three options :
#
# 1. BOTH: prebcv (shutdown src DB)
# hpux_backup(bcvmgr) does bcv synch,src DB shut/start, bcv split
# postbcv
#
# 2. SYNCH: prebcv
# hpux_backup(bcvmgr) -e : does bcv synch only - src db running.
#
# 3. SPLIT: trgt DB is down (bcvs should be synched)
# hpux_backup(bcvmgr) does bcv synch,(in this state ) src DB shut/start, bcv split
# postbcv (start target DB)
#
----------------------------------------




Appreciate if any one can add, further details about EMC bcv backups.

Thanks,
Raj.
" If u think u can , If u think u cannot , - You are always Right . "
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.