Delete objects in RMAN [message #73245] |
Mon, 08 March 2004 04:54 |
W.Boyer
Messages: 2 Registered: March 2004
|
Junior Member |
|
|
Oracle 8i on Windows 2000.
The output of the REPORT OBSOLETE lists backupsets and backuppieces. Now I'm not a DBA..actually I'm a Tivoli Storage Manager specialist, but I need to implement backups using RMAN for a client. Aren't the pieces a part of the backupset? If I change/delete the backupset, does it also remove all the pieces, or do I need to change/delete each backuppiece and backupset individually? All this client will be doing is a daily full with hourly archivelog backups. If this was 9i I could just configure a retention policy and DELETE OBSOLETE;
Bill
|
|
|
|
Re: Delete objects in RMAN [message #73256 is a reply to message #73252] |
Tue, 09 March 2004 16:16 |
W.Boyer
Messages: 2 Registered: March 2004
|
Junior Member |
|
|
I'm using the Tivoli Oracle agent to backup the data. Device type sbt_tape. The sample rman1.sh script generates a list of obsolete objects (report obsolete until....) parses this, generates the change ... delete; commands. The question I had was can I safely just change/delete the backupset and all the backup pieces contained within will be deleted, too? Or do I need to change/delete each individual backup piece within the backupset and then delete the backupset.
Keeping in mind this is Oracle8i. Would be sooo much easier in 9i.
Bill
|
|
|