Oracle Fundamentals II Case Study

Hands-On Oracle Fundamentals II-CD#02

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

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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