startup

Start the database in single user mode or restricted access mode

     svrmgrl> STARTUP RESTRICT

Make a running database into resticted mode

     svrmgrl> ALTER SYSTEM ENABLE RESTRICTED SESSION

Diabling Restricted mode for a database

     svrmgrl> ALTER SYSTEM DISABLE RESTRICTED SESSION

How to check whether system is in restricted mode

     svrmgrl> SELECT LOGINS from V$INSTANCE;
     LOGINS
     ----------
     RESTRICTED

Start the database in Archive log mode

     Add the following parameters in initSID.ora file
         log_archive_dest=/export/home/oracle/admin/DN_NAME/arch   -- (arch log dir path)
         log_archive_format=%S_%T.ARC
	 log_archive_start=TRUE


     Invoke svrmgrl 
	 svrmgrl> connect internal;
     	 svrmgrl> startup nomount;

	
     	 svrmgrl> alter database mount;
     	 svrmgrl> archive log list;              -- Check for Archive log mode
     	 svrmgrl> alter database archivelog;
     	 svrmgrl> alter database open;

   
     	 svrmgrl> alter system checkpoint;       -- Switch logs and verify log files
      	 svrmgrl> alter system switch logfile;
     	 svrmgrl> alter system switch logfile;

Three stages of database startup

        
	 svrmgrl> startup nomount pfile=/export/home/oracle/admin/SID/pfile/initSID.ora;
         or
         svrmgrl> startup nomount;

         Tip: During this nomount stage, only control files are identified and instance is started


         
         svrmgrl> startup mount;
         or
         svrmgrl> alter database mount;

         Tip: During this stage, database files are verified.

         svrmgrl> startup open;
	 or
         svrmgrl> alter database open

         Tip: Does media recovery if any, Database is opened for external users.

Want to shutdown databases safely, but many processes are still conneted

 
         svrmgrl> connect internal;
         svrmgrl> shutdown abort;
         svrmgrl> startup restrict;
         svrmgrl> shutdown;
         or
         svrmgrl> connect internal;
         svrmgrl> shutdown immediate;