Re: Log files deleted -- Are they recreated automatically?

On Wed, 30 Jul 1997, Jason Berryhill wrote:

> Greetings wise ORACLE practitioners:
>
> A nice fellow deleted the redo logs from my db when I wasn't looking.
> Never mind that, it is a long story. My question is: When the db was shut
> down normally, are all of the redo logs flushed to the archive file system
> (db is in archivelog mode)? If so, will the db re-create the log files
> that are defined in the init<sid>.ora file upon startup? I do have a
> full, off-line backup of the db, so I can recreate the files if needed.
>
> Any help or opinions are greatly appreciated.
>
> Jason Berryhill

I would KILL HIM first....The redo logs are achived as soon as they are cycled through, so in this instance all but the redo log in use will be archived. If you are running in a unix environment, the redo log in use will not be deleted until the process controlling it releases it, although the file will not be visible. This is why the database stayed up!! As soon as it needs to log switch it will die....
The answer to your questions:
1. all but the redo log in use will be archived. 2. The db will NOT recreate the log files upon startup. If the database did shutdown cleanly, I would restore the redo logs from your cold backup and start the database in reset log mode. I am assuming you are not using mirrored redo logs.

Good Luck...
Marg. Received on Fri Aug 01 1997 - 00:00:00 CDT