Learn about error can not open file as archive, we have the largest and most updated error can not open file as archive information on alibabacloud.com
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
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
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
Dataguard archive loss (not in the master database). The slave database restores the Environment Based on SCN: OS: centos 6.5db: Oracle 10.2.0.5 1. master database environment master database: SQL> select dbid, name, log_mode, open_mode,
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.
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
1.select Name,log_mode from V$database; NAME log_mode------------------------------------------QUERY noarchivelog 2. Using the archive Log LIST command Database log Mode No Archive Mode Automatic archival Disabled Archive
See if the Oracle database is archive mode [1] 1.select name,log_mode from v$database; name log_mode ----------------- ------------------------- QUERY noarchivelog 2. Using the Archive Log LIST command Database log mode No Archive Mo de
I will talk about my understanding of these two modes of operation today, and give some feasible suggestions to improve the security of Oracle database.
the advantages and disadvantages of the non-archival mode.
Non-archive mode is the log
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.