Hands-On Oracle Fundamentals II-CD#02

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

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

Adding a service name

Modifying a service name

Configuring a service name

Testing a service name