AFAIK dNFS was introduced in Oracle 11g (September 2009).

If this is really an Oracle 8i (August 2000, EOS Extended 2006), it doesn't have dNFS available.

You might want to check ancient TRs also and/or just make sure, the instructions apply to your version...

Sebastian

On 15.07.2020 15:54, Tim McCarthy wrote:

Use Oracle’s DNFS client. Should be okay I would think.

Get Outlook for iOS https://aka.ms/o0ukef

*From:* Toasters toasters-bounces@teaparty.net on behalf of André M. Clark andre.m.clark@gmail.com *Sent:* Wednesday, July 15, 2020 9:39:13 AM *To:* toasters@teaparty.net toasters@teaparty.net *Subject:* HP-UX NFSv3 and ONTAP I have a client that has an old HP-UX (11.23) server that currently has FC mounts to an even older CX3. It has already been ruled out on moving this workload to FCP on their ONTAP cluster (9.6P3) as the system is outside of the IMT. What I am proposing to them is moving this workload over to NFS and see if it would meet the very low application requirements. The main workload is an Oracle 8i (8.17) database that has extremely low transactions.

My question is are there any gotchas or specific settings that should be employed regarding NFS mounts and HPUX? I have reviewed TR-4067 (quickly) and KB and the two items that stuck out (qtree exports and NFSv4) are items that I was not proposing on using. Anything else to be aware of?

Many thanks in advance

Regards, André M. Clark

---

Toasters mailing list Toasters@teaparty.net https://www.teaparty.net/mailman/listinfo/toasters

Jeff and Tim,

Thanks for your quick responses. I am actually reviewing TR-3633 right now. Any other tips regarding data protection and replication? I know SnapCenter is not an option; is SnapCreator still a possibility? Minimally they are looking to do SnapMirrors to a DR system throughout the day and consistent Snapshots, while not a requirement, would be a plus. They already have a procedure where they shut down the database nightly to perform a cold backup but if we can provide any improvements on this it would be a win.

Regards, André M. Clark

On July 15, 2020 at 09:58:38, Jeffrey Steiner, (jeffrey.steiner@netapp.com) wrote:

I personally managed servers as old as HP-UX 11.11 with Oracle running in NFSv3 exports from ONTAP. No problems.

Make sure you read https://www.netapp.com/us/media/tr-3633.pdf for a few things about TCP/IP, ethernet, and mount options.

*From:* Toasters toasters-bounces@teaparty.net *On Behalf Of *André M. Clark *Sent:* Wednesday, July 15, 2020 8:39 AM *To:* toasters@teaparty.net *Subject:* HP-UX NFSv3 and ONTAP

*NetApp Security WARNING*: This is an external email. Do not click links or open attachments unless you recognize the sender and know the content is safe.

I have a client that has an old HP-UX (11.23) server that currently has FC mounts to an even older CX3. It has already been ruled out on moving this workload to FCP on their ONTAP cluster (9.6P3) as the system is outside of the IMT. What I am proposing to them is moving this workload over to NFS and see if it would meet the very low application requirements. The main workload is an Oracle 8i (8.17) database that has extremely low transactions.

My question is are there any gotchas or specific settings that should be employed regarding NFS mounts and HPUX? I have reviewed TR-4067 (quickly) and KB and the two items that stuck out (qtree exports and NFSv4) are items that I was not proposing on using. Anything else to be aware of?

Many thanks in advance

Regards,

André M. Clark

Thanks again all for these tips. I am working with my client in setting up the environment to test everything out.

Regards, André M. Clark

On July 16, 2020 at 07:21:47, Walfherder (toasters@tson.de) wrote:

On 15 Jul, André M. Clark wrote:

... Any other tips regarding data protection and replication? I know

SnapCenter

is not an option; is SnapCreator still a possibility? Minimally they are looking to do SnapMirrors to a DR system throughout the day and

consistent

Snapshots, while not a requirement, would be a plus. They already have a procedure where they shut down the database nightly to perform a cold backup but if we can provide any improvements on this it would be a win.

Oracle 8 is quite old, I think it probably pre-dates things like SnapCreator, SnapCenter ... probably anything other than Snapshots :).

I once did something similar i.e. implemented hot backups of a running Remedy AR System database on Oracle 8 on ONTAP.

As far as I can recall there was a NetApp Whitepaper or TR describing how to implement this so that the backup was consistent at the database level and could be recovered from, but I cannot locate that doc now.

Basically it is pretty simple, you need to script the following:

1. Check that the Oracle instance is running/available

2. Tell Oracle to place all the tablespaces that are to be backed up into backup or "archive log mode"

3. Tell Oracle to dump the currently "active" contents of its redo logs to its archives

4. Make a backup of the instance control file

5. Tell Oracle to write a set of instance re-creation statements to its trace file

6. Connect to the NetApp and create a new Snapshot of the volume(s) where the Oracle data is stored

7. Tell Oracle to take the tablespace back out of backup mode

8. Log the results

Most of those steps are fairly simple SQL commands. You run the above a couple of times a day and the NetApp snapshot which get created contain everything needed to restart/recreate the Oracle instance at the time that they were created.

You should backup the archived redo logs, but not the live/current redo logs. It's not a problem to back these up, but it doesn't bring any benefit and during a restore you might accidentally overwrite the current versions. Which would be bad.

Cheers, Robb.