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