About Automatic Startup of Database Services.You can specify nondefault locations for these files, and the method for doing so depends on whether you start the database with SQL*Plus (when Oracle Restart is not in use) or with SRVCTL (when the database is being managed with Oracle Restart). The database looks for these files in a default location. To start an instance, the database must read instance configuration parameters (the initialization parameters) from either a server parameter file ( SPFILE) or a text initialization parameter file (PFILE). Specifying Initialization Parameters at Startup.If your database is being managed by Oracle Restart, the recommended way to start the database is with SRVCTL. When Oracle Restart is not in use, you can start up a database instance with SQL*Plus, Recovery Manager, or Oracle Enterprise Manager Cloud Control (Cloud Control). The INSTANCE_ABORT_DELAY_TIME initialization parameter specifies the amount of time, in seconds, to delay shutting down a database when an error causes the instance to abort.
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)
