RelationalDBDesign RelationalDBDesign


Manual | Automatic Archiving   «Prev  Next»
Lesson 8

Oracle Virtual Memory Conclusion

In this module, we discussed the manual and automatic archiving of your redo log files. You should now be familiar with the following concepts:
  1. Normal ARCH processing
  2. Manual archiving of redo log files
  3. Automatic archive log file options
  4. Obtaining archive log information
  5. Standby databases
You can also review the init.ora parameters that were covered up to this point.

init.ora parameters

init.ora parameter Description
LARGE_POOL_SIZE This is how you create the Large Pool. When the Instance starts, it allocates the requested memory in the SGA.
LARGE_POOL_MIN_ALLOC This is the smallest chunk that is allocated.
ARCH_IO_SLAVES This is the number of IO slaves used for log archiving.
BACKUP_DISK_IO_SLAVES This is the number of IO slaves used by RMAN for copy, backup, and restore.
BACKUP_TAPE_IO_SLAVES If True, then one IO slave is used to perform asynchronous IO to and from tape when doing an RMAN backup and restore.
LOG_ARCHIVE_DEST This parameter indicates where the archive log files will be written.
LOG_CHECKPOINT_INTERVAL This parameter causes a checkpoint when the specified number of OS blocks have been written to the redo log files since the last checkpoint.
LOG_CHECKPOINT_TIMEOUT This parameter causes a checkpoint when the specified number of seconds has elapsed since the last checkpoint.
USER_DUMP_DEST This is the directory that contains the output from your trace commands.
LOG_ARCHIVE_DEST This is the location for archive log files.
LOG_ARCHIVE_FORMAT This is the format of the name for the archive log files.
LOG_ARCHIVE_DUPLEX_DEST This is the location for duplexed archive log files.
LOG_ARCHIVE_MIN_SUCCESS_DEST If your are duplexing your archive log files, this determines how many of the destination archive log files must succeed either 1 or 2.
LOG_ARCHIVE_START This starts automatic archiving of the redo logs when the instance starts.

Enabling Automatic Archiving Log Files - Exercise

Click the Exercise link below to complete this module's Troubleshooter.
Enabling Automatic Archiving Log Files - Exercise

Manual Archiving - Quiz

Click the Quiz link below to complete a module wrap-up quiz.
Manual Archiving - Quiz