Database Reference
In-Depth Information
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE
------------------------------ -------------- ------------ -----------------
c:\oracle\fast_recovery_area 2,147,483,648 251,173,376 41,127,424
If you manually remove files from the FRA, you will have to let Oracle
know that you have done so. By default, Oracle will not detect that the
files have been removed. Oracle can detect the file removals by using the
RMAN
CROSSCHECK
and
DELETE EXPIRED
commands. See Chapter 7, “Per-
forming Oracle Advanced Recovery,” for more information on using these
commands.
RMAN Persistent Configuration Settings
When RMAN first came out in Oracle version 8.0, you had to manually indicate in each
backup where the backup destination was to be, any limits related to the backup (such as
the maximum size of backup set pieces), and so on. This required a lot of work and made
RMAN a bit archaic-looking and difficult to use.
Oracle Database version 9
i
introduced the concept of persistent configuration in
RMAN.
RMAN persistent configuration settings
are settings that are configured through
the RMAN interface, stored in the control file, and automatically used during each backup
unless they are overridden.
Oracle Database 12
c
provides for a number of persistent settings, including the following:
■
Backup (database and archive log) retention criteria
■
Backup optimization
■
Default channel/device configuration
■
Control-file autobackup configuration
■
Data file and archive log backup-copy configuration
■
Default encryption settings
■
Default compression settings
■
Default location for the snapshot control file
You can see the current settings for all persistent parameters in RMAN by using the
RMAN
SHOW ALL
command, as shown here:
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACK
UP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
Search WWH ::
Custom Search