Oracle Corporation
  ORACLE.COM     PARTNERS     BUY     DOWNLOAD     SUPPORT     CONTACT US   
SEARCH


Legal | Privacy
Changing the Database Archiving Mode

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

Move your mouse over this icon to see the image

 
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

Move your mouse over this icon to see the image

 
5.

Place the database in ARCHIVELOG mode:

ALTER DATABASE ARCHIVELOG;

Move your mouse over this icon to see the image

 
6.

Open the database:

ALTER DATABASE OPEN;

Move your mouse over this icon to see the image

 
7.

Verify your changes:

ARCHIVE LOG LIST

Move your mouse over this icon to see the image

 

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. :

Move your mouse over this icon to see the image

 
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 :

Move your mouse over this icon to see the image

 
6.

Verify your change on the General page :

Move your mouse over this icon to see the image

 
7.

Open your database on the General page.

 

Move your mouse over this icon to hide all screenshots
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy