SHUTDOWN Shuts down the target database from within RMAN. Identical to the
SHUTDOWN command within SQL*Plus.
STARTUP Starts up the target database. This command has the same options and
function as the SQL*Plus STARTUP command.
SQL Runs SQL commands that cannot be accomplished directly or indirectly
using standard RMAN commands; for example, it can run sql ???alter
tablespace users offline immediate??™; before restoring and recovering
the USERS tablespace.
TRANSPORT
TABLESPACE
Creates transportable tablespace sets from backup for one or more
tablespaces.
VALIDATE Examines a backup set and report whether its data is intact and consistent.
TABLE 12-1 Common RMAN Commands (continued)
426 Oracle Database 11g DBA Handbook
The tablespace that holds the repository database requires at least 125MB to hold recovery
catalog entries; here is a space requirements breakdown by tablespace:
90MB in the SYSTEM tablespace
5MB in the TEMP tablespace
5MB in the UNDO tablespace
15MB in RMAN??™s default tablespace for each database registered in the recovery catalog
1MB for each online redo log file
Starting out with available free space of 125MB will in most cases be sufficient for the first
year, and enabling additional extents of 50MB each will be sufficient in the long term depending
on how many databases you manage in the recovery catalog. Overall, a very small amount of
disk space compared to your terabyte data warehouse!
Connect to the repository database with SYSDBA privileges and create the RMAN account
and the recovery catalog in the RMAN tablespace as follows:
[oracle@oc1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.
Pages:
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665