Re: Are redo logs flushed after instance shutdown?

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
>
> ====================================================================
> =Web Site: http://www.ecst.csuchico.edu/~speck =
> =email: speck_at_ecst.csuchico.edu or jberryhill_at_cepo.csuchico.edu =
> = =
> =BASIS Support Team. College of Business SAP R/3 class Spr 97 =
> = California State University, Chico =
> = =
> = And He looked up and saw the rich putting their gifts into the =
> =treasury. And He saw also a certain poor widow putting in two =
> =mites. So He said, "Truly I say to you that this poor widow has =
> =put in more than all; =
> = For all these out of their abundance have =
> =put in offerings to God, but she out of her poverty put in all =
> =the livelihood that she had." =
> ====================================================================

No, they are not. Only the checkpoint is performed, so all your datafiles are in the consistent state. To recreate the redo logs you are to open your database with RESETLOGS option. Since it "starts a new life" for the database (you will not be able to make recovery using previous backups - BTW in ORACLE8 there is a term "new database incarnation") make the full backup before doing that.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen_at_ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.