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.

Report message to a moderator

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: 26766
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.

Report message to a moderator

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.

Report message to a moderator

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: 10708
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.

Report message to a moderator

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: 26766
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.

Report message to a moderator

Previous Topic: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Next Topic: Restore to a different server - different versions?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 14:53:39 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.