Home » RDBMS Server » Server Administration » Manual deleting Archived Log files (Oracle 10.2.0, Fedora 6, RedHat 5.3)
Manual deleting Archived Log files [message #405703] Fri, 29 May 2009 02:35 Go to next message
linuxos
Messages: 31
Registered: April 2009
Member
I'm novice in administration and find my server running low of disk space. And I checked there are many files inside the archived log directory. After I shutdown the database, can I manually delete all archived log files?

What are the harms of doing this? Is there any info stored in the control file, system.dbf or sysaux.dbf?

Urgent!

[Updated on: Fri, 29 May 2009 02:47]

Report message to a moderator

Re: Manual deleting Archived Log files [message #405706 is a reply to message #405703] Fri, 29 May 2009 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Urgent!

Explain what it is urgent for the forum readers; I don't think it is.
Please read OraFAQ Forum Guide.

Quote:
can I manually delete all archived log files?

Yes, as soon as you backup your database and possibly the archived logs themselves.

Regards
Michel
Re: Manual deleting Archived Log files [message #405925 is a reply to message #405703] Sun, 31 May 2009 21:28 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
Does it mean the archived log files are used for rollback to previous image only? If I don't need to rollback those data, all I need to do is to backup the data files and control files only.

Am I right?
Re: Manual deleting Archived Log files [message #405926 is a reply to message #405703] Sun, 31 May 2009 22:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, please Read The Fine Manuals found at http://tahiti.oracle.com

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#sthref2340
Re: Manual deleting Archived Log files [message #405928 is a reply to message #405703] Sun, 31 May 2009 22:38 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
If I don't need recovery, it's not useful at all. I can recover from the backup of data files. Isn't it?

[Updated on: Sun, 31 May 2009 22:39]

Report message to a moderator

Re: Manual deleting Archived Log files [message #405929 is a reply to message #405703] Sun, 31 May 2009 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> I can recover from the backup of data files. Isn't it?
It depends upon how backups were made, when they were made & how current restoration needs to be.
Re: Manual deleting Archived Log files [message #405934 is a reply to message #405925] Mon, 01 June 2009 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
linuxos wrote on Mon, 01 June 2009 04:28
Does it mean the archived log files are used for rollback to previous image only? If I don't need to rollback those data, all I need to do is to backup the data files and control files only.

Am I right?

Archived log are NEVER used to rollback data (exception for recover phase).

I recommend you to read Database Concepts

Regards
Michel

Re: Manual deleting Archived Log files [message #408047 is a reply to message #405703] Sat, 13 June 2009 05:34 Go to previous message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

If you made a backup of your database and WILL USE archived redo log files further to apply to backup of your database when your database crashes, then you HAVE to SAVE those archived redo log files, which were generated after full backup of the database

If you WILL NOT apply any archived redo log files to the backup of the database, then you can delete them manually

Anyway, it depends on your Backup and Recovery Strategy
Previous Topic: Oracle Shutdown
Next Topic: Oracle Patchset 10gR2 10.2.0.3
Goto Forum:
  


Current Time: Tue Jul 02 23:01:16 CDT 2024