Disabling Automatic Archiving

Purpose

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

Topics

This module discusses the following:

	Overview
	Disabling Automatic Archiving at Instance Startup Using SQL*Plus
	Disabling Automatic Archiving at Instance Startup Using EM
	Disabling Automatic Archiving After Instance Startup Using SQL*Plus
	Disabling 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

You can disable automatic archiving of the online redo log files prior to starting the instance or after instance startup. However, if your database is in ARCHIVELOG mode you must manually archive filled log files so that LGWR will be able to reuse them when needed. Database operation will be suspended temporarily whenever the log writer is forced to wait for an inactive group to become available for reuse.

Disabling Automatic Archiving at Instance Startup Using SQL*Plus

Back to List of Topics

You can disable automatic archiving of filled redo log files by setting the LOG_ARCHIVE_START initialization parameter to FALSE.

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

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

ALTER SYSTEM SET log_archive_start=false SCOPE=spfile;

SHUTDOWN IMMEDIATE

STARTUP

ARCHIVE LOG LIST

Disabling 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 FALSE. You can accomplish that by performing the steps that follow.

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

Disabling Automatic Archiving After Instance Startup Using SQL*Plus

Back to List of Topics

You can disable 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 FALSE to disable 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 STOP;

ARCHIVE LOG LIST

Disabling Automatic Archiving After Instance Startup Using Enterprise Manager

Back to List of Topics

You can disable 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 FALSE to disable 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