The Oracle Fundamentals II Case Study consists of the 22 most common DBA tasks to do its backup, recovery and network tasks. In your organization, you as a DBA, are expected to know at least how to: Allocate and re-size the memory space on the fly; Understand Oracle background processes; Multiplex Control Files; Configure the Database Archive mode; Maintain Redo Log files; Duplex Archived Online Redo Log files; Perform User-Managed COLD or OFFLINE Backups; Perform User-Managed HOT or ONLINE backups; Perform User-Managed Tablespaces and Datafiles backups; Perform User-Managed Tablespace Restorations; Perform Backup and Recoveries using the EXPORT and IMPORT utilities; Creating a RMAN repository; Use of the RMAN commands; Configuration of the RMAN tool; Use of the RMAN backup utility; Performing tablespace recoveries using the RMAN tool; Performing Complete Backups using the RMAN tool; Performing incomplete database recoveries; Using the LIST and REPORT commands; Configuring a Listener using the “Net Manager” tool; and Configuring a Service Name using the “Net Manager” tool.

Hands-On Oracle Fundamentals II-CD#02

(RMAN-Managed Backup and Recovery along with Network Configurations)

Hands-On 01 (RMAN-Managed user and repository) - Manuscript

You, as a DBA, are responsible to create the RMAN repository and use the RMAN tool to perform a backup and recovery of your organization’s database. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Creating the RMAN user

Generating the RMAN objects

Creating the Recovery Manager Repository

Creating the RMAN tablespace

Granting privileges to the RMAN user

Granting the RECOVERY_CATALOG_OWNER to the RMAN user

Using the RMAN RCVCAT command

Using the DBA_OBJECTS dictionary view

Using the DBMS_RCVCAT package

Using the DBMS_RCVMAN package

Commands:

CREATE TABLESPACE

CREATE USER

GRANT

DOS> rman RCVCAT

RMAN> CREATE CATALOG;

RMAN> exit;

Hands-On 02 (Use of the RMAN commands) - Manuscript

You, as a DBA, are responsible for registering a database, synchronizing a database, and backing-up a database. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Connecting to the RMAN tool

Using the source and the target database commands

Registering a database

Synchronizing a catalog

Creating a snapshot of a controlfile

Backing up a database

Backing up a datafile

Backing up the current controlfile

Commands:

DOS> CATALOG TARGET

RMAN> register database;

RMAN> resync catalog;

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO

RMAN> BACKUP DATAFILE

RMAN> BACKUP CURRENT CONTROLFILE;

RMAN> exit;

Hands-On 03 (Configuration of the RMAN tool) - Manuscript

You, as a DBA, are responsible for configuring the RMAN repository, performing an image copy, connecting to the target and catalog databases, etc. Your job’s responsibilities dictate that you should be at least informed of the following basic fundamental subjects:

Configuring the RMAN retention policy

Excluding any tablespaces from a backup

Performing an image copy

Using the CONNECT CATALOG

Using the CONNECT TARGET

Performing an image copy of the data file

Using the NOCHECKSUM parameter

Performing an image copy of the current control file

Using a specific backup naming format

Commands:

COPY DATAFILE TO ‘xxx’ NOCHECKSUM;

HOST MKDIR

DOS> RMAN

RMAN> CONNECT CATALOG

RMAN> CONNECT TARGET

RMAN> CONFIGURE RETENTION POLICY

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE

RMAN> COPY DATAFILE

RMAN> COPY CURRENT CONTROLFILE

RMAN> exit

Hands-On 04 (Using the RMAN backup utility) - Manuscript

As a DBA, you are also responsible for performing backups of a database, performing incremental backups, and using the formatted defined output name. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Performing a backup copy in a specific location

Performing a backup with formatting the backup file’s name

Backing-up database objects using the incremental syntax

Using the %T for the date

Using the %S for the backup set number

Using the %P for the piece number

Performing a RMAN backup of a tablespace

Performing RMAN backup of a tablespace

Incremental

Performing a RMAN backup of a tablespace

Incremental

Commands:

DOS> RMAN

RMAN> CONNECT CATALOG

RMAN> CONNECT TARGET

RMAN> BACKUP DATAFILE

RMAN> BACKUP TABLESPACE

RMAN> BACKUP INCREMENTAL

RMAN> exit

Hands-On 05 (RMAN-Managed Tablespace Recovery) - Manuscript

You, as a DBA, are responsible to recover a tablespace due to a loss of data from a media system crash. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Performing a tablespace recovery

Using the V$DATABASE view

Using the USER_TABLES

Writing a procedure

Modeling a media disk crash

Setting a datafile status using the RMAN tool

Restoring a datafile

Commands:

ALTER TABLESPACE

HOST ERASE

DOS> RMAN

RMAN> CONNECT CATALOG

RMAN> CONNECT TARGET

RMAN> SQL 'ALTER DATABASE DATAFILE OFFLINE';

RMAN> RESTORE DATAFILE

RMAN> RECOVER DATAFILE

RMAN> SQL 'ALTER DATABASE DATAFILE ONLINE';

RMAN> SQL 'ALTER TABLESPACE ONLINE';

RMAN> exit

DROP TABLE

Hands-On 06 (RMAN-Managed Complete Backup) - Manuscript

As a DBA, you are also responsible for performing complete backups using the RMAN tool. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Performing a complete database backup

Using the LIST BACKUP command

Commands:

DOS> rman CATALOG

RMAN> BACKUP DATABASE

RMAN> LIST BACKUP;

RMAN> exit;

Hands-On 07 (RMAN-Managed incomplete database recovery scenario) - Manuscript

As a DBA, you are responsible for recovering a table to a point in time due to user failure. In your organization, a user dropped a table. That table needs to be recovered before the table was dropped. In this hands-on we’ll created a scenario to demonstrate to you an incomplete recovery. In the next hands-on we’ll then use the RMAN utility to perform an incomplete recovery to the time before the table was dropped. As a DBA, you’ll have to recover the table using an incomplete recovery. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Using the V$DATABASE view

Using the USER_TABLES view

Using the SET TIME command

Creating a scenario - before and after an incomplete recovery

Commands:

DROP TABLE

SET TIME ON

SET TIME OFF

Hands-On 08 (RMAN-Managed incomplete database recovery) - Manuscript

As a DBA, you are responsible for recovering a table to a point in time due to user failure. In the pervious hands-on, the scenario was modeled and performed. Now, in this hands-on, we’ll use the RMAN utility to perform an incomplete recovery to the point in time before the dropping of the table. As a DBA, you’ll have to recover the table by using an incomplete recovery. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Performing an incomplete database recovery

Performing the database restore

Performing the recover procedures until a specified time

Opening a database using the RESETLOGS option

Checking to see if a table was recovered

Dropping a table

Commands:

RMAN> CONNECT CATALOG

RMAN> CONNECT TARGET

RMAN> SHUTDOWN IMMEDIATE;

RMAN> STARTUP MOUNT;

RMAN> OPEN RESETLOGS DATABASE;

DROP TABLE

Hands-On 09 (RMAN-Managed the LIST and REPORT commands) - Manuscript

As a DBA, you are responsible for obtaining backup information using the LIST and REPORT commands. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Performing the LIST and REPORT commands

Creating a RMAN script

Replacing a RMAN script

Deleting a RMAN script

Running a RMAN script

Connecting to the RMAN tool using the Recovery Catalog database

Listing all of the backup sets and the associated backup pieces

Listing all of the expired backup sets

Listing the backup of the data files for a tablespace

Listing a database incarnations registered in a database

Displaying objects that need a backup and a confirmed retention policy

Listing all of the backup sets and image copies that are OBSOLETE

Listing all of the schemas of the database that can be deleted

Commands:

RMAN> CONNECT CATALOG

RMAN> CONNECT TARGET

RMAN> LIST BACKUP;

RMAN> LIST EXPIRED BACKUPSET;

RMAN> LIST BACKUP

RMAN> LIST INCARNATION OF DATABASE;

RMAN> REPORT NEED BACKUP;

RMAN> REPORT OBSOLETE;

RMAN> REPORT SCHEMA;

RMAN> RUN

RMAN> REPLACE SCRIPT

RMAN> DELETE SCRIPT

RMAN> exit;

Hands-On 10 (Configuring a Listener using the “Net Manager” tool) - Manuscript

As a DBA, you are responsible for configuring a listener using the “Net Manager” tool. Your job responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Adding a listener,

Modifying a listener,

Viewing a listener,

Configuring a listener

Enabling a listener’s "logging" file

Enabling a listener’s "tracing" file

Disabling a listener’s "logging" file

Disabling a listener’s "tracing" file

Adding a listener's "Location address"

Hands-On 11 (Configuring a Service Name using the “Net Manager” tool) - Manuscript

As a DBA, you are also responsible for configuring a Service Name using the “Net Manager” tool. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

Adding a service name

Modifying a service name

Configuring a service name

Testing a service name