Home » RDBMS Server » Server Utilities » Removed the current archive logs (Sun Solaris, Oracle 10.2.0.3)
Removed the current archive logs [message #522596] Mon, 12 September 2011 12:43 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Developer is importing some large volumes of data. As the filesystem was filling up fast, I removed the all the archive log files. Will this affect the functioning of database? It is a development environment.
Re: Removed the current archive logs [message #522597 is a reply to message #522596] Mon, 12 September 2011 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
. Will this affect the functioning of database?

No, just the ability to recover the database.

Quote:
It is a development environment.

In this case, you should go to noarchivelog mode before importing then switch back to archivelog mode after that and run a full backup.

Regards
Michel
Re: Removed the current archive logs [message #522600 is a reply to message #522597] Mon, 12 September 2011 13:21 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
No, just the ability to recover the database.

It would hamper the ability to recover the database or just the data which they are importing?
Re: Removed the current archive logs [message #522603 is a reply to message #522600] Mon, 12 September 2011 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The database or any part of it.
If you remove archiveg lods (without backing them up) then you can't recover anything from your database to a more recent point than the last archived logs before the first one you deleted.

Regards
Michel
Re: Removed the current archive logs [message #522605 is a reply to message #522603] Mon, 12 September 2011 13:41 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
"The database or any part of it.
If you remove archiveg lods (without backing them up) then you can't recover anything from your database to a more recent point than the last archived logs before the first one you deleted."


You mean to say that we wont be able to recover the database to the more recent point (time) without the current archive logs,but can recover until the period with whatever archivelogs are available. Right?
Re: Removed the current archive logs [message #522612 is a reply to message #522605] Mon, 12 September 2011 15:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes only to the point of the last archived log before which there is no one of the deleted archived logs.

Regards
Michel
Re: Removed the current archive logs [message #522613 is a reply to message #522612] Mon, 12 September 2011 15:19 Go to previous message
lg123
Messages: 225
Registered: August 2008
Senior Member
Thanks.
Previous Topic: Exclude badly formatted
Next Topic: Data Pump
Goto Forum:
  


Current Time: Tue Sep 30 13:49:13 CDT 2014

Total time taken to generate the page: 0.13001 seconds