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;

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips