topic Re: SnapShot/Flexclone/SnapManager for Oracle in ONTAP Discussions

SnapShot/Flexclone/SnapManager for Oracle

netappmagic — Wed, 04 Jun 2025 23:36:07 GMT

We wantora_infoednonprd_bkp ed to create a copy of a Prod Oracle database, and use the copy for reports. The following is my question:

1. Could it be achived by using SM for Oracle, and eseential it is using Flexclone. Correct?

2. Without SM for Oracle, can I only use Flexclone to do that? If yes, how? and how to resolve the consisitency issue beween logs and datafiles?

Thank you very much for your inputs.

Re: SnapShot/Flexclone/SnapManager for Oracle

deepuj — Thu, 06 Aug 2015 10:26:38 GMT

Hi,

You are correct, If you need to have a application consistent copy of the database you need to create a clone from SMO.

Normal flexclone will not be application consistent.

Thanks

Re: SnapShot/Flexclone/SnapManager for Oracle

netappmagic — Thu, 06 Aug 2015 10:55:21 GMT

what if I put Orace DB in Hot backup mode or stop writting to DB before flexclone all related Oracle volumes together? Are there any workaround by using flexclone instead of SMO

Re: SnapShot/Flexclone/SnapManager for Oracle

deepuj — Fri, 07 Aug 2015 08:27:46 GMT

Hi,

you may be able to do a app consistent using RMAN, but we strongly recommend to use SMO for application consistent clone.

As I mentioned before, direct flexclone will not be app consistent.

Thanks

Re: SnapShot/Flexclone/SnapManager for Oracle

netappmagic — Sat, 08 Aug 2015 12:51:28 GMT

In hot backup mode, then do flexclone to all DB volumes involved, will that cause inconsistency as well?

Could you please tell me a little bit of more on using RMAN to keep the consistency, how?

Thanks!

Re: SnapShot/Flexclone/SnapManager for Oracle

netappmagic — Fri, 14 Aug 2015 11:09:44 GMT

Please share your experience to ensure Oracle database consistency when using Flexclone to clone DB.

for instance, what steps to take to use RMAN to keep DB consistency?