dataguard oracle

. rmem_default = 262144Net. core. rmem_max = 4194304Net. core. wmem_default = 262144Net. core. wmem_max = 1048586Note: If the existing value is greater than this value, do not modify it!-- Then run the following command to make the preceding settings take effect.#/Sbin/sysctl-pParameter description:Kernel. shmall is the physical memory divided by pagesize;Kernel. shmmax is half of the physical memory;Fs. file-max is 512 multiplied by processes (for example, 128 processes );Net. ipv4.ip _ local_p

Management: You can take an examination of the OCP certificate. First, you can have a system for Oracle, and then read Oracle concepts and Oracle online document. You will have a deeper understanding of the Oracle principles, at the same time, you can start some special studies, such as rman, Ras, statspact,

Resume oracle.sh in/etc/profile.d/ The contents are as follows in Nls_lang setup encoding 1 oracle_home=/usr/lib/oracle/12.1/client642 c_include_path=/usr/include/ oracle/12.1/client643 ld_library_path= $ORACLE _home/lib4# RememberThis was the client Nls_lang not the server one5 nls_lang=6 Export Oracle_ho ME Ld_library_path Nls_lang Then modify the/ETC/INIT.D

, starting at m and intercepting N characters consecutively.---need to note: The database subscript is starting from 1!!!---n is truncated to the end of the current string if the number that is not specified or specified exceeds the actual character length that can be intercepted. n is the length.---if M is negative, it is intercepted from the countdown position. The number at the end cannot be negative.SELECT SUBSTR (' thinking in from dual;--->inSELECT SUBSTR (' thinking in from dual;--->in---

not determined by Oracle, it is mainly restricted by Windows Services. There cannot be Oracle services with the same service name in the service. The service name is in the following format: oracleservicesid, because the service name includes Sid, therefore, if the SID is the same, the service name is the same, which is not allowed by windows. Therefore, different instances with the same SID cannot be crea

to be updated. It is an important indicator of maintaining data consistency and sequential recovery in the system. 4. Deep Learning Management: You can take an examination of the OCP certificate. First, you can have a system for oracle, and then read Oracle Concepts and oracle online document. You will have a deeper understanding of the

Nproc 16384Grid Soft Nofile 1024Grid hard Nofile 65536Grid Soft Stack 10240Vi/etc/profile writes the following:if [$USER = "Oracle"] | | [$USER = "Grid"]; Thenif [$SHELL = "/bin/ksh"]; ThenUlimit-p 16384Ulimit-n 65536ElseUlimit-u 16384-n 65536FiUmask 022FiExport path= $PATH:/u01/app/11.2.0/grid/binConfiguration node Rac1Grid users:VI. bash_profileExport Tmp=/tmpExport tmpdir= $TMPExport Oracle_hostname=Export oracle_sid=Export Oracle_base=/u01/app/gr

client, the user is responsible for passing the user's SQL statement to the service process and retrieving the query data from the server segment.5. oracle routine: The Oracle routine consists of the SGA memory structure and background processes used to manage the database. A routine can only open and use one database at a time.6. SCN (System Change Number): System Change Number, a serial Number maintained

Oracle learning path (5) ----- General oracle data type operations, oracle ----- oracle1. Some common Operators Operator Meaning = Equal Not equal Less > Greater Less than or equal > = Greater than or equal + Plus sign - Minus sign

Oracle BASICS (9) Oracle architecture and oracle infrastructure 1. Oracle Architecture Overview: Oracle architecture refers to the composition, working process and principle of the database, as well as the organization and management mechanism of data in the database. To und

Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle 11g Manual database creation is relatively easy to implement. In this case, we

I often ask my friends how to become a master when learning oracle. I would like to give a few simple points based on my personal experience: 1. lay a good foundation from a simple perspective Learning Oracle cannot rush to success, and hopes to become a hero one day. There is a learning process, which should be easy to understand and lay a good foundation in the learning process. In this way, you will be

can have a system for oracle, and then read Oracle Concepts and oracle online document. You will have a deeper understanding of the oracle principles, at the same time, you can start some special research such as RMAN, RAS, STATSPACT, DATAGUARD, TUNING, BACKUP RECOVER, etc

ModeAutomatic archival EnabledArchive destination/data/oracle/oradgdata/standby_archiveOldest online log sequence 20869Next log sequence to archive 0Current log sequence 20871SQL>The Current log sequence of the master database and slave database is 20871, and the latest archive log applied on the slave database is YES, which indicates that the data synchronization of the master database and slave database is consistent.Restarting uard is complete. He

Original: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx -- ===================================================== === -- Oracle instance and Oracle Database (Oracle Architecture) -- ===================================================== === /* For those who are new to Oracle databases, the two conce

Often meet a friend asked Oracle learning difficult, how to become a master and so on, I would like to combine my personal experience simple to say a few: 1, lay a good foundation, from the Learn Oracle not to rush, hope to become a warrior one day. Learn to have a process, should be more than one, in the process of learning to lay a good foundation, so in the later study can analogy, extrapolate. In my

Often meet a friend asked Oracle learning difficult, how to become a master and so on, I would like to combine my personal experience simple to say a few: 1, lay a good foundation, from the Learn Oracle not to rush, hope to become a warrior one day. Learn to have a process, should be more than one, in the process of learning to lay a good foundation, so in the later study can analogy, extrapolate. In my

Disclaimer: This article transfers from the network article, reproduced this article only for the personal collection, shares the knowledge, if has the infringement, please contact the blogger to delete.Original LeshamiOriginal address: http://blog.csdn.net/leshami/article/details/5529239--========================================== --oracle Instances and Oracle Databases (

Oracle Cluster Concepts and principles (ii) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review rev

Oracle 10g AND Oracle 11g manual database creation case -- Oracle 10g System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle 11g Manual database creation is relatively easy to implement. In this case, we w