Tuesday, April 15, 2008

Options for Shuting Down a Database

1)Shutdown a Database Using SQL*Plus
-----------------------------------------------

$sqlplus /nolog
SQL>conn / as sysdba
SQL>stutdown immediate

2)Shutdown a Database Using Recovery Manager
---------------------------------------------------
1)oracle@neptune:~$ rman target /


Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 15 18:08:04 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database (not started)

2)RMAN> shutdown immediate

3)Shutdown Database Using Oracle Enterprise Manager
---------------------------------------------------------------

logon to Enterprise Manager.
Under Home there is general tab. select shutdown
Enter host and database credentials.
The default is shutdown immediate. From advance options you can choose another one.
Press yes.

No comments:

Post a Comment