TABLE 12-2 RMAN Data Dictionary and Dynamic Performance Views
434 Oracle Database 11g DBA Handbook
The RC_* views only exist in a database that is used as an RMAN repository; the V$ views
exist and have rows in any database that is backed up using RMAN. To highlight this difference,
we??™ll look at the view V$RMAN_CONFIGURATION in the target database:
SQL> connect rjb/rjb@dw
Connected.
SQL> select * from v$rman_configuration;
CONF# NAME VALUE
---------- ------------------------------ ------------------------------
1 RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS
2 CONTROLFILE AUTOBACKUP ON
3 DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED
BACKUPSET PARALLELISM 1
SQL>
Note that these are the three RMAN persistent parameters that we changed earlier. The recovery
catalog database keeps these non-default values in the view RC_RMAN_CONFIGURATION for all
databases registered with RMAN:
SQL> connect rman/rman@rac
Connected.
SQL> select db_key, db_unique_name, name, value
2 from rman.rc_rman_configuration;
DB_KEY DB_UNIQUE_NAME NAME VALUE
---------- ---------------- ------------------------- --------------------
1 dw CONTROLFILE AUTOBACKUP ON
1 RETENTION POLICY TO RECOVERY WINDOW O
F 4 DAYS
1 dw DEVICE TYPE DISK BACKUP TYPE TO
COMPRESSED BACKUPSET
PARALLELISM 1
3 rows selected.
If we were using RMAN to back up another database, this view would contain other values for
DB_KEY and DB_UNIQUE_NAME for other target databases with non-default RMAN parameters.
Pages:
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675