Home » RDBMS Server » Backup & Recovery » How to delete archive log automatically (Oracle 10g Windows server 2008)
How to delete archive log automatically [message #458010] Wed, 26 May 2010 12:32 Go to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
Hi

I am using oracle 10g. Currently it is in No archive mode.
And I want to change the mode of my DB from no archive to archive.
But the problem is after changing this mode it will create logs and take too much disk space day by day.
Usually I want to keep three weeks of archive log.
So I would like to know what is the correct way and procedure to remove archive log and to keep only three weeks of it.
Thanks.

Best Regards//
Neha Verma
Re: How to delete archive log automatically [message #458011 is a reply to message #458010] Wed, 26 May 2010 12:35 Go to previous messageGo to next message
BlackSwan
Messages: 22688
Registered: January 2009
Senior Member
>So I would like to know what is the correct way and procedure to remove archive log and to keep only three weeks of it.

Does this mean that you'll be doing a FULL backup at least once every 3 weeks?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: How to delete archive log automatically [message #458012 is a reply to message #458010] Wed, 26 May 2010 12:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
By backing it up?
Backup the archivelogs and delete them.
RMAN command
DELETE ARCHIVELOG UNTIL TIME ..

would help.
Please search google/documentation for the exact option.


Re: How to delete archive log automatically [message #458060 is a reply to message #458011] Thu, 27 May 2010 02:52 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
Hi

Yes I want to take FULL backup at least once every 3 weeks.
Kindly provide me full detail about how to delete archive logs automatically using RMAN after every week or perodically.

BR//
Neha
Re: How to delete archive log automatically [message #458067 is a reply to message #458060] Thu, 27 May 2010 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 58856
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you only backup every 3 weeks you MUST NOT delete archived logs every week, you must keep them from at least the backup.

Details are in documentation, please read it first and then come back if you have any problem.

Regards
Michel
Re: How to delete archive log automatically [message #458168 is a reply to message #458010] Thu, 27 May 2010 12:38 Go to previous message
saikrishn2000
Messages: 2
Registered: May 2010
Location: United States
Junior Member

add "delete input" to your backup script and it will delete them after backup.

Thanks
Previous Topic: Archive log files
Next Topic: Backup Flat files to netbackup
Goto Forum:
  


Current Time: Thu Aug 21 21:09:58 CDT 2014

Total time taken to generate the page: 0.10857 seconds