Unless a database device is mirrored, full recovery requires that a database’s transaction log be stored on a different device from the actual data (including indexes) of a database. In the event of a hard disk failure, you can create an up-to-date database by loading a dump of the database and then applying the log records that were safely stored on another device. See Chapter 6, “Creating and Managing User Databases,” in System Administration Guide: Volume 2 for information about the log on clause of create database.
