Data Backup and Recovery

SMO Performance

michaeldparker

Hi All,

We use SMO to on Linux to protect our Oracle 10gR2 DB.  In the past, the average for SMO to put the DB in hotbackup and initiate the snap was about 12 minutes.  As of 12/1, the time has jumped up to an average of 1hr,20minutes.  Can anyone provide some insight on how to troubleshoot this performance problem.

Thanks

Michael

1 REPLY 1

jcosta

Hi Michael,

first open a support case with netapp to help you troubleshoot it, they'll ask you to create a diagnostic file of the backup that is taking a long time, as well as the nSanity output from both the servers and the controllers.

to create the SMO diag, right-click over the backup and choose create diagnostics.

to create the nSanity, go to the NOW website, click on toolchest and look for nSanity.

step 2, is to look into the logs and find out if SMO is taking longer on database operations, or during snapdrive operations.

you can find the logs for smo under /var/log/smo

and for snapdrive in /var/log/sd-trace.log (it gets recreated every time sdu is executed)

also if you're in an ITIL kind of organization check if any changes were logged against that server around the 1/12,

Announcements
Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public