Mir Sayeed Hassan – Oracle Blog

How to Suspend and Resume a Database stage in Oracle 19c DB

– To perform the suspend database you have to use the alter system suspend command at database level., In this stage the datbase is completely suspended and does not any operation on database and database in the state of suspend as shown below.,
– To perform the resume database you have to use the alter system resume at database level, In this state the database will be revert back to the normal state from the suspended.

Note: It is not recommend to perform this on production database and normal shutdown of database.

Check the status of database

SQL> select status, open_mode, version from v$instance, v$database;

STATUS        OPEN_MODE      VERSION
--------------------------------------
OPEN         READ WRITE     19.0.0.0.0

Perform the database in suspended state.

SQL> alter system suspend;
System altered.

Check the status of database.

SQL> select database_status from v$instance;

DATABASE_STATUS
-----------------
SUSPENDED

Example: In case if you want to perform any operation in database in this suspended stage., the database will be in hung state as shown below

SQL> create table test(eno number(10));

HANG................. It will not allow to create a table.

Reverted it back to the normal state by issuing the resume command.

SQL> alter system resume
System altered.

Check the status of database.

SQL> select database_status from v$instance ;

DATABASE_STATUS
-----------------
ACTIVE

======Hence tested and verified in our test env======