{"id":10824,"date":"2022-03-07T08:25:14","date_gmt":"2022-03-06T22:25:14","guid":{"rendered":"https:\/\/nsrd.info\/blog\/?p=10824"},"modified":"2022-03-07T08:25:18","modified_gmt":"2022-03-06T22:25:18","slug":"oracle-and-powerprotect-data-manager","status":"publish","type":"post","link":"https:\/\/nsrd.info\/blog\/2022\/03\/07\/oracle-and-powerprotect-data-manager\/","title":{"rendered":"Oracle and PowerProtect Data Manager"},"content":{"rendered":"\n

I recently wanted to check out some PowerProtect Data Manager options with Oracle, and so I found myself spinning up a temporary test server running Oracle 19c. <\/p>\n\n\n\n

To get cracking on this, installed Oracle 19.c on a CentOS Stream 8 host, then downloaded the Oracle RMAN agent documentation for Data Manager 19.9<\/strong><\/a> and started working through the process.<\/p>\n\n\n\n

So, what’s involved?<\/p>\n\n\n\n

You’ll start by downloading the Oracle agent. You don’t need to go to the support website for that — agent downloads are accessible directly from within the Data Manager administration console by clicking on the Gear icon:<\/p>\n\n\n\n

\"Accessing<\/a>
Accessing the Oracle agent download in PowerProtect Data Manager<\/figcaption><\/figure>\n\n\n\n

Having downloaded the agent, transfer it across to the Linux host you’re going to install it on and unpack it in the oracle <\/strong>user’s home directory.<\/p>\n\n\n\n

\"Directory<\/a>
Directory listing of the PowerProtect Data Manager Oracle Agent Package<\/figcaption><\/figure>\n\n\n\n

You’ll notice in addition to an install.sh executable, there’s also a powerprotect-agentsvc-19.9.0.0.0-1.x86_64.rpm<\/em> file. You’ll install this first as the root user to provide an agent-level connection between the host and the Data Manager server. After that’s done, as the oracle user you can run the install.sh script. (This process is documented in the Oracle RMAN guide for Data Manager that I linked to in the introduction.)<\/p>\n\n\n\n

Once you’ve registered the system against Data Manager and approved the asset registration from within Data Manager, it’ll appear as an Oracle asset source:<\/p>\n\n\n\n

\"Oracle<\/a>
Oracle Asset Source for PowerProtect Data Manager<\/figcaption><\/figure>\n\n\n\n

To discover the databases on the host, click the radio button for the newly added asset and click the ‘Discover’ button to start an immediate discovery job. You can monitor this in the Jobs panel if you’d like:<\/p>\n\n\n\n

\"Oracle<\/a>
Oracle asset discovery job complete<\/figcaption><\/figure>\n\n\n\n

With the discovery complete, the Data Manager assets page then shows the database on my Oracle server:<\/p>\n\n\n\n

\"Oracle<\/a>
Oracle Asset Discovered<\/figcaption><\/figure>\n\n\n\n

OK, so with the agent installed and activated, and the database on the system discovered, the next step is to create an actual backup policy. (Normally of course you’d put more than one database server into a policy, but in this case, I’ve only got one.) So here’s the sequence I went through for a new policy. Under Protection > Protection Policies I clicked the Add button to start the process:<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager policy, step 1<\/figcaption><\/figure>\n\n\n\n

I gave the policy a name and selected the ‘Oracle’ type before clicking Next.<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager policy, step 2<\/figcaption><\/figure>\n\n\n\n

On the second step, you’re prompted to confirm whether this is a centralized policy (one that Data Manager will run for you), a self-service policy (where the DBAs will run the backups themselves), or an exclusion policy (which prevents elements of an environment being added by other policies when you don’t want them protected). For this, I chose a Centralized Policy, and clicked the Set Credentials<\/strong> button to provide Data Manager with authentication details. There are a few different options for credentials, but I went with the simplest — providing that of the oracle user itself. (In a production environment, you’ll likely choose database credentials or wallet instead.)<\/p>\n\n\n\n

\"Setting<\/a>
Setting OS-level credentials for Oracle backups<\/figcaption><\/figure>\n\n\n\n

If you’re using an RMAN catalogue, you can provide the credentials for it in the screen above. For my testing I wasn’t, so after adding the credentials I clicked Save to return to the policy wizard and progress to the next screen.<\/p>\n\n\n\n

The next step is to choose the assets — i.e., the databases — you want to protect. In my case, just a singular database, ‘pmdg1’:<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager policy, step 3<\/figcaption><\/figure>\n\n\n\n

The next step is to choose the backup schedule. I’ll start with a basic one and show you a mixed model at the end. Here I’m aiming for a full backup once a day, and keeping the backup for 14 days:<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager Policy, step 4<\/figcaption><\/figure>\n\n\n\n

It also helps to make sure you have a copy of your backup, so I configured a replication policy with a 14 day retention period, too:<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager Policy, step 5<\/figcaption><\/figure>\n\n\n\n

The resulting configuration looked like this:<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager Policy, step 6<\/figcaption><\/figure>\n\n\n\n

(No need to set an SLA, since it’s a centralized backup policy and therefore the policy definition is effectively an SLA. I recommend SLA definitions in situations where you’re using self-service backups, since they provide guard-rails on the people running the self-service backups.)<\/p>\n\n\n\n

Before wrapping up the policy, you have some extra options for Oracle:<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager Policy, step 7<\/figcaption><\/figure>\n\n\n\n

In this case, I set the files per set to 4, and elected to delete archived redo logs older than 7 days as part of the backup process.<\/p>\n\n\n\n

\"Creating<\/a>
Creating an Oracle PowerProtect Data Manager Policy, step 8<\/figcaption><\/figure>\n\n\n\n

Once I was happy with the settings, I saved the policy and elected to run it immediately.<\/p>\n\n\n\n

And of course, dummy that I was, I’d forgotten when I installed the Oracle database server to enable archive logging (i.e., live backups) on the database — so the backup initially failed! That sent me to the command line on the client to log on as the Oracle user, connect to the database and run:<\/p>\n\n\n\n

  1. shutdown immediate<\/li>
  2. startup mount<\/li>
  3. alter database archivelog<\/li>
  4. alter database open<\/li><\/ol>\n\n\n\n
    \"(Oopsie.)\"<\/a>
    (Oopsie.)<\/figcaption><\/figure>\n\n\n\n

    With that done, I re-ran the protection policy and it completed successfully, but gave me an alert in the job status because the first attempt at the job had failed:<\/p>\n\n\n\n

    \"\"<\/a>
    Successful policy execution<\/figcaption><\/figure>\n\n\n\n

    I then ran the policy again for good measure and yep, not only did the error go away, but the deduplication was (as you’d expect), quite good:<\/p>\n\n\n\n

    \"Third<\/a>
    Third policy execution<\/figcaption><\/figure>\n\n\n\n

    And yes, you can configure an Oracle backup policy for frequent archive log backup operations as well, something I know is quite popular with DBAs. I eventually updated my policy to include half-hourly archive log backups:<\/p>\n\n\n\n

    \"Half-hourly<\/a>
    Half-hourly archive log backups of Oracle within PowerProtect Data Manager<\/figcaption><\/figure>\n\n\n\n

    The half-hourly log backups of course will show up in your job monitor, as you’d expect:<\/p>\n\n\n\n

    \"Half-Hourly<\/a>
    Half-Hourly Oracle archive log backups shown in the job monitor in PowerProtect Data Manager<\/figcaption><\/figure>\n\n\n\n

    And there you go — an end-to-end process for getting Oracle backups within PowerProtect Data Manager running!<\/p>\n","protected":false},"excerpt":{"rendered":"

    I recently wanted to check out some PowerProtect Data Manager options with Oracle, and so I found myself spinning up…<\/p>\n","protected":false},"author":1,"featured_media":6331,"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":[6,9,1520],"tags":[706,1558],"class_list":["post-10824","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-basics","category-databases","category-powerprotect","tag-oracle","tag-ppdm"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/nsrd.info\/blog\/wp-content\/uploads\/2017\/07\/bigStock-Database.jpg","jetpack_shortlink":"https:\/\/wp.me\/pKpIN-2OA","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/10824","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=10824"}],"version-history":[{"count":5,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/10824\/revisions"}],"predecessor-version":[{"id":10862,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/10824\/revisions\/10862"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media\/6331"}],"wp:attachment":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media?parent=10824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/categories?post=10824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/tags?post=10824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}