Setting of Oracle automatic archiving Mode

Source: Internet
Author: User

The method for setting the Oracle automatic archiving mode is not very complex. The following describes how to set the Oracle automatic archiving mode in detail, hoping to help you.

Oracle Automatic archiving mode setting (Automatic archival, which can be Enabled and Disabled). In this mode, the database starts an arch process and writes redo logs to the corresponding directory of the system archive device.

In the parameter file of the database, set the parameter in the $ ORACLE_HOME/dbs/init *. ora file ):
LOG_ARCHIVE_START =
LOG_ARCHIVE_DEST =
LOG_ARCHIVE_FORMAT =
LOG_ARCHIVE_START:
If automatic archiving is required, set this parameter to TRUE. If automatic archiving is not required, set this parameter to FALSE.
LOG_ARCHIVE_DEST:
This parameter sets the archive logs path.
LOG_ARCHIVE_FORMAT:
This parameter sets the archive logs naming format. For example, set the format to arch % s. arc.
The log file will be: arch1.arc, arch2.arc, arch3.arc

These parameter settings take effect only before the database instance is started. To make them take effect during database running, you must restart the database.

If the database is running and cannot be restarted immediately, set it to the automatic archiving mode, perform the following operations:
SVRMGRL> alter system archive log start;

To disable automatic archiving:
SVRMGRL> alter system archive log stop;

However, if the database restarts, the statement Modification result becomes invalid. The automatic archiving settings are set based on the value of LOG_ARCHIVE_START in the system parameter file.

In addition, from oracle9i, you can change automatic archiving and re-start automatic modification when the database is started. This avoids misoperation of oracle initialization parameters.
Oracle10g has deprecated log_archive_star. this parameter is automatically archived by default)
SQL> show parameter spfile
If there is a Value
Alter system set LOG_ARCHIVE_START = TRUE scope = spfile
Or
SQL> show parameter pfile
If there is a Value
Alter system set LOG_ARCHIVE_START = TRUE scope = pfile
 

How to delete ORACLE archive logs

Oracle mobile data file Method

Oracle Log File Reconstruction Method

Concepts of oracle users

Add Oracle user information in Linux

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.