Oracle Database Startup and Shutdown

Starting the oracle database;

startup nomount;
startup mount;
startup;

startup nomunt;
alter database mount;
alter database open;


Shutdown the databsae:
shutdown normal;
shutdown imediate;
shutdwon transactional;
shutdown abort;

Converting the oracle database from Noarchive log mode to Archive log mode

Converting the oracle database from Noarchive log mode to Archive log mode:

1. Check weather the database is in archive log mode or not.

archive log list

2. Shutdown the database.

shutdown immediate;

3. Start the database in mount mode.

startup mount;

4. Convert the database to archive log mode.

alter database archivelog;

5. Open the database.

alter database open ;

6. Check wheather the database is in archive log mode or not.

archive log mode;

Note: After the database is in archive log mode you must take the full database backup.