Startup Database At Restricted Mode.

We can start the database in restricted mode. Restricted mode will only allow users with special privileges to access the database (typically DBA’s), even though the database is technically open. 
We use the startup restrict command to open the database in restricted mode as seen in this example.


 DB INSTACNE STATUS:- 

INSTANCE_NAME    HOST_NAME            STARTUP_T STATUS       ARCHIVE INSTANCE_ROLE      DATABASE_STATUS   LOGINS
---------------- -------------------- --------- ------------ ------- ------------------ ----------------- ----------
najaf            NAJAFS               23-DEC-14 OPEN         STARTED PRIMARY_INSTANCE   ACTIVE         ALLOWED










 
Enable the restricted mode- Method 1-
 
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup restrict;
ORACLE instance started.

Total System Global Area 1686925312 bytes
Fixed Size                  2176368 bytes
Variable Size            1090521744 bytes
Database Buffers          587202560 bytes
Redo Buffers                7024640 bytes
Database mounted.
Database opened.
SQL>
SQL> select instance_name,host_name,startup_time,status,archiver,instance_role,database_status,logins from v$instance;

INSTANCE_NAME    HOST_NAME            STARTUP_T STATUS       ARCHIVE INSTANCE_ROLE      DATABASE_STATUS   LOGINS
---------------- -------------------- --------- ------------ ------- ------------------ ----------------- ----------
najaf            NAJAFS               24-DEC-14 OPEN         STARTED PRIMARY_INSTANCE   ACTIVE         RESTRICTED


 
Disable the restricted mode - Method-1-
 
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1686925312 bytes
Fixed Size                  2176368 bytes
Variable Size            1090521744 bytes
Database Buffers          587202560 bytes
Redo Buffers                7024640 bytes
Database mounted.
Database opened.
SQL>
SQL> select instance_name,host_name,startup_time,status,archiver,instance_role,database_status,logins from v$instance;

INSTANCE_NAME    HOST_NAME            STARTUP_T STATUS       ARCHIVE INSTANCE_ROLE      DATABASE_STATUS   LOGINS
---------------- -------------------- --------- ------------ ------- ------------------ ----------------- ----------
najaf            NAJAFS               24-DEC-14 OPEN         STARTED PRIMARY_INSTANCE   ACTIVE         ALLOWED


 

Enable the restricted mode - Method 2-
 
SQL> alter system enable restricted session;

System altered.

SQL> select instance_name,host_name,startup_time,status,archiver,instance_role,database_status,logins from v$instance;

INSTANCE_NAME    HOST_NAME            STARTUP_T STATUS       ARCHIVE INSTANCE_ROLE      DATABASE_STATUS   LOGINS
---------------- -------------------- --------- ------------ ------- ------------------ ----------------- ----------
najaf            NAJAFS               24-DEC-14 OPEN         STARTED PRIMARY_INSTANCE   ACTIVE         RESTRICTED

 

Disable the restricted mode- Method 2- 
 
SQL> alter system disable restricted session;

System altered.

SQL> select instance_name,host_name,startup_time,status,archiver,instance_role,database_status,logins from v$instance;

INSTANCE_NAME    HOST_NAME            STARTUP_T STATUS       ARCHIVE INSTANCE_ROLE      DATABASE_STATUS   LOGINS
---------------- -------------------- --------- ------------ ------- ------------------ ----------------- ----------
najaf            NAJAFS               24-DEC-14 OPEN         STARTED PRIMARY_INSTANCE   ACTIVE         ALLOWED