Use the ALTER SYSTEM RESUME statement to resume normal database operations. When the database is suspended all preexisting I/O operations are allowed to complete and any new database accesses are placed in a queued state. The suspended state lets you back up a database without I/O interference. The ALTER SYSTEM SUSPEND statement halts all input and output (I/O) to data files (file header and file data) and control files. You can shut down a database with SQL*Plus or Oracle Restart.Ī quiesced database allows only DBA transactions, queries, fetches, or PL/SQL statements.
You may want to do this in order to restrict access for maintenance reasons or to make the database read only. You can alter the availability of a database. Doing so makes the database available for any valid user to connect to and perform typical data access operations. Normally, you start up an instance by mounting and opening the database. When you start up a database, you create an instance of that database and you determine the state of the database.
0 kommentar(er)
