Home » RDBMS Server » Backup & Recovery » Can you instruct me to delete expired backup?
Can you instruct me to delete expired backup? [message #271528] Mon, 01 October 2007 21:11 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

I have a retention policy to recover windows of 4 days:
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
...


These are last backup pieces

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1230    Full    34.64G     DISK        00:50:37     22-SEP-07
        BP Key: 1234   Status: AVAILABLE  Compressed: NO  Tag: TAG20070922T09322
8
        Piece Name: E:\RMAN\IBM\BACKUPNEO_DB_0BISIKTC_11_1
  List of Datafiles in backup set 1230
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 318586820  22-SEP-07 E:\ORADATA\NEO\SYSTEM01.DBF
  2       Full 318586820  22-SEP-07 E:\ORADATA\NEO\UNDOTBS01.DBF
  3       Full 318586820  22-SEP-07 E:\ORADATA\NEO\SYSAUX01.DBF
  4       Full 318586820  22-SEP-07 E:\ORADATA\NEO\USERS01.DBF
  5       Full 318586820  22-SEP-07 E:\ORADATA\NEO\VINAPHONE.DBF
  6       Full 318586820  22-SEP-07 E:\ORADATA\NEO\XLN.DBF
  7       Full 318586820  22-SEP-07 E:\ORADATA\NEO\DESIGNER.DBF
  8       Full 318586820  22-SEP-07 E:\ORADATA\NEO\CCS01.DBF
  9       Full 318586820  22-SEP-07 E:\ORADATA\NEO\VINAPHONE01.DBF
  10      Full 318586820  22-SEP-07 E:\ORADATA\NEO\QBH.DBF
  11      Full 318586820  22-SEP-07 E:\ORADATA\NEO\IDX.DBF
  12      Full 318586820  22-SEP-07 E:\ORADATA\NEO\RMAN01.DBF


And I have already had the newest backup pieces since yesterday.

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1785    Full    34.67G     DISK        00:49:21     01-OCT-07
        BP Key: 1789   Status: AVAILABLE  Compressed: NO  Tag: TAG20071001T16482
1
        Piece Name: E:\RMAN\IBM\BACKUPNEO_DB_0IITDQ6L_18_1
  List of Datafiles in backup set 1785
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 320796976  01-OCT-07 E:\ORADATA\NEO\SYSTEM01.DBF
  2       Full 320796976  01-OCT-07 E:\ORADATA\NEO\UNDOTBS01.DBF
  3       Full 320796976  01-OCT-07 E:\ORADATA\NEO\SYSAUX01.DBF
  4       Full 320796976  01-OCT-07 E:\ORADATA\NEO\USERS01.DBF
  5       Full 320796976  01-OCT-07 E:\ORADATA\NEO\VINAPHONE.DBF
  6       Full 320796976  01-OCT-07 E:\ORADATA\NEO\XLN.DBF
  7       Full 320796976  01-OCT-07 E:\ORADATA\NEO\DESIGNER.DBF
  8       Full 320796976  01-OCT-07 E:\ORADATA\NEO\CCS01.DBF
  9       Full 320796976  01-OCT-07 E:\ORADATA\NEO\VINAPHONE01.DBF
  10      Full 320796976  01-OCT-07 E:\ORADATA\NEO\QBH.DBF
  11      Full 320796976  01-OCT-07 E:\ORADATA\NEO\IDX.DBF
  12      Full 320796976  01-OCT-07 E:\ORADATA\NEO\RMAN01.DBF
  13      Full 320796976  01-OCT-07 E:\ORADATA\NEO\PERFSTAT.DBF


Would you like to instruct me to delete those expired backup?
When I used the list expired backup command, it returned nothing(!?)
RMAN> list expired backup;


RMAN>


Thank you!

[Updated on: Mon, 01 October 2007 21:13]

Report message to a moderator

Re: Can you instruct me to delete expired backup? [message #271529 is a reply to message #271528] Mon, 01 October 2007 21:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member


Quote:
Would you like to instruct me to delete those expired backup?


They are not expired , they are obsolete. Do you know the difference of obsolete and expired?
Re: Can you instruct me to delete expired backup? [message #271531 is a reply to message #271529] Mon, 01 October 2007 21:53 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thanks Arju!

I knew the difference between of obsolete and expired.

The expired means to
Quote:

Object is not found either in file system (for DISK) or in the media manager (for sbt). For a backup set to be EXPIRED, all backup pieces in the set must be EXPIRED.



And the obsolete means to
Quote:

An RMAN backup or image copy is obsolete when it is no longer needed for media recovery.
When multiple more recent backups and copies exist. A retention policy determines when a backup or copy is obsolete.



And you see, I have already had the newest backups which is listed above.

May you look at these command following with my backup pieces operations
RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=132 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\RMAN\IBM\BACKUPNEO_DB_0BISIKTC_11_1 recid=4 stamp=6339511
48
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\RMAN\IBM\BACKUPNEO_DB_0CISINSL_12_1 recid=5 stamp=6339541
99
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\NEO\AUTOBACKUP\2007_09_22\O1_M
F_S_633954201_3H92OD3X_.BKP recid=6 stamp=633954201
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\RMAN\IBM\BACKUPNEO_DB_0HITDPVQ_17_1 recid=7 stamp=6348410
83
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\RMAN\IBM\BACKUPNEO_DB_0IITDQ6L_18_1 recid=8 stamp=6348413
02
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\RMAN\IBM\BACKUPNEO_DB_0JITDT3U_19_1 recid=9 stamp=6348442
88
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\NEO\AUTOBACKUP\2007_10_01\O1_M
F_S_634844291_3J1MJMWB_.BKP recid=10 stamp=634844291
Crosschecked 7 objects


RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 4 days
using channel ORA_DISK_1
no obsolete backups found

RMAN>


So that, I did not really about my mistake.

Thank you for your guide!
Re: Can you instruct me to delete expired backup? [message #271644 is a reply to message #271531] Tue, 02 October 2007 05:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You need the backups from 22-SEP-07 to satisfy your RECOVERY WINDOWS OF 4 DAYS, that's why they are not obsolete.
Re: Can you instruct me to delete expired backup? [message #271667 is a reply to message #271644] Tue, 02 October 2007 07:52 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Try 'list obsolete' and 'delete obsolete' RMAN commands.

KV
Re: Can you instruct me to delete expired backup? [message #271687 is a reply to message #271667] Tue, 02 October 2007 08:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
kudur_kv wrote on Tue, 02 October 2007 08:52
Try 'list obsolete' and 'delete obsolete' RMAN commands.


What's that going to matter?? Check the OP's RECOVERY WINDOW.
Re: Can you instruct me to delete expired backup? [message #273928 is a reply to message #271687] Fri, 12 October 2007 04:47 Go to previous message
seethem
Messages: 41
Registered: September 2007
Member
I am having a similar concern. So i decided to read through the RMAN forums before re-opening a similar question.

Can someone explain why we need files that seem to be outside of the Retention window to satisfy a restore during the window?

Why are those 22-SEP-2007 files needed to restore within the 4 day restoration window?

Thanks for your help...
Previous Topic: RMAN Recovery
Next Topic: Creating separate DB for rman catalog
Goto Forum:
  


Current Time: Sat Dec 03 10:09:00 CST 2016

Total time taken to generate the page: 0.06754 seconds