The commands listed in the above steps should be issued from SQL * Plus.
If you are using Oracle's Enterprise Manager software, you have the option of using Instance Manager for steps 3-5. The following simulation shows you how:
Archivelog mode is a special mode of database operation that requires a copy to be made of each redo log file before it can be reused. If you want to recover all changes to your database in the event of a loss, you need to run your database in archivelog mode and you need to archive your log files.
To place a database into archivelog mode, follow these steps:
- Shut down the database.
- Back up the database.
- Mount the database (using the
STARTUP MOUNT command).
- Issue the
ALTER DATABASE ARCHIVE LOG command to enable archivelog mode.
- Open the database (using the
ALTER DATABASE OPEN command).
It is important to understand that placing a database into archivelog mode ensures that Oracle will not overwrite a redo log file until it has been copied to the archive log destination. Once you place a database into archivelog mode, you have to choose between either manually archiving your redo logs or having Oracle do that for you. You'll learn how to make that choice later in this module.
In the next lesson, you will specify the directory to which Oracle archives log files.