Using the RMAN Recovery Catalog - OCP: Oracle Database 12c Administrator Certified Professional - page 171

In Exercise 4.1, you'll create a recovery catalog schema.
Metadata Storage Requirements
How much space you will need for the recovery catalog schema is a function of how often
you back up the database and how long you retain the RMAN backup database in the recov-
ery catalog. Oracle indicates that for one database with one backup per day and one archive-
log backup per day, you can estimate metadata storage requirements of between 15MB and
120MB per year, per database, depending on how many backups (database, archive log, and
so on) you do per day. The Oracle documentation provides more guidelines. You will not
need to be familiar with these sizing guidelines when taking your OCP exam.
exeRCiSe 4.1
Creating a Recovery Catalog Schema
Here are the steps to follow when creating the recovery catalog schema:
1. Open a command-line window. For this example, you will use a database called RCAT .
You need to set the ORACLE_SID to RCAT as shown here:
C:\Documents and Settings\dstuns>set ORACLE_SID=RCAT
2. Sign into the database using SQL*Plus:
C:\Documents and Settings\Robert>sqlplus sys/robert as sysdba
The RCAT database noted in this exercise is a database created by the DBCA. There is
nothing different from this Oracle database compared to any other Oracle database
except for the new schema and tablespaces you will create in this exercise.
3. Create a tablespace called RCAT_DATA . This tablespace will be used to store the recovery
catalog schema data:
SQL> create tablespace rcat_data
2 datafile 'c:\oracle\oradata\rcat\rcat_data_01.dbf' size 60m
3 autoextend on next 10m maxsize 200m;
Tablespace created.