| Can you instruct me to delete expired backup? [message #271528] |
Mon, 01 October 2007 21:11  |
trantuananh24hg
Messages: 744
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 #271531 is a reply to message #271529] |
Mon, 01 October 2007 21:53  |
trantuananh24hg
Messages: 744
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 #273928 is a reply to message #271687] |
Fri, 12 October 2007 04:47 |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
