rman confusion

From: EdStevens <quetico_man_at_yahoo.com>
Date: 30 Oct 2006 09:01:32 -0800
Message-ID: <1162227692.174536.96330@e3g2000cwe.googlegroups.com>

Oracle 9.2 STANDARD Edition on Solaris 5.9

On Friday (Oct 27) I brought up a new database, quickly configured rman and took an incremental 0 backup. Today (Oct 30) I began putting together scripts to handle all of the backup requirements -- weekly inc. 0, daily inc. 1, crosschecking, etc. I'm sure what I'm seeing is 'as advertised', but I'm missing something here...

Here is the configuration:

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS; CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/db01/flash_recovery_area/CARGOPD/backup/%F'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/db01/flash_recovery_area/CARGOPD/backup/ora_df%t_s%s_s%p'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/home/oracle/dbs/snapcf_cargopd.f'; # default

(yes, I know there is no true 'flash_recovery_area for 9.2, but we decided to use a directory stucture as if there were)

After doing an initial backup on the 27th, I ran this script on the 30th

backup incremental level 0 database filesperset 4; backup archivelog all;
delete archivelog until time 'SYSDATE-7';

(yes, I need to make that SYSDATE-15 to match the

after which I had these files:

$> cd flash_recovery_area
$> cd CARGOPD
$> ls -l
total 4
drwxr-xr-x   2 oracle   oradba       512 Oct 30 09:22 archivelog
drwxr-xr-x   2 oracle   oradba       512 Oct 30 09:22 backup

$> ls -ltr archivelog
total 60592
-rw-r----- 1 oracle oradba 6002688 Oct 27 12:01
0001_0000000044.arc
-rw-r----- 1 oracle oradba 16776704 Oct 27 13:47
0001_0000000045.arc
-rw-r----- 1 oracle oradba 8212992 Oct 30 09:22
0001_0000000046.arc
$> ls -ltr backup
total 2366304
-rw-r----- 1 oracle oradba 327393280 Oct 27 16:11
ora_df604944588_s1_s1
-rw-r----- 1 oracle oradba 260440064 Oct 27 16:12
ora_df604944685_s2_s1
-rw-r----- 1 oracle oradba 1671168 Oct 27 16:12
c-3722838561-20061027-00
-rw-r----- 1 oracle oradba 326197248 Oct 30 09:22
ora_df605179307_s4_s1
-rw-r----- 1 oracle oradba 260833280 Oct 30 09:22
ora_df605179343_s5_s1
-rw-r----- 1 oracle oradba 1671168 Oct 30 09:22
c-3722838561-20061030-00
-rw-r----- 1 oracle oradba 30992896 Oct 30 09:22
ora_df605179363_s7_s1
-rw-r----- 1 oracle oradba 1671168 Oct 30 09:22
c-3722838561-20061030-01
$>

So, I see two pieces and an auto backup of the control file from the backup of the 27th, two pieces and an auto backup of the control file from the backup of the 30th, an archivelog backup from the 30th and an auto backup of the control file from the archivelog backup.

Next I tried:

crosscheck backup;
delete obsolete;

and got

<begin quote>
RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 15 days using channel ORA_DISK_1
Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle


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

Backup Set           3      27-OCT-06
  Backup Piece       3      27-OCT-06
/db01/flash_recovery_area/CARGOPD/backup/c-3722838561-20061027-00
Backup Set           6      30-OCT-06
  Backup Piece       6      30-OCT-06
/db01/flash_recovery_area/CARGOPD/backup/c-3722838561-20061030-00
Backup Set           8      30-OCT-06
  Backup Piece       8      30-OCT-06

/db01/flash_recovery_area/CARGOPD/backup/c-3722838561-20061030-01

Do you really want to delete the above objects (enter YES or NO)? <end quote>

So why is it wanting to delete the backup control files that are only 3 days old, with a 15-day retention policy? Obviously, I'm not understanding something here. Received on Mon Oct 30 2006 - 11:01:32 CST