OraFAQ Forum: Backup & Recovery » Delete archive logs

Home » RDBMS Server » Backup & Recovery » Delete archive logs (oracle 10g,unix)

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

Delete archive logs [message #403260]

Thu, 14 May 2009 08:38

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi ,

Is there any command or script to delete archive logs from primary database that are older than a month in rman.

Thanks

Report message to a moderator

Re: Delete archive logs [message #403263 is a reply to message #403260]

Thu, 14 May 2009 09:01

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are many RMAN and shell ones available here or on web.

Regards
Michel

Report message to a moderator

Re: Delete archive logs [message #403268 is a reply to message #403260]

Thu, 14 May 2009 09:16

msmanan
Messages: 1
Registered: May 2009
Location: India

Junior Member

Execute this on RMAN prompt....... Smile

RMAN> run{
2> allocate channel abc device type disk;
3> resync catalog;
4> crosscheck archivelog all;
5> delete noprompt archivelog all completed before 'sysdate-30';
6> release channel abc;
7> }

Report message to a moderator

Re: Delete archive logs [message #403273 is a reply to message #403268]

Thu, 14 May 2009 10:04

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

These were the steps i was expecting.

thank you Smile

[Updated on: Thu, 14 May 2009 10:10]

Report message to a moderator

Re: Delete archive logs [message #403277 is a reply to message #403273]

Thu, 14 May 2009 10:17

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Mohan10g wrote on Thu, 14 May 2009 17:04

These were the steps i was expecting.

thank you Smile

In this case a good reading is Database Backup and Recovery Reference

[Edit] in addition to Database Backup and Recovery Basics you have been pointed to in your previous post.

Regards
Michel

[Updated on: Thu, 14 May 2009 10:19]

Report message to a moderator

Re: Delete archive logs [message #404021 is a reply to message #403260]

Wed, 20 May 2009 02:11

fairdaus
Messages: 14
Registered: May 2009
Location: KL

Junior Member

can use this also

rman> list backup of archivelog all;

will list all archivelog already backup

List of Archived Logs in backup set 112048
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 85 23398272426 25-APR-09 23398393172 26-APR-09
1 86 23398393172 26-APR-09 23398412635 26-APR-09
1 300 2850593172601 30-APR-09 2850593195087 30-APR-09
1 301 2850593195087 30-APR-09 2850593216880 30-APR-09
1 302 2850593216880 30-APR-09 2850593247098 30-APR-09
1 303 2850593247098 30-APR-09 2850593259861 30-APR-09
1 304 2850593259861 30-APR-09 2850593272254 30-APR-09
1 305 2850593272254 30-APR-09 2850593285057 30-APR-09
1 306 2850593285057 30-APR-09 2850593298261 30-APR-09
1 307 2850593298261 30-APR-09 2850593310886 30-APR-09
1 308 2850593310886 30-APR-09 2850593324541 30-APR-09
1 309 2850593324541 30-APR-09 2850593337434 30-APR-09
1 310 2850593337434 30-APR-09 2850593350469 30-APR-09
1 311 2850593350469 30-APR-09 2850593388996 30-APR-09
1 312 2850593388996 30-APR-09 2850593401821 30-APR-09
1 313 2850593401821 30-APR-09 2850593415047 30-APR-09
1 314 2850593415047 30-APR-09 2850593427634 30-APR-09
1 315 2850593427634 30-APR-09 2850593440835 30-APR-09
1 316 2850593440835 30-APR-09 2850593453915 30-APR-09
1 317 2850593453915 30-APR-09 2850593466916 30-APR-09
1 318 2850593466916 30-APR-09 2850593480006 30-APR-09
1 329 2850593608304 30-APR-09 2850593629774 30-APR-09
1 330 2850593629774 30-APR-09 2850593642370 30-APR-09
1 331 2850593642370 30-APR-09 2850593655429 30-APR-09
1 332 2850593655429 30-APR-09 2850593668901 30-APR-09
1 333 2850593668901 30-APR-09 2850593681392 30-APR-09
1 334 2850593681392 30-APR-09 2850593694478 30-APR-09
1 335 2850593694478 30-APR-09 2850593707500 30-APR-09
1 336 2850593707500 30-APR-09 2850593720385 30-APR-09
1 337 2850593720385 30-APR-09 2850593733443 30-APR-09
1 338 2850593733443 30-APR-09 2850593746550 30-APR-09
1 400 2850594630461 01-MAY-09 2850594685111 01-MAY-09

and u want delete all archivelog before 01-MAY-09

RMAN> delete archivelog until logseq=338;

tq

Report message to a moderator

Re: Delete archive logs [message #408080 is a reply to message #404021]

Sat, 13 June 2009 11:58

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

good one. thanks

Report message to a moderator

Previous Topic:	Recovering Corrupt Redolog
Next Topic:	unable to take backup urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 22 20:19:18 CDT 2026