Home » RDBMS Server » Backup & Recovery » Archive log files (Oracle 10g, 10.2.0.4.0, Solaris 8)
Archive log files [message #457808] Wed, 26 May 2010 01:40 Go to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

How important is the archived log files? I accidentally deleted some of this files (old and current) at the OS level. Pls. help me on what to do next.

Thanks.
Re: Archive log files [message #457819 is a reply to message #457808] Wed, 26 May 2010 01:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your backups are now useless. You should backup immediately.
Re: Archive log files [message #457846 is a reply to message #457819] Wed, 26 May 2010 02:44 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Although we had a backup since 4pm yesterday (May 25, 2010), those I deleted were months of April and May, 2010 and the current log file, re: May 26, 2010.
Re: Archive log files [message #457847 is a reply to message #457846] Wed, 26 May 2010 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Archive log files [message #457848 is a reply to message #457847] Wed, 26 May 2010 02:56 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
and the current log file
If this means what it says, it is a disaster: you will lose data. What state is your database in?
If it is open, you did NOT delete all copies of your current logfile. Perform a full backup immediately, and you will be OK.
If the instance terminated, and on startup stops in mount mode, then your current logfile was indeed deleted, and you must perform an incomplete recovery. You will lose data, and will have to face the consequences as defined in your service level agreement.
Re: Archive log files [message #457851 is a reply to message #457848] Wed, 26 May 2010 03:19 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Currently the db is up. I just performed an export of all tables with parameter of CONSISTENT=y... while our SysAdm perform restoration of the deleted archive logfiles (OS level).
Re: Archive log files [message #457988 is a reply to message #457808] Wed, 26 May 2010 10:42 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

What I mean was that I accidentally deleted a .dbf files in this directory: /u1archive/tram/tramarch (path for the archived log files consisting of *.dbf files)... so far there is nothing alarming errors posted in the alertlog.
Re: Archive log files [message #457993 is a reply to message #457988] Wed, 26 May 2010 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If your .dbf files are archived logs, there is nothing alarming at all... until you have to recover the database as archived logs are only used for this.
This is why the advice was "You should backup immediately".

Regards
Michel
Re: Archive log files [message #458042 is a reply to message #457993] Wed, 26 May 2010 23:50 Go to previous message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Sir, thank you very much for this interesting response.
Previous Topic: RMAN BACKUP from SNAPSHOT
Next Topic: How to delete archive log automatically
Goto Forum:
  


Current Time: Thu Mar 28 19:06:20 CDT 2024