Oracle NoSQL Database for Administrators Ed 2 — Lesson 3: Security, Users, Roles, Certificates, Backup, Restore, and Recovery

Learning Objectives

• Explain the purpose and operating context of secure store configuration, authentication, users, roles, and privileges.
• Apply wallets, certificates, TLS, password policies, and secure administration and snapshots, backup copies, restore planning, and topology dependencies in a controlled environment.
• Validate outcomes and troubleshoot risks involving node loss, shard availability, replacement, recovery validation, and evidence.

Detailed Topics

• secure store configuration, authentication, users, roles, and privileges
• wallets, certificates, TLS, password policies, and secure administration
• snapshots, backup copies, restore planning, and topology dependencies
• node loss, shard availability, replacement, recovery validation, and evidence

Instructor Demonstration

Demonstrate secure store configuration, authentication, users, roles, and privileges for a distributed key-value and table workload deployed, secured, expanded, and recovered across storage nodes; capture the exact configuration, code, command, transaction, query, dashboard, model, schedule, or report evidence that proves the expected result.

Hands-On Exercise

Complete a controlled Oracle NoSQL Database for Administrators Ed 2 exercise covering wallets, certificates, TLS, password policies, and secure administration and snapshots, backup copies, restore planning, and topology dependencies; introduce an exception involving node loss, shard availability, replacement, recovery validation, and evidence, diagnose it from evidence, apply the smallest reversible correction, and rerun acceptance checks.

1. Confirm scope, prerequisites, identities, dependencies, data, risks, and expected outcome.
2. Perform the course-specific configuration, development, administration, analysis, or business-process workflow.
3. Capture commands, settings, records, logs, screenshots, reports, metrics, or test results.
4. Compare the observed result with acceptance criteria and document corrective or preventive action.

Scenario Analysis

• Identify the technical or business decision and the stakeholders affected by it.
• Compare security, performance, reliability, compliance, cost, usability, and support trade-offs.
• Define rollback, recovery, communication, evidence, ownership, and escalation requirements.

Troubleshooting Guidance

Diagnose issues involving secure store configuration, authentication, users, roles, and privileges, wallets, certificates, TLS, password policies, and secure administration, snapshots, backup copies, restore planning, and topology dependencies, node loss, shard availability, replacement, recovery validation, and evidence without making an unverified production change. Separate symptoms from causes, gather time-correlated evidence, test a reversible hypothesis, validate the correction, and record recurrence controls.

Validation Checklist

• The requirement, environment, inputs, dependencies, and expected result are documented.
• The result is reproducible and supported by product-specific evidence.
• Normal, boundary, failure, security, performance, and operational conditions are reviewed.
• Exceptions, rollback, ownership, support actions, and the next improvement priority are recorded.

Lesson Outcome

Learners can apply Security, Users, Roles, Certificates, Backup, Restore, and Recovery in a realistic Oracle NoSQL Database for Administrators Ed 2 scenario and defend the result with documented evidence.