topic Re: BCV Split in Operating System - HP-UX

BCV Split

caj — Thu, 23 Mar 2006 01:37:51 GMT

Hi all ,

Could pls confirm we can go ahead and split a fully synced BCV when Oracle is up and runnig .
I am not sure It will harm the Oracle DB when we do a BCV split when Oracle IS up .

Waiting for your replay

Thanks
Ajeesh

Re: BCV Split

RK_7 — Thu, 23 Mar 2006 01:54:40 GMT

Hi Ajeesh,

You should put oracle in backup mode before BCV split.otherwise BCV Copy wont be a consistent one.

Regards,

Re: BCV Split

caj — Thu, 23 Mar 2006 02:16:08 GMT

Hi RK ,

Thanks for the immediate response ,

Yes your are correct .

My question is ,if i do a BCV split ,will it create any problem /alert on the running oracle DB on the source server . Right now I won't be able to shutdown the running oracle . But i required this BCV copy on the other end to duplicate newly created VG on the BCV server .

Thanks
Ajeesh

Re: BCV Split

Siddhartha M — Thu, 23 Mar 2006 04:35:16 GMT

Ajeesh,

If you want a cold backup of your Oracle instance, Oracle should be shut down before
you proceed for split backup.

If you want a hot backup of your Oracle instance, you need to put your oracle tablespaces into backup mode,
[ use: alter tablespace begin backup;]
split the BCVs and then end the backup mode
on the tablespaces.
[use:alter tablespace end backup;]
Oracle will keep running in this case without any errors.
The results of the above two operations..begin and end backup for each tablespace will be logged into the instance alert.log file

Re: BCV Split

Shahul — Thu, 23 Mar 2006 07:12:50 GMT

I don't think you will get an aerror when you split. I can't surely say about this, because I never seen some one doing so. The normal practice is

Put the database in hot backup mode (This will not stop your service), then split BCV, and then take back the database from hot backup mode.

Best of luck
Shahul

Re: BCV Split

Zinky — Thu, 23 Mar 2006 09:00:59 GMT

When you do a split, your OS application or you won't even notice it since it is an "in-array" activity. So your kernel/filesystems, etc will not care a bit what is going on inside the array.

When applied to Database storage though, the database will need to be quiesced (for a cold copy/split) or in "hotbackup mode" (for a hot split/copy).

Hope this helps..

Re: BCV Split

Dave La Mar — Thu, 23 Mar 2006 10:42:28 GMT

Ajeesh -
Just a couple of thing to note if you split on an active file system:

1. No harm, no foul to the running Oracle application.
2. The BCV logical volumes will be corrupt so you will need to perform an fsck before mounting the BCV elsewhere.
3. The Oracle application on the BCV will be trash. To get a good copy and not corrupt the logical volume, it is best to have the oracle application down and the primary volumes umounted at the time of the split.
You don't say whether this is Raid Manager or Command View type BCV, but the scenario is quite the same.

If XP512 with Raid Manager, the volumes should be 100% sync'd prior to split. EVA snapshots and snap clones need not wait for 100%.

All that said, except for the Oracle instance, the BCV, themselves, can be mounted up with just an FSCK on each prior to the mount.

Best of luck with this and hang in there, this is not rocket science.

Regards,

-dl

Re: BCV Split

caj — Fri, 24 Mar 2006 02:08:54 GMT

Thanks everybody ,

I have Splited the BCV and imported all Newley created volume in to the BCV server .Everything looks good .