Reuters's questions are quite detailed. One point, each layer is very careful. Next we will describe the unclear questions that I have encountered.
1: thread status
Thread thread = new thread (); State state = thread. getstate ();
The
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 log.First, archive the logis a copy of the online redo log group file that contains the redo record and a unique log sequence number to
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 archive log. With data file backups, archive logs and redo logs to ful
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 Disabled Archive destination/data/oracle/product/10.2.0/db_1//dbs/arch old
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. query the current database mode
SQL>
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 destination/data/oracle/product/10.2.0/db_1//dbs/arch Olde St Online log sequence 739 current log sequence 741
edit this section what is Oracle
One. To see if the Oracle database is in archive mode:1.select Name,log_mode from V$database;NAME Log_mode------------------ ------------------------QUERY Noarchivelog2. Use archive LOG LIST commandDatabase log mode No Archive modeAutomatic Archival DisabledArchive Destination/data/oracle/product/10.2.0/db_1//dbs/archOldest online log sequence 739Current log sequ
Oracle 11g Flashback Data Archive (flash back Data archiving) UNDO tablespace record rollback information although it can provide flash back query, but for a long time, this information will be overwritten. In fact, as long as the transaction is committed, it will become a writable object. Therefore, when performing a transient query, we will receive the 1555 error because we cannot find the undo block, and Flashback Data
In the development and testing environments of Oracle databases, the log mode and automatic archiving mode of databases are generally not set, which is conducive to the adjustment of system applications, the generation of a large number of archive log files will consume a lot of disk space. However, when the system goes online and becomes a production environment, it is very important to set it to log mode and automatically
Recently, due to the surge in archive logs, deleting archivelog all seems to be unable to clear all archived logs. Why?
1. Demo Environment
SQL> select * from v $ version where rownum
BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.3.0-64bit Production
SQL> select inst_id, instance_name from gv $ instance; --> two nodes RAC
INST_ID INSTANCE_NAME
--------------------------
1 GOBO4A
2 GOBO4B
Oracle Database TableSpace and archive [SQL] -- TableSpace (TableSpace) is a pioneering concept of Oracle. Table space makes database management more flexible and greatly improves database performance. -- Function: 1. avoid the risk of sudden depletion of disk space 2. more flexible planning data 3. improve database performance 4. improve database security/* ============================================== ======= create an Oracle tablespace ===========
Oracle can save an online log file to a number of different locations, and the process of converting an online log to an archive log is called archiving. The corresponding log is called an archive log.
One, archive log
is a copy of the online redo log group file
Contains redo records and a unique log sequence number
Archi
Tags: open top roc Tin Restart process information Dia Force Redo LogThe 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 archive log. With data file backups,
Create Flashback Data ArchiveThe user needs to grant DBA or Flashback archive administer system privileges. Flashback archive administer system privileges include: Create Flashback Archive,alter Flashback Archive,drop Flashback Archive rights.Sql>Select* fromDba_sys_privswhe
Label: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 archive log. With data file backups, archive logs and redo logs
Step 1. step 1. shut down the database normally. 2. place the database in the mount status. 3. change the database to archivelog mode. 4. open the database 5. close the database normally and make a full backup
sQL> conn / as sysdbaConnected to an idle instance.SQL> startup mountORACLE instance started.Total System Global Area 146472960 bytesFixed Size 1335080 bytesVariable Size 92274904 bytesDatabase Buffers 50331648 bytesRedo Buffers 2531
The archive mode switching in the RAC environment is slightly different from that in a single instance, mainly because of the differences in shared storage. In this case, we can switch the RAC database to a non-cluster state and switch the archive mode on an instance to complete the archive Mode Conversion of the RAC database. This document describes how to switc
After the Oracle11GR2RAC archive mode is modified, the default archive mode is non-archive mode. For more information, see Oracle11GRACOCR and db_unique_name.
After Oracle 11G R2 RAC modifies the archive mode, the default archive mode is non-
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.