Re: Archive logs removal question
Date: Tue, 19 May 2009 13:53:42 -0700 (PDT)
Message-ID: <fed94767-1a35-48ed-935e-acf54ca36b02_at_i28g2000prd.googlegroups.com>
On May 19, 9:18 am, Richard <RSL..._at_gmail.com> wrote:
> This is a development db. I can recreate it. Is it safe to remove .arc
> up to the last active sequence ?
It depends. Can you recreate all the work your developers do?
As the others said, archived logs are used to recover from backups. Actually, recover transactions. If you truly don't need to do that, you don't need them. As with any other backup, you need to have an appropriate service level agreement. It's a production database for your developers, if they don't do anything that needs transactional recovery, heck, unless you are doing performance load testing you don't even need archivelogmode. But look up flashback in the docs, some places are using that to restore test databases these days, and also consider development often means things like changing table or other metadata, putting them logically ahead of production databases. So your recreation needs to account for such things.
jg
-- _at_home.com is bogus. "You've lost how many people's work?"Received on Tue May 19 2009 - 15:53:42 CDT