Home » RDBMS Server » Backup & Recovery » delete backupset issue (10.2.0.1)
delete backupset issue [message #556651] Tue, 05 June 2012 21:34 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I want to delete a backupset and get the flowing prompt,i want to delete it directly and no prompt,how can i do?

Do you really want to delete the above objects (enter YES or NO)? YES
RMAN> delete backupset tag 'TAG20120306T211654';

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
111     101     1   1   UNAVAILABLE DISK        /u01/app/oracle/duplicate/al_t777244616_s111_p1

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u01/app/oracle/duplicate/al_t777244616_s111_p1 recid=111 stamp=777244617
Deleted 1 objects

Re: delete backupset issue [message #556654 is a reply to message #556651] Tue, 05 June 2012 22:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why do you NEVER Read The Fine Manual to find documented answers???????????

http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta016.htm

[Updated on: Tue, 05 June 2012 22:20]

Report message to a moderator

Re: delete backupset issue [message #556659 is a reply to message #556654] Tue, 05 June 2012 22:43 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
BlackSwan!
Re: delete backupset issue [message #556660 is a reply to message #556659] Tue, 05 June 2012 23:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you found an answer yourself, post it. That way we know the issue is resolved and we might learn from it.
Re: delete backupset issue [message #556671 is a reply to message #556660] Wed, 06 June 2012 00:41 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
BlackSwan!

DELETE NOPROMPT BACKUPSET TAG 'TAG20120306T211654';
Previous Topic: how to extract the archive log backup set
Next Topic: recover by the scn
Goto Forum:
  


Current Time: Thu Mar 28 19:31:13 CDT 2024