Hi,

I am new to Oracle and wonder someone may help me the question.

From Oracle Database Concepts 10g Release, it said one can close a
database; unmount the database; and shutdown the database.

What is procedure to close or unmount a database? Secondly what is best
way to write data and recovery data in SGA to datafile and redo log and
close control files? In Windows XP, it seems one of following: 1) SQL>
shutdown normal 2) end three processes from services of Control Panel.

Your help will be appreciated,
-Hong

Hong Hsu wrote:
One rarely, if ever, does anything other than just shut down the
database using SHUTDOWN IMMEDIATE or SHUTDOWN ABORT. The procedure
for the others is simply to use the appropriate ALTER statement
which you can find in the docs.

Your question about recovering data makes no sense. In what context
would you want to recover data in memory and why?

If you are working in Windows you need to nothing to start and stop
the database if the Windows services is set to auto other than turn
the machine on and turn it off. Oracle automatically takes care of
everything.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

DA Morgan wrote:
Can only shut down completely ... alter (mount and open) only works in
an upwards direction.

if you want to just close, you need to do startup mount force, but this
will bounce the database.