The redo log being copied must be copied successfully to at least one of the destinations
before it can be reused by the database. The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter
defaults to 1 and must be at least 1. If none of the copy operations are successful, the database
will be suspended until at least one of the destinations receives the log file. Running out of disk
space is one possible reason for this type of failure.
If the destination for the archived log files is on a local file system, an operating system
shell script can monitor the space usage of the destination, or it can be scheduled with DBMS_
SCHEDULER or with OEM.
Built-in Space Management Tools
Oracle 10g provides a number of built-in tools that a DBA can use on demand to determine if
there are any problems with disk space in the database. Most, if not all, of these tools can be
manually configured and run by calling the appropriate built-in package. In this section, we??™ll
cover the packages and procedures used to query the database for space problems or advice
on space management. In addition, I??™ll show you the new initialization parameter used by the
Automatic Diagnostic Repository to identify the alert and trace file location. Later in this chapter,
you??™ll see how some of these tools can be automated to notify the DBA via e-mail or pager when
a problem is imminent; many, if not all, of these tools are available on demand via the EM
Database Control web interface.
Pages:
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337