Changing the Database Archiving Mode

Purpose

This module describes how you can change the database archiving mode.

Topics

This module discusses the following:

	Overview
	Using SQL*Plus to Change the Database Archiving Mode
	Using EM to Change the Database Archiving Mode

Viewing Screenshots

Move your mouse over this icon to show all screenshots. You can also move your mouse over each individual icon to see only the screenshot associated with it.

Overview

Back to List of Topics

In this module you will learn how to place the database in ARCHIVELOG mode. Note that you must also decide how you will handle the archiving of filled online redo log files. Refer to the Enabling Automatic Archiving and Performing Manual Archiving modules for additional information on archiving.

Using SQL*Plus to Change the Database Archiving Mode

Back to List of Topics

To change the archiving mode from NOARCHIVELOG to ARCHIVELOG, follow the steps below:

1.	Invoke SQL*Plus and connect as a user with SYSDBA privileges.
2.	Shut down the database instance using the NORMAL, IMMEDIATE, or TRANSACTIONAL option: SHUTDOWN IMMEDIATE
3.	Make a whole database backup including all data files and control files. You can use operating system commands or RMAN to perform this operation. This backup can be used in the future for recovery with archived redo log files that will be created once the database is in ARCHIVELOG mode.
4.	Start the instance and mount the database: STARTUP MOUNT
5.	Place the database in ARCHIVELOG mode: ALTER DATABASE ARCHIVELOG;
6.	Open the database: ALTER DATABASE OPEN;
7.	Verify your changes: ARCHIVE LOG LIST

Using EM to Change the Database Archiving Mode

Back to List of Topics

To change the archiving mode from NOARCHIVELOG to ARCHIVELOG using Enterprise Manager, follow the steps below.

Note: Oracle Enterprise Manager 9.2 was used in the examples.

1.	Select START > Programs > Oracle > OraHome92 > Enterprise Manager Console. Select Launch Standalone and click OK.
2.	Expand Databases. Expand your database. Expand Instance and select Configuration. Shut down your instance on the General page.
3.	Make a whole database backup including all data files and control files. You can use Enterprise Manager, RMAN, or operating system commands to perform this operation. This backup can be used in the future for recovery with archived redo log files that will be created once the database is in ARCHIVELOG mode.
4.	Expand Databases. Expand your database. Expand Instance and select Configuration. Start your instance and mount the database on the General page. :
5.	Expand Databases. Expand your database. Expand Instance and select Configuration. You can change the database archiving mode on the Recovery page. Check Archive Log Mode and click Apply :
6.	Verify your change on the General page :
7.	Open your database on the General page.