In the first policy, at least one backup is guaranteed to be restored to the point in time of the Sysdate-5, and the previous backup is marked as Obsolete. The second policy indicates that at least
In the first policy, at least one backup is guaranteed to be restored to the point in time of the Sysdate-5, and the previous backup is marked as Obsolete. The second policy indicates that at least
1. display the current configuration information
======================================
1.01 RMAN> show all;
1.02 check non-default values in RMAN settings:
SQL> select name, value from v $ rman_configure; -- before 11g
SQL> SELECT CONF #, NAME, VALUE FROM RC_RMAN_CONFIGURATION;
CONF # NAME VALUE
---------- ---------------------------------------- Success ------------------------------------------------------------------------------------------------------------------------------------------------
1 retention policy to redundancy 1
2 channel device type disk format'/u01/app/Oracle/backup_rman/% t _ % s _ % p. bk'
2. Common configure options
======================================
2.01 retention policy (retention policy)
Configure retention policy to recovery window of 3 days;
Configure retention policy to redundancy 3;
Configure retention policy clear;
Backup policy persistence
There are two retention policies: one is the time policy, which determines that at least one backup can be restored to the specified date, and the other is the redundancy policy, which requires at least several redundant backups.
Configure retention policy to recovery window of 5 DAYS;
Configure retention policy to redundancy 5;
Configure retention policy to none;
In the first policy, at least one backup is guaranteed to be restored to the point in time of the Sysdate-5, and the previous backup is marked as Obsolete. The second policy indicates that at least three redundant backups must exist. If there are more than three redundant backups, the backups are marked as redundant. NONE can invalidate the backup retention policy. Clear will restore the default retention policy.
2.02 backup optimization
Configure backup optimization on;
Configure backup optimization off;
Configure backup optimization clear;
2.03 default device type
Configure default device type to disk;
Configure default device type to stb;
Configure default device type clear;
2.04 control file controlfile
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to ''/cfs01/backup/conf _ % f '';
Configure controlfile autobackup clear;
Configure controlfile autobackup format for device type disk clear;
Configure snapshot controlfile name to ''/cfs01/backup/snapcf/scontrofile. snp '';
Configrue snapshot controlfile name clear;
2.05 parallel lines (number of channels) device type disk | stb pallelism n;
Configure device type disk | stb parallelism 2;
Configure device type disk | stb clear;
Configure channel device type disk format ''e/: rmanback _ % u '';
Configure channel device type disk maxpiecesize 100 m
Configure channel device type disk rate 1200 K
Configure channel 1 device type disk format ''e/: rmanback _ % u '';
Configure channel 2 device type disk format ''e/: rmanback _ % u '';
Configure channel 1 device type disk maxpiecesize 100 m
2.06 generate backup copy datafile | archivelog backup copies
Configure datafile backup copies for device type disk | stb to 3;
Configure archivelog backup copies for device type disk | stb to 3;
Configure datafile | archivelog backup copies for device type disk | stb clear
BACKUP DEVICE TYPE DISK DATABASE
FORMAT ''/disk1/backup/% u'',''/disk2/backup/% u'', ''/disk3/backup/% u '';
2.07 exclude
Configure exclude for tablespace ''users '';
Configrue exclude clear;
2.08 backup set size maxsetsize
Configure maxsetsize to 1 GB | 1000M | 000000k | unlimited;
Configure maxsetsize clear;
2.09 other options: aupoliciary
Configure auxname for datafile 1 TO ''/oracle/auxfiles/aux_1.f '';
Configure auxname for datafile 2 TO ''/oracle/auxfiles/aux_2.f '';
Configure auxname for datafile 3 TO ''/oracle/auxfiles/aux_3.f '';
Configure auxname for datafile 4 TO ''/oracle/auxfiles/aux_4.f '';
-
Configure auxname for datafile 1 CLEAR;
Configure auxname for datafile 2 CLEAR;
Configure auxname for datafile 3 CLEAR;
Configure auxname for datafile 4 CLEAR;