#Not supported to restore Oracle DB to the other host?

1 messages · Page 1 of 1 (latest)

frail turret
#

Upon the document:
Oracle: https://www.netapp.com/pdf.html?item=/media/12403-tr4700.pdf

The unsupported Oracle features, file systems, and platforms include:
• Oracle Transparent Data Encryption (TDE) deployments that are not auto-login mode
• Restore to alternate host

  1. The document was updated on 2021, are these two still not supported?
  2. What if I create the clone on an alternate host, will that be supported?
SnapCenter Plug-In for Oracle Database Best Practices | NetApp

Best practices for using SnapCenter Plug-In for Oracle database

feral cradle
#

Those two items are still unsupported. As you correctly guessed in the second point, a restore to an alternate location is basically the same as a clone. I haven't come across an instance where a clone cannot be used in the same fashion.

frail turret
#

Sorry , I am not sure I understand what you said. Are you saying that I cannot create a clone of a Oracle DB to an alternate host?

feral cradle
#

That's not what I was intending to say, What I was intending to say is
Restore to alternate location == Clone

frail turret
#

We have been using SnapCreator to clone a DB to an alternate host for reporting/dev purpose, as you know of, since SnapCreator is based on ZAPI which will be gone from ONTAP soon. As we know SnapCenter Oracle plug-in is the only option to use for the same purpose. So, we cannot use it to achieve the same purpose?

feral cradle
#

You can clone to an alternate host with SnapCenter for Oracle.

frail turret
#

Thanks! 2 follow-ups:

  1. Do I have to know details on REST API, in order to implement SnapCenter for Oracle?
  2. Since TDE not auto-login mode is not supported, is there any alternate encryption I can use, for instance, NetApp Volume Encryption for the same purpose?
feral cradle
#
  1. You don't have to know any details on REST vs. ZAPI. SnapCenter will ask for your storage credentials and then take care of it from there. The change from ZAPI to REST is already underway in SnapCenter.
  2. I'll have to look this up and let you know more.
frail turret
#

Yes, Please get back to me on my 2nd question.
Also, we use a lot of scripting currently with SnapCreator. With SnapCenter Oracle, does it give us the same flexibility? I konw it can do pro-scripting or post-scripting, but, I am just not sure if it can reach to the same level as SnapCreator can allow us to.

feral cradle
#

In the same TR-4700 you linked above, NetApp Volume Encryption (NVE) is listed in the supported features.

#

There are 2 ways to handle scripting with SnapCenter for Oracle.

  1. There is an sccli utility (SnapCenter command line interface) that allows for running operations against SnapCenter for Oracle resources. These commands can be scripted in much the same way as Snap Creator commands were used.
  2. There are REST APIs that can be used to run operations against SnapCenter resources.

Scripting commands vs. APIs are a bit different from each other, but both give similar results. It's an issue of what yourself or your admins are familiar with.