Re: What happens during open resetlogs?

From one of my old notes ;)

The following checks are done while opening the database using resetlogs . 1). The compatibility version of the header of the datafile is verified against the current compatible setting of the database. It must be in sync with the current compatible setting.
2). All offline data files must be either recovered or dropped. No archive logs can be applied once the database is opened with resetlogs. 3). All datafiles should be check pointed at the same SCN. This usually happens with any normal shutdown or immediate shutdown. Only during a crash or abort shutdown will datafiles have different SCNs.

--

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ Coming soon...Oracle RAC Handbook...Oracle Press 2006

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 23 2006 - 21:29:39 CDT