Use the Database Image page of the Restore Database SmartGuide to locate the log files. This page only appears if the log files cannot be found.
A database log is initially created in SQLOGDIR, which is a subdirectory of the database directory. If this directory runs out of space for additional logs, they will be placed in the overflow directory.
You may change the location where active logs and future archive logs are placed by changing the NEWLOGPATH configuration parameter. Archive logs stored in the database log path directory are not moved to the new log path directory if the database is configured for roll-forward recovery. Because you can change the log path directory, the logs needed for roll-forward recovery may exist in different directories. You can also change the overflow directory to allow you to access logs in these directories.
Controls
[ Top of Page | Table of Contents | Glossary | Index ]