BCV Split

[caj]

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

[RK_7]

Hi Ajeesh,

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

Regards,

[caj]

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

[Siddhartha M]

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

[Shahul]

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

[Zinky · Accepted solution]

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..

[Dave La Mar]

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

[caj]

Thanks everybody ,

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