What is Restricted Mode of Instance Startup in Oracle?
Submitted by: AdministratorTo Enable Restricted Session
Alter system enable restricted session;
To Disable Restricted Session
Alter system disable restricted session;
To Start the Database in Restricted Mode
STARTUP RESTRICT
By starting Instance in restricted mode it will not allow all users to access and only users with restriction privilege will be allowed to access.
This will be done time of make some data changes so that no users should be allowed to access data on time of changes happening
Submitted by: Administrator
Alter system enable restricted session;
To Disable Restricted Session
Alter system disable restricted session;
To Start the Database in Restricted Mode
STARTUP RESTRICT
By starting Instance in restricted mode it will not allow all users to access and only users with restriction privilege will be allowed to access.
This will be done time of make some data changes so that no users should be allowed to access data on time of changes happening
Submitted by: Administrator
Read Online Oracle Backup Recovery Job Interview Questions And Answers
Top Oracle Backup Recovery Questions
| ☺ | What do you mean by Oracle MEDIA RECOVERY? |
| ☺ | What is the difference between oracle media recovery and crash recovery? |
| ☺ | What is Restricted Mode of Instance Startup in Oracle? |
| ☺ | What is the disk migration? what is the steps involved in oracle disk migration? |
| ☺ | Why more redos are generated when the oracle database is in begin backup mode? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
