Prev | Current Page 631 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


If you enable archiving but do not specify any archiving locations, the archived log files reside
in a default, platform-dependent location; on Unix and Linux platforms the default location is
$ORACLE_HOME/dbs.
?– 
?– 
?– 
Chapter 11: Backup and Recovery Options 413
Each of the archived redo log files contains the data from a single online redo log. They are
numbered sequentially, in the order in which they were created. The size of the archived redo
log files varies, but it does not exceed the size of the online redo log files.
If the destination directory of the archived redo log files runs out of space, the ARCn processes
will stop processing the online redo log data and the database will stop itself. This situation can
be resolved by adding more space to the archived redo log file destination disk or by backing up
the archived redo log files and then removing them from this directory. If you are using the flash
recovery area for your archived redo log files, the database issues a warning alert if the available
space in the flash recovery area is less than 15 percent, and a critical alert when the available
space is less than 3 percent. Taking action at the 15 percent level, such as increasing the size or
changing the location of the flash recovery area, can most likely avoid any service interruptions,
assuming that there are no runaway processes consuming space in the flash recovery area.
The initialization parameter DB_RECOVERY_FILE_DEST_SIZE can also assist in managing the
size of the flash recovery area.


Pages:
619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643
pozycjonowanie Częstochowa bet365 nowoczesne domy grysieciowe22 solar panel for rv