Startup database in Restrict Mode

Start the database in Restrict Mode

Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index, remove fragmentation etc. It is very use full for DBA for start database in restricted mode for planned maintenance activity. So, No other user such as application users are able to connect with database until they have special rights.
startup restrict command: will open database in restricted mode.

Start the database in restricted mode:

Shutdown the database:
SQL> Shutdown immediate;

Start the database in restricted mode,So, no other user able to connect:
SQL> startup restrict;

Check the database in restricted mode

SQL> Select logins from v$instance;
LOGINS
--------------
RESTRICTED

Disable the session restricted mode or you can normal start the database.

SQL> alter system disable restricted session;
 
Check the status that restricted mode is disable:

SQL> Select logins from v$instance;
LOGINS
--------------
ALLOWED

Without restart the database, we put it in restricted mode:

alter system enable restricted session;

Note: If restricted session is blocked by some session.May need to kill them if urgent. Check from v$session

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s