ORACLE DBA-APPS DBA: Introduction to Oracle RMAN Case Studies

Introduction to Oracle RMAN Case Studies

Within this section (which I refer to as the RMAN 9i Case Study Series), I wrote several case studies that provide specific examples of how to backup, restore, and recovery different Oracle database configurations. These examples are crafted in much the same way as those found in the $ORACLE_HOME/rdbms/demo.
As with the example scripts that Oracle includes in $ORACLE_HOME/rdbms/demo, it is not meant for any of these case studies (scripts) to be run within a single RMAN session. Rather, these case studies were meant to serve as a basis for developing your own backup, maintenance, restore, and recovery scripts. You should use the various sections in this article as a reference in building individual RMAN scripts which can be run to configure, backup, restore, and recover your database.
The following assumptions should be made throughout each of the case studies:

All case studies will be tested and performed on a Sun Solaris platform - (Solaris 9).
The target database will be an Oracle9i (9.2.0.5.0) database named TARGDB.
The DBID for the TARGDB database is: 2528050866.
Some cases will use a Recovery Catalog and others will not.
A user was created in the target database named backup_admin with a password of backup_admin. This database user was granted SYSDBA privileges and will be the one used to login to the target database for performing all RMAN related operations.

Case Study Overview

This case study provides the RMAN commands (with detailed embedded comments) used to backup, maintain, restore, and recover a single database instance running in no-archivelog mode that includes a read-only tablespace. All of the tablespaces within the TARGDB database will be normal, online, and read/write with the exception of one called READ_ONLY_TBS which is read-only.

SQL> ALTER TABLESPACE read_only_tbs READ ONLY;

Tablespace altered.

SQL> @dba_tablespaces

Status    Tablespace Name TS Type      Ext. Mgt.  Seg. Mgt.  Tablespace Size  Used (in bytes) Pct. Used
--------- --------------- ------------ ---------- --------- ---------------- ---------------- ---------
ONLINE    CWMLITE         PERMANENT    LOCAL      AUTO            52,428,800       15,532,032        30
ONLINE    DRSYS           PERMANENT    LOCAL      AUTO            52,428,800       10,158,080        19
ONLINE    EXAMPLE         PERMANENT    LOCAL      AUTO           157,286,400      142,082,048        90
ONLINE    INDX            PERMANENT    LOCAL      AUTO            52,428,800           65,536         0
ONLINE    ODM             PERMANENT    LOCAL      AUTO            52,428,800       10,027,008        19
ONLINE    PERFSTAT        PERMANENT    LOCAL      AUTO           262,144,000           65,536         0
READ ONLY READ_ONLY_TBS   PERMANENT    LOCAL      AUTO            15,728,640       14,745,600        94
ONLINE    SYSTEM          PERMANENT    LOCAL      MANUAL         838,860,800      395,509,760        47
ONLINE    TOOLS           PERMANENT    LOCAL      AUTO            52,428,800           65,536         0
ONLINE    UNDOTBS         UNDO         LOCAL      MANUAL         419,430,400       23,396,352         6
ONLINE    USERS           PERMANENT    LOCAL      AUTO           104,857,600       83,951,616        80
ONLINE    XDB             PERMANENT    LOCAL      AUTO            52,428,800       46,923,776        90
ONLINE    TEMP            TEMPORARY    LOCAL      MANUAL         524,288,000                0         0
                                                           ---------------- ---------------- ---------
avg                                                                                                  37
sum                                                            2,637,168,640      742,522,880

13 rows selected.