Lesson 3	The course project
Objective	Learn about the course project.

Database Course Project

You will acquire a wide range of skills in this course. To practice applying these skills, you will complete several small projects. It is not practical to expect you to crash your production database to test something.

Your Course Projects

For the duration of the course, imagine yourself as a DBA for a company called Network Consultants. As such, you will work with a project database system using the Oracle 23ai RDBMS You will be given several tasks to perform on this system during this course. As we progress through these courses more information will be presented to you. Our simulations and tests may rely on information presented in earlier lessons. This will help reinforce what you have just learned and the dependent material presented earlier. The next module examines Backup and Recovery considerations for Oracle 23ai.

Backing Up an Oracle 23ai Database in Oracle Cloud Infrastructure (OCI)

Here are the steps to back up an existing Oracle 23ai database in OCI:
Option 1: Using Oracle Cloud Infrastructure Database Backup Service

Prepare your environment:
- Ensure you have appropriate IAM permissions for database backup operations
- Verify your database meets the requirements for OCI Backup Service
Configure Automatic Backups (recommended):
- Navigate to Oracle Database service in OCI Console
- Select your 23ai database
- Click "Backup" in the Resources section
- Click "Configure Automatic Backups"
- Set backup retention period (typically 30-60 days)
- Choose backup window (low-usage period)
Create Manual On-Demand Backup:
- In the Database Details page, click "Create Manual Backup"
- Provide a meaningful backup name
- Select backup type (Full or Incremental)
- Click "Create Backup"

Option 2: Using RMAN (Recovery Manager)

Connect to your database:
```
rman target /
    
```

Run backup command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

For OCI-specific storage:

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK 
      FORMAT '/path/to/oci/storage/%U';
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;

Option 3: Using Data Pump (logical backup)

Create directory object in OCI:

CREATE OR REPLACE DIRECTORY exp_dir AS '/path/to/oci/storage';

Run Data Pump export:


expdp system/password@db23ai \
directory=exp_dir \
dumpfile=db23ai_backup_%U.dmp \
logfile=db23ai_backup.log \
full=y \
parallel=4

Post-Backup Steps

Verify backups:
- In OCI Console, check the Backup section
- For RMAN: RMAN> LIST BACKUP SUMMARY;

Consider copying backups to Object Storage for additional protection:

oci os object put -ns <namespace> -bn <bucket-name> --file <backup-file>

Document the backup with details including:
- Backup type and time
- Location
- Any special considerations

Network Consultants Technology

A network consultant is an information technology professional who works with computer networks. Network consultants typically work to help organizations build and maintain computer networks that meet their needs.
Network Consultants Technology (NCT) is an IT Consultant and Service support company, providing complete IT service, support needs and IT advice for businesses across the world wide web. NCT offers an extended level of products and services, including highly skilled and industry experienced team, with wide ranging fields of expertise in: