Home » RDBMS Server » Backup & Recovery » backup set obsolete issue (11.2.0.1 windows xp)
backup set obsolete issue [message #535712] Thu, 15 December 2011 19:38 Go to next message
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 #535718 is a reply to message #535712] Thu, 15 December 2011 23:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nope.
A recovery windows of 2 days means you can restore and recover the database at any point in time in the last 2 days.
As you have no backup later than the 30/11 this one is needed to recover the database accordingly to your policy.

Regards
Michel
Re: backup set obsolete issue [message #535720 is a reply to message #535718] Thu, 15 December 2011 23:30 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Re: backup set obsolete issue [message #535722 is a reply to message #535720] Fri, 16 December 2011 00:07 Go to previous messageGo to next message
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 #535731 is a reply to message #535722] Fri, 16 December 2011 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A backup from today does not allow you to restore the database at yesterday point of time
and your policy requires it.

Regards
Michel
Re: backup set obsolete issue [message #535748 is a reply to message #535731] Fri, 16 December 2011 03:09 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
Michel,i don't know why the backup sets which backup at 30/11 have not be obsolete? because the 30/11 is out of the windows days(2).
Re: backup set obsolete issue [message #535751 is a reply to message #535748] Fri, 16 December 2011 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It 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.
2 days after your last backup, the 30/11 backup will be obsolete.

Regards
Michel
Re: backup set obsolete issue [message #535753 is a reply to message #535751] Fri, 16 December 2011 03:41 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Michel Cadot wrote on Fri, 16 December 2011 03:19
It 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.
Re: backup set obsolete issue [message #535754 is a reply to message #535753] Fri, 16 December 2011 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't say more that what I said.
Remove the backup and try to recover your database to yesterday and you will see can't
and so this proves it necessary to keep it.
The recovery window means the window during which you must be able to restore and recover;
it has no direct relation with the backup time.

Regards
Michel
Re: backup set obsolete issue [message #535759 is a reply to message #535754] Fri, 16 December 2011 04:16 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks Michel!
Previous Topic: how to know the latest backup sets
Next Topic: user managed recovery
Goto Forum:
  


Current Time: Fri Oct 19 19:22:47 CDT 2018