Search This Blog

Saturday, February 24, 2007

Oracle Database Shutdown

For COLD DATABASE BACKUP and DATABASE MAINTAINCE we have to shutdown database in clean stage.

for that we can use
1.shutdown normal;
2.shutdown immediate;
3.shutdown transactional;
4.stop oracle services through NET STOP ORACLESERVICE on command prompt. or through SERVICES WINDOWS.

1 comment:

Anonymous said...

I am afraid that shutting down the services shall shuts down oracle database as Shutdown Abort, which is not helthy for backups and will require recovery process after opening the database.