Home » RDBMS Server » Server Administration » Batch file for del old backup files
Batch file for del old backup files [message #287102] Tue, 11 December 2007 01:45 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I had backup with rman already but I also to implement exp backup every day (backup_yyyymmdd.dmp)and i want to keep 5 days and del the old files.Is there anybody have a batch file script for del the old files after 5 days?

Thanks for advance

Chara
Re: Batch file for del old backup files [message #287106 is a reply to message #287102] Tue, 11 December 2007 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OS?

Regards
Michel
Re: Batch file for del old backup files [message #287108 is a reply to message #287102] Tue, 11 December 2007 01:49 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

For rman you can achive the task task easily by configuring flash recovery area.(retention policy)
Re: Batch file for del old backup files [message #287116 is a reply to message #287108] Tue, 11 December 2007 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think the question was about the dmp files.

Regards
Michel
Re: Batch file for del old backup files [message #287224 is a reply to message #287102] Tue, 11 December 2007 08:23 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
find . -mtime +5 -name "*dmp" -exec rm -f {} \;
Re: Batch file for del old backup files [message #287227 is a reply to message #287224] Tue, 11 December 2007 08:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thanks for reply.
but OP is looking for windows OS

@micheal
OP mention OS & Oracle Version in Thread Heading.


[Updated on: Tue, 11 December 2007 08:36]

Report message to a moderator

Re: Batch file for del old backup files [message #287229 is a reply to message #287227] Tue, 11 December 2007 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry but I didn't and still don't see it, neither here nor in forum post list.

Regards
Michel

[Updated on: Tue, 11 December 2007 08:40]

Report message to a moderator

Re: Batch file for del old backup files [message #287233 is a reply to message #287229] Tue, 11 December 2007 08:47 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Micheal,
I don't know what is mistery behind this but when i was replying it is showing in thread heading, it was "ORACLE 9i & Window 2000". But your correct right now it is not showing.

Previous Topic: Database running slowly - URGENT help needed
Next Topic: patching
Goto Forum:
  


Current Time: Tue Dec 06 06:23:41 CST 2016

Total time taken to generate the page: 0.13808 seconds