Home » RDBMS Server » Backup & Recovery » RMAN not deleting all archived logs (Oracle on Solaris 8)
RMAN not deleting all archived logs [message #432269] Mon, 23 November 2009 05:45 Go to next message
Messages: 817
Registered: December 2005
Senior Member

I have 12 gb of archivelogs in a database. i used rman to delete the archive logs by using the command:

rman> delete noprompt archivelog all;

But using the command does not delete all the archived logs and many arch. log files are still left. I am not using catalog database. is this because in control file the arch. log information is overwritten? Is it fine to delete the arch. logs manually instead of using rman?


Re: RMAN not deleting all archived logs [message #432271 is a reply to message #432269] Mon, 23 November 2009 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on many things.
Your retention policy for instance. Oracle will keep the logs it needs to satisfy it.

Re: RMAN not deleting all archived logs [message #432523 is a reply to message #432269] Tue, 24 November 2009 14:33 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
You may want to verify the value for CONTROL_FILE_RECORD_KEEP_TIME.
Previous Topic: expdp error
Next Topic: Setting MAXCORRUPT Parameter.
Goto Forum:

Current Time: Mon Oct 24 05:38:53 CDT 2016

Total time taken to generate the page: 0.09522 seconds