Oracle Backup and Recovery Question:
Download Job Interview Questions and Answers PDF
What is Restricted Mode of Instance Startup in Oracle?
Answer:
To 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
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
Download Oracle Backup Recovery Interview Questions And Answers
PDF