Shulou(Shulou.com)06/01 Report--

First, clean up the space using the following command:

1. Cd / orabak2. Find. -type f-mtime + 30-exec rm-rf {}\

Second, start using the script of rman backup for backup, and the following error occurs at the end of the backup

-archive log filename=/oralog/1_20800_812554797.dbf recid=20799 stamp=839154512archive log filename=/oralog/1_20801_812554797.dbf recid=20800 stamp=839154513released Channel: ch2RMAN-00571: = = RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = RMAN-00571: = RMAN-03009: failure of backup command on ch2 channel at 02 stamp 10 10:33:46ORA-19571: archived-log recid 19009 stamp 837863118 not found in control file -

III. Analysis and processing process

1. When the archive log is manually deleted, the Rman backup detects that the log is missing and cannot proceed further.

So you need to perform the crosscheck process manually at this point, and then the Rman backup can return to normal.

2. Crosscheck log

$rman target / RMAN > crosscheck archivelog all;#Oracle 9i and later versions using crosscheck archivelog all;RMAN > change archivelog all crosscheck; # Oracle 8i using change archivelog all crosscheck

3. Run the backup script again

-- archive log filename=/oralog/1_20887_812554797.dbf recid=20886 stamp=839198925 archive log filename=/oralog/1_20888_812554797.dbf recid=20887 stamp=839198982 archive log filename=/oralog/1_20889_812554797.dbf recid=20888 stamp=839199982 archive log filename=/oralog/1_20890_812554797.dbf recid=20889 stamp=839199982 Finished backup at 10-FEB-14Starting backup at 10-FEB-14channel ch2: starting full datafile backupset channel ch2: specifying datafile (s) in backupset including current control file in backupset channel ch2: starting piece 1 at 10-FEB-14channel ch2: finished piece 1 at 10- FEB-14 piece handle=/orabak/control_11839200079688 tag=TAG20140210T230759 comment=NONE channel ch2: backup set complete Elapsed time: 00:00:01 Finished backup at 10-FEB-14released channel: ch2-- complete

4. Reference materials

Http://www.eygle.com/archives/2004/12/rman_crosscheck.html

5. Backup script of rman

Run {allocate channel ch2 device type DISK;backup full filesperset 50database format'/orabak/full_%c_%p_%t_5s';sql 'alter system archivelog current';backup filesperset 50 archivelog allformat' / orabak/arch%c%p%t%s' delete input;backup current controlfile format'/orabak/ control_%c%p%t%s';release channel ch2;}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.