OraFAQ Forum: Server Administration » Batch file for del old backup files

Home » RDBMS Server » Server Administration » Batch file for del old backup files

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

Batch file for del old backup files [message #287102]

Tue, 11 December 2007 01:45

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

Report message to a moderator

Re: Batch file for del old backup files [message #287106 is a reply to message #287102]

Tue, 11 December 2007 01:48

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

Senior Member
Account Moderator

OS?

Regards
Michel

Report message to a moderator

Re: Batch file for del old backup files [message #287108 is a reply to message #287102]

Tue, 11 December 2007 01:49

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)

Report message to a moderator

Re: Batch file for del old backup files [message #287116 is a reply to message #287108]

Tue, 11 December 2007 02:02

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

Senior Member
Account Moderator

I think the question was about the dmp files.

Regards
Michel

Report message to a moderator

Re: Batch file for del old backup files [message #287224 is a reply to message #287102]

Tue, 11 December 2007 08:23

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

find . -mtime +5 -name "*dmp" -exec rm -f {} \;

Report message to a moderator

Re: Batch file for del old backup files [message #287227 is a reply to message #287224]

Tue, 11 December 2007 08:34

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

Michel Cadot
Messages: 68686
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

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:04:16 CDT 2024