{"id":5957,"date":"2016-09-07T17:06:32","date_gmt":"2016-09-07T07:06:32","guid":{"rendered":"http:\/\/nsrd.info\/blog\/?p=5957"},"modified":"2018-12-11T10:52:18","modified_gmt":"2018-12-11T00:52:18","slug":"backing-up-oracle-with-nmda","status":"publish","type":"post","link":"https:\/\/nsrd.info\/blog\/2016\/09\/07\/backing-up-oracle-with-nmda\/","title":{"rendered":"Backing up Oracle with NMDA"},"content":{"rendered":"

In previous posts I’ve talked about options around database backups \u2013 specifically whether you’d use a NetWorker module or say, DDBoost for Enterprise Applications<\/a>. There’s a lot of architectural positives towards having the database administrators in control of the backup, but sometimes you’ll want the backups to be controlled and coordinated by NetWorker. It could be your organisation doesn’t have DBAs on-staff and need backup administrators to have more hands-on control over the environment, or it could be you have a policy to fully integrate database backup and recovery operations within NetWorker.<\/p>\n

I’ve been going through a re-setup of my lab environment recently and today I wanted to spend a bit of time outlining how easy it is with NetWorker 9 (and NMDA v9) to configure Oracle backups, perform them, and do the recoveries as well \u2013 particularly if you’re a backup admin rather than a database admin.<\/p>\n

With a freshly installed Oracle 12 instance on CentOS 6.7, I went through the process of installing and configuring NetWorker backups.<\/p>\n

First you need to install the base NetWorker client package. (I always install the Extended client package for my lab servers, unless I’m specifically testing otherwise.) Once that’s been installed, you can install the appropriate NMDA package:<\/p>\n

\"01<\/a>
01 NMDA Plugin Install<\/figcaption><\/figure>\n

You’ll note at the end of the installation it tells you there may be additional postinstall steps to perform. I forgot to do that which generated an “oops” moment later \u2013 I’ll get to that at the appropriate time. But yes, there is a post-install operation you need to perform with Oracle databases.<\/p>\n

Anyway, with the plugin installed and NetWorker started on the client, I jumped over to NMC to configure database backups for this system using the wizard:<\/p>\n

\"02<\/a>
02 New Client Wizard 01<\/figcaption><\/figure>\n

Just choose “New Client Wizard” to start a step-by-step configuration process for Oracle backups for the newly installed system. The first thing you’re prompted for of course is the host name and what type of backup you’re intending to configure.<\/p>\n

\"03<\/a>
03 New Client Wizard 02<\/figcaption><\/figure>\n

Hitting next, you’ll have NetWorker interrogate the client software to determine what backup modules and options are available and you’ll get to pick what you want to do:<\/p>\n

\"04<\/a>
04 New Client Wizard 03<\/figcaption><\/figure>\n

And yes, it really is that simple \u2013 just select Oracle and hit Next.<\/p>\n

\"05<\/a>
05 New Client Wizard 04<\/figcaption><\/figure>\n

The above part of the wizard covers the absolute basics about the configuration, and unless you’re planning on backing up the database over DDBoost-FC, you’ll be fine to leave the options as they are. Click Next to continue.<\/p>\n

\"06<\/a>
06 New Client Wizard 05<\/figcaption><\/figure>\n

Here you get to choose between the three different backup options \u2013 a normal scheduled backup, a custom scheduled backup or a scheduled backup of disk backups \u2013 effectively allowing you to sweep up RMAN backups executed by the DBAs. In this case I wanted to go with the basics and kept it on Typical scheduled backup<\/em>. Next to continue.<\/p>\n

\"07<\/a>
07 New Client Wizard 06<\/figcaption><\/figure>\n

It’s on this form that you’ll definitely need a bit of an understanding of the Oracle setup. NetWorker managed to extract the Oracle home directory (presumably by interrogating \/etc\/oratab), but it needed me to specify the path to the tnsnames.ora directory. (That’s going to depend on your install of Oracle of course.)<\/p>\n

The wizard uses two different forms of authentication \u2013 OS authentication or database authentication. Because I’d just setup the database in a pretty basic way I went with OS level authentication. (The alternative is to ensure there’s a fully configured backup user within the database and to use the database authentication. This is actually the more appropriate way if you have DBAs on staff. If you’re working on your own you might want to stick with the more basic OS authentication.)<\/p>\n

So I supplied the username for Oracle (remember the base NetWorker client software runs as root\/administrator, so it can su to the appropriate account), and the SID for the database instance I was configuring backups for. Next<\/em>.<\/p>\n

\"08<\/a>
08 New Client Wizard 07<\/figcaption><\/figure>\n

You then get confirmation of the options that are going to be configured and the choice between going back, cancelling the wizard or creating the client instance. I clicked Create. At the end of the creation you’ll get information as to whether it was done successfully or not.<\/p>\n

Next up, it was necessary to create a new workflow for Oracle backups. I went to an Adhoc<\/em> policy I have defined for backups I don’t automatically run each day in my lab, and started the creation of a new workflow. The first dialog is as follows:<\/p>\n

\"09<\/a>
09 New Workflow 01<\/figcaption><\/figure>\n

This gives you the core details of the workflow \u2013 workflow name, when it executes, whether it automatically executes, etc. Name it how you need to, configure a Group consisting of the Oracle client(s) database backup instances, and then click Add<\/em> to add the backup action.<\/p>\n

\"10<\/a>
10 New Workflow 02<\/figcaption><\/figure>\n

Because this is a small database I elected to make every backup a full. If you talk to most DBAs you’ll find there’s a tradeoff between the space savings on incremental backups and the change of procedures for recoveries. (While most of those procedural changes are mitigated by backing up to disk, it’s quite common to have specific breakpoints in most environments between database backups that are full every day and those that get an extended fulls+incrementals configuration.)<\/p>\n

With the levels\/schedule set, I hit Next to move onto the next page of the dialog:<\/p>\n

\"11<\/a>
11 New Workflow 03<\/figcaption><\/figure>\n

It’s on this dialog you’ll choose what storage node will handle the backup, how long it will be retained for, and most importantly, what pool is will be sent to. I wanted mine to go to my DDVE system, so I switched the pool over from Default to one I’d created called BoostBackup<\/em>.<\/p>\n

Moving on by clicking Next:<\/p>\n

\"12<\/a>
12 New Workflow 04<\/figcaption><\/figure>\n

On the above dialog form you’ll get to define some more granular details about the backup process \u2013 how notifications are handled, number of retries, and overrides. I didn’t need to change anything here for what I was setting up, so I clicked Next to continue through the wizard to the Summary form.<\/p>\n

\"13<\/a>
13 New Workflow 05<\/figcaption><\/figure>\n

The summary of the new action was pretty much what I was expecting so it was time to Configure<\/em>.<\/p>\n

\"14<\/a>
14 New Workflow 06<\/figcaption><\/figure>\n

With the action successfully created I could click OK to finish working on the Workflow and jump across to the Monitoring tab to start the new workflow:<\/p>\n

\"15<\/a>
15 Start Workflow<\/figcaption><\/figure>\n

Right clicking the workflow and choosing Start will have you prompted for confirmation that you do want the job run now; once you’ve given that confirmation your backup should kick off.<\/p>\n

Except! Remember that bit where I said I was a bit of a doofus and didn’t<\/em> do the post-install configuration step? Well, I forgot to link the NetWorker module library to Oracle’s libobk.so file, meaning the job failed. Since however NetWorker saves the output of RMAN it was pretty easy to jump into the policy logs and see exactly what went wrong, viz.:<\/p>\n

\"17<\/a>
17 Oops My Mistake<\/figcaption><\/figure>\n

That RMAN\/Oracle error code and text tells the whole story there \u2013 unable to allocate a backup channel because there’s no linkage to an SBT_TAPE device type. (Remember with Oracle any external plugin: NetWorker, Avamar, DDBEA, NetBackup, etc. all slot in using Oracle’s SBT_TAPE device type. A legacy name from how we used to backup.)<\/p>\n

With that corrected by creating the appropriate symlink (which is of course completely documented in the NMDA install guide that I didn’t check!), the backup ran to completion, quickly<\/em>:<\/p>\n

\"18<\/a>
18 Successful Backup<\/figcaption><\/figure>\n

Now a backup is one thing, but recoveries are the real crux of the matter! And Oracle recoveries can be completely performed within NMC these days using the NMC Recovery interface. While your DBAs might want to run the recovery from the Oracle server if they’re available, empowering backup administrators to craft recovery processes when there are no DBAs available is just as useful.<\/p>\n

Warning<\/strong><\/span>: I’m working through an example<\/strong> recovery scenario. You should <\/span>not<\/strong><\/em><\/span> follow this blindly if you’re using it in your environment. This is a lab test only. Always adapt your recovery process to the activities and recovery requirements at hand, and always work with the appropriate documentation, processes and know-how!<\/span><\/p>\n

\"19<\/a>
19 NMC Recovery 01<\/figcaption><\/figure>\n

The first step is to choose the host you want to recover (in my case, dbase1<\/em>), and choose the type of recovery you want to configure (Oracle). Hit Next<\/em> to continue.<\/p>\n

\"20<\/a>
20 NMC Recovery 02<\/figcaption><\/figure>\n

Your options are pretty straight forward here \u2013 recover to a duplicate database instance, or recover to the original database. I chose to do an original database recovery and clicked Next.<\/p>\n

\"21<\/a>
21 NMC Recovery 03<\/figcaption><\/figure>\n

This dialog is pretty similar to that backup configuration dialog I showed earlier \u2013 provide the appropriate configuration details for the database and the authentication method required.<\/p>\n

\"22<\/a>
22 NMC Recovery 04<\/figcaption><\/figure>\n

You get an option between just recovering specified archived redo log files, or the entire database\/specific database elements. I was doing a full recovery so I kept with the default selection and clicked Next.<\/p>\n

\"23<\/a>
23 NMC Recovery 05<\/figcaption><\/figure>\n

Here you get to choose what specific tablespaces\/data files you want to recover. This is particularly handy if you’ve say, had a single tablespace accidentally deleted and just need to recover that. Again, I wanted to recover everything so I clicked Next to continue.<\/p>\n

\"24<\/a>
24 NMC Recovery 06<\/figcaption><\/figure>\n

Unless you’re working with a DBA who says otherwise, or have already got the database in a startup\/mount mode, you’ll likely want to click Yes here to have NetWorker handle that for you.<\/p>\n

\"25<\/a>
25 NMC Recovery 07<\/figcaption><\/figure>\n

Here I got the choice to recover datafiles to alternate locations; I left them as-is and clicked Next.<\/p>\n

\"26<\/a>
26 NMC Recovery 08<\/figcaption><\/figure>\n

Here’s where you choose how many channels you want to use for the recovery, when<\/em> you want to recover to, and whether you want the database automatically started at the end of the recovery process.<\/p>\n

Once you’ve worked through those options, NMC will show you the RMAN recovery script it’s created, and give you the option to edit it:<\/p>\n

\"27<\/a>
27 NMC Recovery 09<\/figcaption><\/figure>\n

(You can even save a copy of the RMAN script in case you want to reference it later, or hand it over to the DBA to complete.)<\/p>\n

Clicking Next, you’re invited to confirm storage node details and optionally change the volumes to be used for the recovery:<\/p>\n

\"28<\/a>
28 NMC Recovery 10<\/figcaption><\/figure>\n

Once you click past here you can give the recovery a name and choose to start it:<\/p>\n

\"29<\/a>
29 NMC Recovery 11<\/figcaption><\/figure>\n

As soon as you click “Run Recovery” the recovery process will start. Here’s a few dialogs showing output during the recovery process:<\/p>\n

\"30<\/a>
30 NMC Recovery 12<\/figcaption><\/figure>\n
\"31<\/a>
31 NMC Recovery 13<\/figcaption><\/figure>\n

And the completed recovery:<\/p>\n

\"32<\/a>
32 NMC Recovery 14<\/figcaption><\/figure>\n

There you have it. A complete Oracle configuration, backup and recovery.<\/p>\n

(As I said before, that’s a lab recovery \u2013 if you’re actually<\/em> doing a recovery while the steps may be the same, you still need to customise for your database, so make sure you perform any recovery as appropriate for your environment and circumstances.)<\/p>\n

Overall though it’s fair to say that Oracle backup and recovery with NetWorker is simple and straight-forward.<\/p>\n","protected":false},"excerpt":{"rendered":"

In previous posts I’ve talked about options around database backups \u2013 specifically whether you’d use a NetWorker module or say,…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5,9,16,19],"tags":[286,1278,706,707],"class_list":["post-5957","post","type-post","status-publish","format-standard","hentry","category-backup-theory","category-databases","category-networker","category-recovery","tag-database","tag-nmda","tag-oracle","tag-oracle-module"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKpIN-1y5","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/5957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/comments?post=5957"}],"version-history":[{"count":6,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/5957\/revisions"}],"predecessor-version":[{"id":7407,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/5957\/revisions\/7407"}],"wp:attachment":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media?parent=5957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/categories?post=5957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/tags?post=5957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}