RESTRICTED SESSION

RESTRICTED SESSION

(1) Required Privileges

You must have the ALTER DATABASE system privilege.
To specify the RECOVER clause, you must also have the SYSDBA system privilege.

(2) Open the database -- READ ONLY / READ WRITE:

Example

The following statement opens the database in read-only mode:
ALTER DATABASE OPEN READ ONLY;

The following statement opens the database in read/write mode and clears the online redo logs:
ALTER DATABASE OPEN READ WRITE RESETLOGS;

(3) enable and disable a restricted session

alter system enable restricted session;

alter system disable restricted session;

to identify if the database is in that mode

select logins from v$instance;

In 10.2.0.3.0

ALTER SYSTEM QUIESCE RESTRICTED;

Related Posts: