Could Veritas's checkpoint(for Oracle) to be a CLONE DB?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dominica@gmail.com - 17 Dec 2005 00:41 GMT

Hi All,

Let me try to phase my question better.

My goal is to do this:

I use Veritas's storage foundation to do checkpoint on Oracle(online
checkpoint.
Almost like doing snapshot in NetApp).

But my co-worker (system admin) is suggesting that we use the
checkpoint of Veritas on Oracle and mount that filesystem(the one
created by
checkpoint) to a different host
(not the production host that I make my checkpoint from) and open those
oracle datafiles to be the test oracle instance and then use it for
"testing" purpose(for QA people).

I am trying to look for white paper from Veritas 's site.
I could not find it.

Anyone out there is using Veritas's checkpoint...??

Hardware: I am using 64 bit solaris 5.9 , Oracle 8.1.7.4 32 bit.

Thank,

Dominica

Reply to this Message

hpuxrac - 17 Dec 2005 01:06 GMT

> Hi All,
>
[quoted text clipped - 5 lines]
> checkpoint.
> Almost like doing snapshot in NetApp).

I am not familiar with NetApp but this is a pretty common technique
with EMC based DASD and sure probably NetApp works similarly.

Lots of people do "split mirror" backups via rman or other (manual
based) techniques.

You need a DASD set that when you do the "split" or checkpoint or
whatever that takes effect at the time on all the DASD volumes
simultaneously.

On EMC this is known as an instant split.

You can probably put the tablespaces into backup mode and then do the
"split" or checkpoint and as your system admin suggested mount and
bring up oracle on a different host.

Your veritas support person should be able to supply a white paper or
more doc.

> But my co-worker (system admin) is suggesting that we use the
> checkpoint of Veritas on Oracle and mount that filesystem(the one
[quoted text clipped - 6 lines]
> I am trying to look for white paper from Veritas 's site.
> I could not find it.

Please see above.

> Anyone out there is using Veritas's checkpoint...??

Not working at a Veritas site anymore.

> Hardware: I am using 64 bit solaris 5.9 , Oracle 8.1.7.4 32 bit.

You software is a little on the aged side but still this type of
technique can be viable if properly researched, documented, and tested.

> Thank,
>
> Dominica

Reply to this Message

dominica@gmail.com - 17 Dec 2005 02:01 GMT

Hi Hpuxrac,

Yes,
you are right,
my current work's software is kind of old.
I am working on the upgrade to 8.1.7.4 to oracle 10g r2 in March,06
(this is planning).

Thank you for your response.
Yes, I used to use EMC and Netapp. Both of those could easily do it.

Somehow, I just don't know the Veritas checkpoint(online ) on oracle
that well.

Reply to this Message

Zhu Chao - 31 Dec 2005 08:05 GMT

using veritas checkpoint, it is still one single copy of the datafiles.

In order to minimize the impact on the production, after you mount the
ckpt filesystem, you'd better copy from this checkpoint andd then
remove the checkpoint.

Reply to this Message

IANAL_VISTA - 31 Dec 2005 15:29 GMT

> using veritas checkpoint, it is still one single copy of the datafiles.
>
> In order to minimize the impact on the production, after you mount the
> ckpt filesystem, you'd better copy from this checkpoint andd then
> remove the checkpoint.

OK. Educate me.
What command is issued to "remove the checkpoint"?

AFAIK, a CHECKPOINT occurs at a single point in time & has ZERO duration.

Reply to this Message