RE: Creating a controlfile - language needed?

Brandon,

Shutdown immediate is a controlled crash.

Do a shutdown immediate. Then a startup. Review the alert.log file. Your will see a recovery takes place.

Compare this with a shutdown and a shutdown abort.

Simple test to see how it works.

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon Sent: Tuesday, October 04, 2005 12:35 PM To: oracledba.williams_at_gmail.com; makbo_at_pacbell.net Cc: oracle-l_at_freelists.org
Subject: RE: Creating a controlfile - language needed?

>From the referenced web page: "Do not shutdown abort or immediate as
these will require instance recovery."

Am I missing something, or is that statement incorrect? I've never heard of shutdown immediate requiring instance recovery.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Dennis Williams Sent: Tuesday, October 04, 2005 9:02 AM

There are several documents on the web that describe this process, for example:
http://www.jlcomp.demon.co.uk/faq/db_move.html.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l