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;

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;

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

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.