Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ARCHIVE NOT DELETED

831655Feb 2 2011 — edited Feb 2 2011
HI....

yesteday i had taken the scedule bakup (incremental level 2 with 'delete input' option)...
but it said that some of the archived no deleted....
so agian in the morning i took the archived log bakup with the command

RMAN> backup format 'd:\app\archbakup\feb3_%s_%t_%U.bkp' archivelog all delete i
nput;

so again it flashed back the error while taking the archived log backup...



RMAN> backup format 'd:\app\archbakup\feb3_%s_%t_%U.bkp' archivelog all delete i
nput;

Starting backup at 02-FEB-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=731 RECID=355 STAMP=741984037
input archived log thread=1 sequence=732 RECID=356 STAMP=741984043
input archived log thread=1 sequence=733 RECID=357 STAMP=741984111
input archived log thread=1 sequence=734 RECID=358 STAMP=741984159
input archived log thread=1 sequence=735 RECID=359 STAMP=741984204
input archived log thread=1 sequence=736 RECID=360 STAMP=741984225
input archived log thread=1 sequence=737 RECID=361 STAMP=741984255
input archived log thread=1 sequence=738 RECID=362 STAMP=741984271
input archived log thread=1 sequence=739 RECID=363 STAMP=742040853
input archived log thread=1 sequence=740 RECID=364 STAMP=742040927
input archived log thread=1 sequence=741 RECID=365 STAMP=742041046
input archived log thread=1 sequence=742 RECID=366 STAMP=742041092
input archived log thread=1 sequence=743 RECID=367 STAMP=742041131
input archived log thread=1 sequence=744 RECID=368 STAMP=742041172
input archived log thread=1 sequence=745 RECID=369 STAMP=742041212
input archived log thread=1 sequence=746 RECID=370 STAMP=742041436
input archived log thread=1 sequence=747 RECID=371 STAMP=742041595
input archived log thread=1 sequence=748 RECID=372 STAMP=742041761
channel ORA_DISK_1: starting piece 1 at 02-FEB-11
channel ORA_DISK_1: finished piece 1 at 02-FEB-11
piece handle=D:\APP\ARCHBAKUP\FEB3_40_742041762_18M3LA52_1_1.BKP tag=TAG20110202
T104241 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: deleting archived log(s)
archived log file name=D:\APP\ARCH\ARC00731_0740337093.001 RECID=355 STAMP=74198
4037
archived log file name=D:\APP\ARCH\ARC00732_0740337093.001 RECID=356 STAMP=74198
4043
archived log file name=D:\APP\ARCH\ARC00733_0740337093.001 RECID=357 STAMP=74198
4111
archived log file name=D:\APP\ARCH\ARC00734_0740337093.001 RECID=358 STAMP=74198
4159
archived log file name=D:\APP\ARCH\ARC00735_0740337093.001 RECID=359 STAMP=74198
4204
archived log file name=D:\APP\ARCH\ARC00736_0740337093.001 RECID=360 STAMP=74198
4225
archived log file name=D:\APP\ARCH\ARC00737_0740337093.001 RECID=361 STAMP=74198
4255
archived log file name=D:\APP\ARCH\ARC00738_0740337093.001 RECID=362 STAMP=74198
4271
archived log file name=D:\APP\ARCH\ARC00739_0740337093.001 RECID=363 STAMP=74204
0853
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00740_0740337093.001 thread=1 sequence=740

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00741_0740337093.001 thread=1 sequence=741

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00742_0740337093.001 thread=1 sequence=742

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00743_0740337093.001 thread=1 sequence=743

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00744_0740337093.001 thread=1 sequence=744

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00745_0740337093.001 thread=1 sequence=745

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00746_0740337093.001 thread=1 sequence=746

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00747_0740337093.001 thread=1 sequence=747

RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=D:\APP\ARCH\ARC00748_0740337093.001 thread=1 sequence=748

Finished backup at 02-FEB-11

Starting Control File and SPFILE Autobackup at 02-FEB-11
piece handle=D:\APP\ANSARI.DILSHAD\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_02_0
2\O1_MF_S_742041824_6NKT0H4Y_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 02-FEB-11



so why rman not deleting the backup.....
thanks....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2011
Added on Feb 2 2011
7 comments
4,286 views