RMAN backup Error

RMAN backup Error
1.1.1RMAN backup error 1.1.1.1 problem and Symptom

ChannelORA_DISK_1: starting piece 1 at 05-MAY-15

RMAN-00571: ========================================================== ==============================

RMAN-00569: ==================== error message stack follows ==========================

RMAN-00571: ========================================================== ==============================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/05/2015 18:04:14

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 2104777216 bytes disk space from 4322230272 limit

1.1.1.2 check ideas

Because this problem occurs during the backup process and the reported space is insufficient, first check the backup space settings

SQL> show parameter db_recovery_file_dest

 

NAME TYPE VALUE

-----------------------------------------------------------------------------

Db_recovery_file_dest string/u01/app/oracle/fast_recovery_area

Db_recovery_file_dest_size large integer 4122 M

Then

[Oracle @ oracle ~] $ Du-sm/u01/app/oracle/fast_recovery_area

3550/u01/app/oracle/fast_recovery_area

1.1.1.3 cause of the problem

The main reason is that DB_RECOVERY_FILE_DETS_SIZE = 4122M, but this directory has already been 3550M and then backed up about 2 GB of files, so we need to modify this limit.

1.1.1.4 Solution

RMAN> configure retention policy torecovery window of 7 days;

 

New RMANconfiguration parameters:

Assumeretention policy to recovery window of 7 DAYS;

New RMANconfiguration parameters are successfully stored

 

RMAN> configure retention policy toredundancy 3;

 

Old RMANconfiguration parameters:

Assumeretention policy to recovery window of 7 DAYS;

New RMANconfiguration parameters:

Assumeretention policy to redundancy 3;

SQL> alter system setdb_recovery_file_dest_size = 7g scope = both;

 

Systemaltered.

RMAN> backuparchivelog all;

 

Starting backup at05-MAY-15.

Using targetdatabase control file instead of recovery catalog

Allocated channel: ORA_DISK_1

ChannelORA_DISK_1: SID = 38 device type = DISK

ChannelORA_DISK_1: starting archived log backup set

ChannelORA_DISK_1: specifying archived log (s) in backup set

Input archived logthread = 1 sequence = 5 RECID = 3 STAMP = 876780457

Input archived logthread = 1 sequence = 6 RECID = 4 STAMP = 876789433

Input archived logthread = 1 sequence = 7 RECID = 5 STAMP = 876830426

Input archived logthread = 1 sequence = 8 RECID = 6 STAMP = 876866886

Input archived logthread = 1 sequence = 9 RECID = 7 STAMP = 876950671

Input archived logthread = 1 sequence = 10 RECID = 8 STAMP = 876992432

Input archived logthread = 1 sequence = 11 RECID = 9 STAMP = 877039260

Input archived logthread = 1 sequence = 12 RECID = 10 STAMP = 877168856

Input archived logthread = 1 sequence = 13 RECID = 11 STAMP = 877212093

Input archived logthread = 1 sequence = 14 RECID = 12 STAMP = 877298424

Input archived logthread = 1 sequence = 15 RECID = 13 STAMP = 877316417

Input archived logthread = 1 sequence = 16 RECID = 14 STAMP = 877356610

Input archived logthread = 1 sequence = 17 RECID = 15 STAMP = 877406439

Input archived logthread = 1 sequence = 18 RECID = 16 STAMP = 877428082

Input archived logthread = 1 sequence = 19 RECID = 17 STAMP = 877471303

Input archived logthread = 1 sequence = 20 RECID = 18 STAMP = 877504314

Input archived logthread = 1 sequence = 21 RECID = 19 STAMP = 877557626

Input archived logthread = 1 sequence = 22 RECID = 20 STAMP = 877590777

Input archived logthread = 1 sequence = 23 RECID = 21 STAMP = 877644039

Input archived logthread = 1 sequence = 24 RECID = 22 STAMP = 877676461

Input archived logthread = 1 sequence = 25 RECID = 23 STAMP = 877701616

Input archived logthread = 1 sequence = 26 RECID = 24 STAMP = 877730463

Input archived logthread = 1 sequence = 27 RECID = 25 STAMP = 877770046

Input archived logthread = 1 sequence = 28 RECID = 26 STAMP = 877816841

Input archived logthread = 1 sequence = 29 RECID = 27 STAMP = 877853741

Input archived logthread = 1 sequence = 30 RECID = 28 STAMP = 877903227

Input archived logthread = 1 sequence = 31 RECID = 29 STAMP = 877936609

Input archived logthread = 1 sequence = 32 RECID = 30 STAMP = 877946863

Input archived logthread = 1 sequence = 33 RECID = 31 STAMP = 878018408

Input archived logthread = 1 sequence = 34 RECID = 32 STAMP = 878023071

Input archived logthread = 1 sequence = 35 RECID = 33 STAMP = 878047701

Input archived logthread = 1 sequence = 36 RECID = 34 STAMP = 878109519

Input archived logthread = 1 sequence = 37 RECID = 35 STAMP = 878162579

Input archived logthread = 1 sequence = 38 RECID = 36 STAMP = 878194931

Input archived logthread = 1 sequence = 39 RECID = 37 STAMP = 878248841

Input archived logthread = 1 sequence = 40 RECID = 38 STAMP = 878281394

Input archived logthread = 1 sequence = 41 RECID = 39 STAMP = 878335209

Input archived logthread = 1 sequence = 42 RECID = 40 STAMP = 878357413

Input archived logthread = 1 sequence = 43 RECID = 41 STAMP = 878378428

Input archived logthread = 1 sequence = 44 RECID = 42 STAMP = 878421646

Input archived logthread = 1 sequence = 45 RECID = 43 STAMP = 878540967

Input archived logthread = 1 sequence = 46 RECID = 44 STAMP = 878594428

Input archived logthread = 1 sequence = 47 RECID = 45 STAMP = 878627427

Input archived logthread = 1 sequence = 48 RECID = 46 STAMP = 878637664

Input archived logthread = 1 sequence = 49 RECID = 47 STAMP = 878688020

Input archived logthread = 1 sequence = 50 RECID = 48 STAMP = 878713890

Input archived logthread = 1 sequence = 51 RECID = 49 STAMP = 878727648

Input archived logthread = 1 sequence = 52 RECID = 50 STAMP = 878792434

Input archived logthread = 1 sequence = 53 RECID = 51 STAMP = 878853632

Input archived logthread = 1 sequence = 54 RECID = 52 STAMP = 878854392

Input archived logthread = 1 sequence = 55 RECID = 53 STAMP = 878925105

Input archived logthread = 1 sequence = 56 RECID = 54 STAMP = 878925252

Input archived logthread = 1 sequence = 57 RECID = 55 STAMP = 878925853

Input archived logthread = 1 sequence = 58 RECID = 56 STAMP = 878926991

ChannelORA_DISK_1: starting piece 1 at 05-MAY-15

ChannelORA_DISK_1: finished piece 1 at 05-MAY-15

Piecehandle =/u01/app/oracle/fast_recovery_area/ORACLE007/backupset/2015_05_05/partition _. bkptag = TAG20150505T191655 comment = NONE

ChannelORA_DISK_1: backup set complete, elapsed time: 00:00:35

Finishedbackup at 05-MAY-15

1.1.1.5 knowledge point

1. Use the configure retentionpolicy to recovery window command.

 

Example: RMAN> configure retention policy to recovery window of 5 DAYS;

 

My current time is June 11. If I set the above backup retention policy and perform a backup, the backup will be marked as obsolete after June 16.

 

2. Use the configure retention policyredundancy command.

 

Example: RMAN> configure retention policyredundancy 3;

 

If the preceding settings are performed, after the three backups are completed, the first backup result will be marked as obsolete when the fourth backup is completed. The default backup retention policy of ORACLE11G is set using this method, and REDUNDANCY is 1. You can use the configure retention policy clear command to set the recovery POLICY to the default value. You can also use the configure retention policy to none command TO set the POLICY. In this case, report obsolete and delete obsolete will not regard any backup files as OBSOLETE.

3. The ORACLE backup directory is set by the db_recovery_file_dest parameter.

4. The ORACLE backup directory is set by the db_recovery_file_dest_size parameter.