| backup set obsolete issue [message #535712] |
Thu, 15 December 2011 19:38  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Dear all,
I have set the RETENTION POLICY TO RECOVERY WINDOW Values to 2 days,but my backup sets which backuped before 2 days(30-NOV-11),and the backup set is avaliable also,i think it must be expired or obsolete,why?
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_oracl.f'; # default
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 351.26M DISK 00:00:51 30-NOV-11
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 173.91M DISK 00:00:55 30-NOV-11
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 6.77M DISK 00:00:03 30-NOV-11
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak
Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 80.00K DISK 00:00:02 30-NOV-11
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak
SPFILE Included: Modification time: 30-NOV-11
|
|
|
|
|
|
|
|
| Re: backup set obsolete issue [message #535722 is a reply to message #535720] |
Fri, 16 December 2011 00:07  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
Michel,I backup my db today,and run the crosscheck backup,i found the backup sets which backuped at 2011-11-30 are avaliable also,why?
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 351.26M DISK 00:00:51 30-NOV-11
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 173.91M DISK 00:00:55 30-NOV-11
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 6.77M DISK 00:00:03 30-NOV-11
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak
Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 80.00K DISK 00:00:02 30-NOV-11
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak
SPFILE Included: Modification time: 30-NOV-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 352.88M DISK 00:01:42 16-DEC-11
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20111216T013342
Piece Name: /u01/rman_backup/2011/201112/20111216/df_770002425_14_1.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 821993 16-DEC-11 /u01/app/oracle/oradata/oracl/system01.dbf
4 Full 821993 16-DEC-11 /u01/app/oracle/oradata/oracl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Full 186.16M DISK 00:01:46 16-DEC-11
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20111216T013342
Piece Name: /u01/rman_backup/2011/201112/20111216/df_770002424_13_1.bak
List of Datafiles in backup set 13
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 821993 16-DEC-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
3 Full 821993 16-DEC-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
5 Full 821993 16-DEC-11 /u01/app/oracle/oradata/oracl/hxl01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Full 6.83M DISK 00:00:04 16-DEC-11
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20111216T013342
Piece Name: /u01/rman_backup/2011/201112/20111216/df_770002534_15_1.bak
Control File Included: Ckp SCN: 821993 Ckp time: 16-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15 Full 80.00K DISK 00:00:02 16-DEC-11
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20111216T013342
Piece Name: /u01/rman_backup/2011/201112/20111216/df_770002538_16_1.bak
SPFILE Included: Modification time: 16-DEC-11
RMAN> crosscheck backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle= /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak recid=12 stamp=769250367
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak recid=13 stamp=769250424
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak recid=14 stamp=769250451
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak recid=15 stamp=769250478
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201112/20111216/df_770002425_14_1.bak recid=16 stamp=770002425
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201112/20111216/df_770002424_13_1.bak recid=17 stamp=770002425
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201112/20111216/df_770002534_15_1.bak recid=18 stamp=770002538
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/rman_backup/2011/201112/20111216/df_770002538_16_1.bak recid=19 stamp=770002540
Crosschecked 8 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 2 days
no obsolete backups found
[Updated on: Fri, 16 December 2011 00:09] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: backup set obsolete issue [message #535753 is a reply to message #535751] |
Fri, 16 December 2011 03:41 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 16 December 2011 03:19It is not obsolete because it is the only one that allows you to restore and
recover at a point in time yesterday and your policy asks RMAN should be able to do so.
Regards
Michel
hi,
Michel,how to understand this? i want to know why the backup sets which backuped at 30/11 have not be obsolete? it is beyond the recovery window.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
