Disabling Automatic Archiving After Instance Startup Using SQL*Plus
This module describes how you can disable automatic archiving of redo log files.
This module discusses the following:
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.
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.
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:
| 1. |
Invoke SQL*Plus.
|
| 2. |
Issue the ALTER SYSTEM command to update the LOG_ARCHIVE_START parameter in your SPFILE: ALTER SYSTEM SET log_archive_start=false SCOPE=spfile;
|
| 3. |
Shut down your instance using the NORMAL, IMMEDIATE, or TRANSACTIONAL options: SHUTDOWN IMMEDIATE
|
| 4. |
Restart your instance: STARTUP
|
| 5. |
Verify your changes: ARCHIVE LOG LIST
|
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.
| 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. You can access the initialization parameters from the General page. Change the value for LOG_ARCHIVE_START to FALSE.
|
| 3. |
Select the appropriate mode for shut down of your database:
|
| 4. |
Click CLOSE when processing has completed:
|
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:
| 1. |
Invoke SQL*Plus.
|
| 2. |
Issue the ALTER SYSTEM command to start automatic archiving: ALTER SYSTEM ARCHIVE LOG STOP;
|
| 3. |
Verify your changes: ARCHIVE LOG LIST
|
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.
| 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. You can disable automatic archiving on the Recovery page:
|
| 3. |
Click OK:
|
Move your mouse over this icon to hide all screenshots