OraFAQ Forum: Backup & Recovery » How to Delete All Backups (merged)

Home » RDBMS Server » Backup & Recovery » How to Delete All Backups (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Delete All Backups (merged) [message #243809]

Sat, 09 June 2007 03:25

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.

Report message to a moderator

How to Delete All Backups [message #243810 is a reply to message #243809]

Sat, 09 June 2007 03:27

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.

Report message to a moderator

Re: How to Delete All Backups [message #243812 is a reply to message #243810]

Sat, 09 June 2007 03:40

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: How to Delete All Backups (merged) [message #243823 is a reply to message #243809]

Sat, 09 June 2007 07:30

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?

Report message to a moderator

Re: How to Delete All Backups (merged) [message #243825 is a reply to message #243823]

Sat, 09 June 2007 07:55

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 09:47:02 CDT 2024