Enabling Automatic Archiving

Purpose

This module describes how you can enable automatic archiving of redo log files.

Topics

This module discusses the following:

	Overview
	Enabling Automatic Archiving at Instance Startup Using SQL*Plus
	Enabling Automatic Archiving at Instance Startup Using EM
	Enabling Automatic Archiving After Instance Startup Using SQL*Plus
	Enabling Automatic Archiving After Instance Startup Using EM

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 enable automatic archiving. You can do this by setting the LOG_ARCHIVE_START initialization parameter to TRUE. This is not a dynamic parameter, so you must restart your instance after setting the value to TRUE. When the value is TRUE the archiver process starts automatically upon instance startup. Refer to the following sections for detailed instructions:

	Enabling Automatic Archiving at Instance Startup Using SQL*Plus
	Enabling Automatic Archiving at Instance Startup Using EM

You can also start the archiver process without setting the LOG_ARCHIVE_START initialization parameter. However, if you start it in this way, it will not start again if you shut down your instance. This is sometimes referred to as manually starting automatic archiving. Refer to the following sections for detailed instructions:

	Enabling Automatic Archiving After Instance Startup Using SQL*Plus
	Enabling Automatic Archiving After Instance Startup Using EM

Enabling Automatic Archiving at Instance Startup Using SQL*Plus

Back to List of Topics

You can enable automatic archiving of filled redo log files with the LOG_ARCHIVE_START initialization parameter. You must set it to TRUE to start the archiver background process at instance startup.

Specify LOG_ARCHIVE_START=TRUE in the initialization parameter file and restart your instance.

If you are using a server parameter file (SPFILE), you can enable automatic archiving at instance startup by performing the steps below:

ALTER SYSTEM SET log_archive_start=true SCOPE=spfile;

SHUTDOWN IMMEDIATE

STARTUP

ARCHIVE LOG LIST

Enabling Automatic Archiving at Instance Startup Using Enterprise Manager

Back to List of Topics

You must set the value of the LOG_ARCHIVE_START initialization parameter to TRUE. You can accomplish that by performing the steps that follow.

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

Enabling Automatic Archiving After Instance Startup Using SQL*Plus

Back to List of Topics

You can enable automatic archiving without shutting down the instance by following the steps outlined below. This does not change the value of LOG_ARCHIVE_START in the initialization parameter file. You must set the value to TRUE to enable automatic archiving when the instance is started again. LOG_ARCHIVE_START is a static parameter so you cannot change it with the ALTER SYSTEM command.

Enable archiving at instance startup by performing the steps below:

ALTER SYSTEM ARCHIVE LOG START;

ARCHIVE LOG LIST

Enabling Automatic Archiving After Instance Startup Using Enterprise Manager

Back to List of Topics

You can enable automatic archiving without shutting down the instance by following the steps outlined below. This does not change the value of LOG_ARCHIVE_START in the initialization parameter file. You must set the value to TRUE to enable automatic archiving when the instance is started again.

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

Move your mouse over this icon to hide all screenshots