Home » RDBMS Server » Backup & Recovery » Which archive files are needed. (Oracle 10.2.0.4 Windows 2003 server.)
Which archive files are needed. [message #386991] Tue, 17 February 2009 08:58 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi Guys,

One of my production database is in Archive log mode. The database is generating so many log files each day.

I like to know whether there is a method to identify which archive log files are needed for backup so that i can remove the other unwanted archive log files to make free space in the server.

Thanks & Regards,
Seenu.
Re: Which archive files are needed. [message #386992 is a reply to message #386991] Tue, 17 February 2009 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Increase the size of the REDO LOG files & then you won't have so many.

Re: Which archive files are needed. [message #386993 is a reply to message #386992] Tue, 17 February 2009 09:03 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

thanks for your suggestion. I will increase the size of redo log files.

But i like to know whether any method is available to find which archived log files are needed for database backup and good functionality.

Thanks & Regards,
Seenu.
Re: Which archive files are needed. [message #386994 is a reply to message #386993] Tue, 17 February 2009 09:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>But i like to know whether any method is available to find which archived log files are needed for database backup and good functionality.

Very ambiguous question.
All archived logs are needed, unless you can always predict when your database may crash and when you will be asked to restore to what point in time.
Re: Which archive files are needed. [message #386995 is a reply to message #386991] Tue, 17 February 2009 09:12 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>But i like to know whether any method is available to find which archived log files are needed for database backup and good functionality.

To do a complete recovery, you need all redo log files generated since most recent complete FULL backup.
Previous Topic: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Next Topic: Restore to a different server - different versions?
Goto Forum:
  


Current Time: Sun Dec 04 10:58:08 CST 2016

Total time taken to generate the page: 0.10006 seconds