NetApp Technology Network : Thread List - Databases & Enterprise Apps

FlexClone and Reporting Database

community@netapp.com — Tue, 12 May 2009 10:28:53 GMT

Guys

Fairly new to NetApp and have a question

We have a reporting database for a production system where the database is currently built from a backup of the production database via unix scripts

Id like to replace that using ONTAP tools like FlexClone. However I have a few questions

Can a specific clone be rebuilt at a scheduled time? i.e. rebuild the clone from the production database every 6 hours. Clone keeps same name and no database config changes are required
Whats the impact on the production database during cloning? (Cpu etc)
During the cloning do we need to take the database down or can this happen without outage?
Am I thinking on the right lines here or would we better with something like SnapMirror to keep the 2 database in synch. Thought clones would be better as its a read only database but if we have to take the instance off line via some sort og syncrhonised scripts im wondering if its worth it

Any best practice would be nice!

Release date for SMO 3.0.3?

community@netapp.com — Thu, 24 Sep 2009 02:10:26 GMT

Is there a release date for SMO 3.0.3? List of new features?

SMO cloning of Oracle database on an alternate host ?

community@netapp.com — Wed, 03 Jun 2009 20:53:56 GMT

i would like to have feedback from someone who performed SMO cloning for Oracle database (9i or 10g) on NFS protocol:

here is the use case:

A) install SMO on two AIX hosts : AIX 1 and AIX 2
B) create a clone with SMO 2.2 from a database that is running on AIX1 and then request SMO to mount the clone (all NFS mounts from qtrees) on AIX2
C) start the cloned database on AIX2

in this case, how can we start automtically the Oracle database on AIX 2 ? Does someone perform scripting for that case.

according to information i have , SMO will only mount NFS qtree on AIX2 from the clone but will not start and recover the Oracle Database in the clone

besides, SMO will not modifiy the TNSNAMES file and maybe other ORacle files.

any help is welcome.

SMO - Mirroring data subsets

community@netapp.com — Thu, 09 Jul 2009 09:03:21 GMT

Is there any way using SMO to run some sort of SQL script to limot the data mirrored to a date range?

Or another fancy way of doing this that avoids old school Oracle scripting?

SMO + DataGuard

community@netapp.com — Tue, 04 Aug 2009 14:54:15 GMT

Hi,

Found another thread that discussed overlaps and so between the different products but did not find a clear answer to my questions and thoughts.

I have a setup with a primary and a secondary datacenter with one Oracle server and one NetApp controller in each of them.

DataGuard is syncing data between the 2 datacenters

I have access to Protection Manager, I have SnapMirror and SnapVault licensed.

How do I create a smart backup setup in this environment?

Should I run SMO on both the primary and secondary DB servers with different retention policies?

Or just run SMO on the primary and let PM/SnapVault copy backups to the secondary DC and

not do anything on the DataGuard copy?

Any input is appreciated.

Thanks,

Erik Stjerna

Do the vol "minra" and "no_atime_update" apply in FC block Oracle environment ?

community@netapp.com — Fri, 20 Nov 2009 19:39:42 GMT

Hello all !!

Do the Flexvol options for minra and no_atime_update apply only to running Oracle on NFS from a Netapp, or do they still apply if you are presenting LUNs via FC to Oracle 10g (ASM) ?

Thanks

Dave

FR and space guaruntee on a SnapMirror volume

community@netapp.com — Wed, 18 Nov 2009 18:05:38 GMT

Hi,

Is it possible to set space guarantee to NONE on a snapmirror destination volume which has Fractional Reserve set to less than 100%??

Originally we had an SQL vol with FR set to 100% which we snapmirrored. The destination vol was not thin provisioned, and therefore every time we resize the source vol we have to also resize the destination.

However, now we have reduced the FR to 50% and enabled snap autodelete and vol autogrow - sounds good and works fine. But the problem is that if the vol autogrows, the source will be bigger than the target and snapmirror fails. My way around this was to set space guarantee to NONE on the target volume and thin provision it (so if the source autogrows, the target won't care as long as there is space in the agg).

I am having trouble configuring this though as I see that space guarantee apparently cannot be set to NONE if the FR is less than 100%??? (and when I try and do this on the destination volume it gives an error). Also, it seems that the FR setting gets copied from the source and has to be the same at both ends - so I can't change FR on the target to 100% without also changing it on the source?!

Anyone got any suggestions on the best way to manage this?

Or does the vol autogrow setting that we enabled on the source also mean that the snapmirror target will also autogrow automatically and therefore I don't have to worry about thin provisioning it? (I can't believe this would happen).

Help as always much appreciated!

Marc

Validate the SnapVault content for SMSAP

community@netapp.com — Sun, 01 Nov 2009 02:27:57 GMT

Hi there,

IHAC is using SMSAP for windows, all the data is on NetApp, even the OS is SAN booted. And the data is protected by SnapVault.

Now they want to check whether the SnapVaulted data can be used after restore.

Can we just FlexClone the data on SnapVaulted volume and mounted the LUN to the server to check whether the SAP can run smoothly?

Thanks,

Jeff

Invalid/Local Drive Snap Manager SQL

community@netapp.com — Fri, 25 Sep 2009 09:30:50 GMT

Hi,

I'm trying to do a Snapshot using Snap Manager for SQL on SQL 2005 IA64, we have 7 database spread to multiple disks with its drive letter (16 LUN), all LUNs are on NetAPP LUN (V-3160).

But when I start the snap manager for sql console, it shows that some of my Databases stated (Invalid/Local Drive ....), but all the drives are on NetAPP LUNs, why the snap manager didn't see that the database files are on netapp lun ?

please help.

Thanks in advanced.

Regards,

Arief Pribadi

Verification issues with SMMOSS and SMSQL

community@netapp.com — Fri, 23 Oct 2009 20:45:56 GMT

Anyone seen this error when running a backup via SMMOSS and SMSQL? I have verified that the SQL Cluster servers and the verification server are running the same versions of SMMOSS, SMSQL and Snapdrive:

-----------------------------------------------------------------------------------------------------

From: MOSSSNAPSQL@caridianbct.com [mailto:MOSSSNAPSQL@caridianbct.com]

Sent: Thursday, October 15, 2009 10:32 PM

To: Ernst, Teri

Subject: Backup status at [10-15-2009_22.31.53] from [USBSMOSSSQLV] - SnapManager for SQL Server

**** VERIFICATION RESULT DETAIL SUMMARY - JOB #1****

** BACKUP DATASET [#1] - [sqlsnap__USBSMOSSSQLV_10-15-2009_21.03.30]

#1 : [USBSMOSSSQLV - SharePoint_Config] : Skipped

#2 : [USBSMOSSSQLV - WSS_Content_Portal] : Skipped

#3 : [USBSMOSSSQLV - WSS_Content_MySites] : Skipped

#4 : [USBSMOSSSQLV -

SharePoint_AdminContent_3431fdc4-a4b8-4864-a04a-8ce550b0093a] : Skipped

#5 : [USBSMOSSSQLV - WSS_Content] : Skipped

**** VERIFICATION RESULT SUMMARY ****

Verification Group [#1]:

Error Code: 0xc0040830

The selected verification server has an older version of SnapManager installed. Please upgrade SnapManager on the verification server and retry the operation.

SMVI problems reading from VM datacenter

community@netapp.com — Thu, 22 Oct 2009 17:03:46 GMT

Hi,

Suddenly our SMVI application has stopped working in 1 of our installations and I cannot figure out why.

I can run the program, connect to my filers, but when I click on Backup I can only see the VMware datacenter name but no VMs (and the backup button is greyed out).

Also, we are getting the following errors in our Windows event log:

Event Type:    Error
Event Source:    SMVI
Event Category:    Error
Event ID:    4096
Date:        22/10/2009
Time:        15:15:04
User:        N/A
Computer:    BNK-VC01
Description:
3335716672 [backup1 050e3ac493066616903b67bdb66e07f8] ERROR com.netapp.common.flow.TaskInstanceTemplate - FLOW-11019: Failure in GetBackedupDatastoreList: Did not find any backedup datastore
java.lang.RuntimeException: Did not find any backedup datastore    at com.netapp.smvi.task.GetBackedupDatastoreList.execute(GetBackedupDatastoreList.java:58)    at com.netapp.common.flow.TaskInstanceTemplate.execute(TaskInstanceTemplate.java:281)    at com.netapp.common.flow.Operation.executeCurrentStack(Operation.java:132)    at com.netapp.common.flow.Operation.execute(Operation.java:52)    at com.netapp.common.flow.Threadpool$OperationThread.run(Threadpool.java:242)

Event Type:    Error
Event Source:    SMVI
Event Category:    Error
Event ID:    4096
Date:        22/10/2009
Time:        15:15:04
User:        N/A
Computer:    BNK-VC01
Description:
3335716672 [backup1 050e3ac493066616903b67bdb66e07f8] ERROR com.netapp.common.flow.Operation - FLOW-11008: Operation failed: Did not find any backedup datastore
java.lang.RuntimeException: Did not find any backedup datastore    at com.netapp.smvi.task.GetBackedupDatastoreList.execute(GetBackedupDatastoreList.java:58)    at com.netapp.common.flow.TaskInstanceTemplate.execute(TaskInstanceTemplate.java:281)    at com.netapp.common.flow.Operation.executeCurrentStack(Operation.java:132)    at com.netapp.common.flow.Operation.execute(Operation.java:52)    at com.netapp.common.flow.Threadpool$OperationThread.run(Threadpool.java:242)

Event Type:    Warning
Event Source:    SMVI
Event Category:    Warn
Event ID:    4096
Date:        22/10/2009
Time:        15:15:09
User:        N/A
Computer:    BNK-VC01
Description:
3335721828 [update-job1 acff7b51d94f19ec54e8be837801ce34] WARN com.netapp.smvi.task.schedule.ListJobAction - Did not find any jobs

Any ideas?

//M