Common settings for Rman parameters

View all Rman configurations

Rman> Show All;

RMAN configuration parameters for database with Db_unique_name ORACLE007 is:
CONFIGURE RETENTION POLICY to RECOVERY windows of 7 days; —————— backup files are saved by default for 7 days (more than 7 days if you don't need to overwrite them)
CONFIGURE BACKUP optimization OFF; # Default
CONFIGURE DEFAULT DEVICE TYPE to DISK; # Default
CONFIGURE controlfile autobackup OFF; # Default
CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to '%F '; # Default
CONFIGURE DEVICE type DISK PARALLELISM 1 BACKUP type to BACKUPSET; # Default
CONFIGURE datafile BACKUP COPIES for DEVICE TYPE DISK to 1; # Default
CONFIGURE ARCHIVELOG BACKUP COPIES for DEVICE TYPE DISK to 1; # Default
CONFIGURE maxsetsize to UNLIMITED;
CONFIGURE encryption for DATABASE OFF; # Default
CONFIGURE encryption algorithm ' AES128 '; # Default
CONFIGURE COMPRESSION algorithm ' BASIC ' as of RELEASE ' DEFAULT ' OPTIMIZE for LOAD TRUE; # Default
CONFIGURE ARCHIVELOG deletion POLICY to NONE; # Default
CONFIGURE SNAPSHOT controlfile NAME to '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_oracle007.f '; # Default

Configuration commands simply change the parameters above

Setting the format string

CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to '%F ';

format string Formatting

The various substitution variables that can be used when using the format parameter, as shown in the following (note-case):

• The activation ID of the%a:oracle database is resetlog_id.
• %c: Number of copies of the backup fragment (numbered from 1, max. 256).
• %d:o racle database name.
• %d : The day of the current time, in the form of DD.
• %e: Archive serial number.
• %f: Absolute file number.
• %F: A unique name based on "dbid+ time", formatted as C-IIIIIIIIII-YYYYMMDD-QQ, where IIIIIIIIII is the date of DBID,YYYYMMDD for that database, and QQ is a 1~256 sequence.
• %H: Archive log thread number.
• %I : O the dbid of the Racle database.
• %M: The month in the current time, in mm format.
• %N: Table space name.
• %n: The database name, and is populated with an X character on the right, leaving it at 8 length. For example, if the database name is Jssbook, the generated name is JSSBOOKX.
• %p: The number of backup fragments in the backup set, starting at 1.
• %s: Backup set number.
• %t: Backup set timestamp.
• %T: The Month-date format (YYYYMMDD) of the current time.
• %u: is a 8-character name that consists of the backup set number and the build time compression. With%u, you can generate a unique name for each backup set.
• %u: The default is the abbreviated form of%u_%p_%c, which makes it possible to generate a unique name for each backup fragment (that is, the disk file), which is the most commonly used naming method, and the resulting rules are different when performing different backup operations, as follows:
  • When generating backup fragments,%u=%u_%p_%c;
  • Generate Data file image copy,%u=data-d-%d_id-%i_ts-%n_fno-%f_%u;
  • %u=arch-d_%d-id-%i_s-%e_t-%h_a-%a_%u when generating image copy of archive file;
  • %u=cf-d_%d-id-%i_%u when generating a control file mirroring replication.
• %Y: The year in the current time, formatted as YYYY.

Setting the format string

RETENTION policy refers to the Rman backup retention policies.
CONFIGURE RETENTION POLICY to redundancy 1; the redundancy of the backup is 1, which is to keep the last copy of the backup (a backup that can be done for database recovery, such as full provisioning).
CONFIGURE RETENTION POLICY to RECOVERY WINDOW of the day; the backup that is required to restore the backup days within 60 days is retained.
You can use Crosscheck backup after you define a retention policy, and delete obsolete to remove unwanted backups.

If you use the catalog, just care about retention policy on it, no tube control_file_record_keep_time.
If you use Controlfile, that control_file_record_keep_time will also affect the record of keeping backups in Controlfile. So when using Controlfile, it is better to set Control_file_record_keep_time to more than CONFIGURE RETENTION POLICY to RECOVERY WINDOW of the day; set the number of days.



Common settings for Rman parameters