To unquiesce the database, use the following command:
alter system unquiesce;
158 Oracle Database 11g DBA Handbook
Instead of quiescing the database, you can suspend it. A suspended database performs no I/O
to its datafiles and control files, allowing the database to be backed up without I/O interference.
To suspend the database, use the following command:
alter system suspend;
NOTE
Do not use the alter system suspend command unless you have put
the database in hot backup mode.
Although the alter system suspend command can be executed from any SYSDBA privileged
account, you can only resume normal database operations from the SYS and SYSTEM accounts.
Use SYS and SYSTEM to avoid potential errors while resuming the database operations. In Real
Application Clusters configurations, all instances will be suspended. To see the current status of
the instance, use the following command:
select Database_Status from V$INSTANCE;
The database will be either SUSPENDED or ACTIVE. To resume the database, log in as SYS or
SYSTEM and execute the following command:
alter system resume;
Supporting Iterative Development
Iterative development methodologies typically consist of a series of rapidly developed prototypes.
These prototypes are used to define the system requirements as the system is being developed.
These methodologies are attractive because of their ability to show the customers something
tangible as development is taking place.
Pages:
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291