Oracle Backup and Recovery Question:
Download Questions 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

Download Oracle Backup Recovery Interview Questions And Answers PDF

Previous QuestionNext Question
What is db_recovery_file_dest in oracle? When do you need to set this value?
Give me the steps to perform the point in time recovery with a backup which is taken before the reset logs of the db?
Tell me about the steps required to enable the RMAN backup for a target database?		What is the difference between recovery and restoring of the oracle database?