Reprinted from: http://blog.csdn.net/leshami/article/details/5784713Oracle can save online log files to many different locations, and the process of converting online logs to archived logs is called archiving. The corresponding log is called the
Archive Logs in Oracle (Archive log)
article Category: Database
In Oracle, data is typically stored in data files, but one of the biggest differences between databases and Oracle is that databases can recover when data is wrong. This is also the
One. To see if the Oracle database is in archive mode:SQL code1.select Name,log_mode from V$database;NAME Log_mode------------------ ------------------------QUERY Noarchivelog2. Using the archive LOG LIST commandDatabase log mode No Archive
The archive log (Archive log) is a non-active redo log backup. By using archived logs, you can keep all the redo history, when the database is in Archivelog mode and log-switched, Background process Arch will save the contents of the redo log to the
There are two main log operation modes in the Oracle Data database: Non-archive mode and archive mode. By default, the database adopts the non-archive mode. As a qualified database administrator, you should have an in-depth understanding of the
The archive log (Archive log) is a non-active redo log backup. By using archived logs, you can keep all the redo history, when the database is in Archivelog mode and log-switched, Background process Arch will save the contents of the redo log to the
Today, I will talk about my understanding of these two operation modes and give some feasible suggestions to improve the security of Oracle databases.
I. Advantages and Disadvantages of non-archive mode.
The non-archive mode is a log operation
To ensure that the Oracle database works normally in archive mode, perform the following settings::
1. Set the database to archive
If the database archive mode is not enabled, the query displays the following information (non-archive mode ):
1.
The archive log (Archive log) is a non-active redo log backup. By using archived logs, you can keep all the redo history, when the database is in Archivelog mode and log-switched, Background process Arch will save the contents of the redo log to the
to see if an Oracle database is in archive mode1.select Name,log_mode from V$database; NAME log_mode------------------------------------------QUERY noarchivelog 2. Use archive log LIST command Database log MODE No Archive Mode Automatic Archival
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.