Home » RDBMS Server » Backup & Recovery » How to Delete All Backups (merged)
How to Delete All Backups (merged) [message #243809] Sat, 09 June 2007 03:25 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I want to delete backups from earlier backups. How I can do it from RMAN so that it is recorded in control file as well as in rman repository.
How to Delete All Backups [message #243810 is a reply to message #243809] Sat, 09 June 2007 03:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I want to delete all back ups that I backed up earlier. How I can do it as if It will be recorded in rman repository as well as in control file.



I manually delete a back up from OS. But it is not recorded in control file. Whenever I give restore command it search in that location that I deleted. How I can fix it.
Re: How to Delete All Backups [message #243812 is a reply to message #243810] Sat, 09 June 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use CROSSCHECK then DELETE EXPIRED commands:
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta001.htm#i77523

Regards
Michel
Re: How to Delete All Backups (merged) [message #243823 is a reply to message #243809] Sat, 09 June 2007 07:30 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

After I use crosscheck,

crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=126 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/oradata/0pijeir2_1_1 recid=6 stamp=624380771
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/0rijgts1_1_1 recid=8 stamp=624457601
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oradata/0sijgtte_1_1 recid=9 stamp=624457648
Crosschecked 3 objects


Whenever I use "delete expired"
Then it shows error message..


delete expired
2> ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"
RMAN-01007: at line 2 column 1 file: standard input


What I would do?
Re: How to Delete All Backups (merged) [message #243825 is a reply to message #243823] Sat, 09 June 2007 07:55 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ I gave you the link to the documentation so read it
2/ I didn't say the command is just "delete expired" (by the way I just said "crosscheck" and you wrote "crosscheck backup")
3/ The error message said:
Quote:
syntax error: found ";": expecting one of: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"

It is not difficult to know what is missing in your command.

Regards
Michel
Previous Topic: Restore Database in Prior Time
Next Topic: How I can backup into Different Directory.
Goto Forum:
  


Current Time: Mon Dec 23 19:07:31 CST 2024