dataguard oracle

--==========================================--oracle Instances and Oracle Databases (Oracle architecture)--==========================================/*For the first contact with Oracle database, two concepts that are easily confused are Oracle instances and

test the OCP certificate, a system for Oracle to learn, and then see Oracle Concepts, Oracle online document, the principle of Oracle will have a deeper understanding of the principles, and can begin to do some research topics such as: RMAN, RAS, Statspact, DATAGUARD, TUNIN

1. Oracle Overview-Oracle Database, referred to as Oracle. Oracle (Oracle) is an object-relational database management system (ORDBMS) in the United States. Currently occupies a major share of the database market.-Oracle's history: 1977 Ellison and two friends, established R

Original source http://www.linuxidc.com/Linux/2015-02/113222.htmlNeed to install Oracle DataGuard, so first install a single oracle11g, below is the detailed installation process of Linux under a single oracle11g.1, installation EnvironmentHardware environment: 2 Linux virtual machines, CentOS6.4, 4G, 4 cores, disk 50GOracle software version:Linux.x64_11gR2_database_1of2.zipLinux.x64_11gR2_database_2of2.zip

) backup-based tablespace migration (4) dataguard 1.2.1 transportable tablespace Transporttabletablespace can be implemented using expdp/impdp, or RMAN. Note that the tablespace needs to be set to read only for transmission of tablespaces, but it is generally not allowed by the production database, therefore, the backup-based RMAN table space can be used here. One of the biggest advantages of table space migration based on backup is zero downtime, an

Tags: DBA RAM read-write management art SSE buffer temp tablespace UNIXReprinted from: http://blog.csdn.net/robinson_0612/article/details/5529239 An Oracle server consists of an Oracle instance and an Oracle database. That is: Oracle Server = Oracle Instance +

I. Overview of Oracle DataGuard EnvironmentOS: CentOS5 + ORACLE10G 10.2.0.4.0IP: 192.168.100.208 (primary) 192.168.8.201 (standby)ORACLE_SID: jscnORACLE_HOME:/oracle/ora10/product2. Preparations for the primary database1. modify primary dba to archive ModeSQL> alter system set log_archive_dest_1 = 'location =/oraarch/'scope = spfile;SQL> startup mount;SQL> alter

/oracle Export ORACLE_HOME =/u01/app/oracle/product/11.2.0./db_1 Export ORA_CRS_HOME =/u01/app/product/crs_1 Export ORACLE_ADMIN = $ ORACLE_BASE/admin Export ORACLE_HOME_LISTNER = $ ORACLE_HOME Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ ORACLE_HOME/jlib Export JAVA_HOME = $ ORACLE_HOME/jdk Export PATH = $ PATH: $ ORACLE_HOME/bin:/usr/sbin:/usr/local/sbin:/usr/lib: $ JAVA_HOME/bin: $ ORA_CRS_HOME/b

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. Development: for Oracle development, after learning about the basic architecture of Oracle, you can focus on PL/SQL and

maintain data consistency and sequential recovery of important signs. Iv. further study Management: You can test the OCP certificate, the Oracle first has a systematic study, and then look at Oracle Concepts, Oracle online document, Oracle will have a more in-depth understanding of the principles, and can begin to do

automatically increases, he is the system to maintain data consistency and sequential recovery of important signs. Iv. further study Management: You can test the OCP certificate, the Oracle first has a systematic study, and then look at Oracle Concepts, Oracle online document, Oracle will have a more in-depth unders

in the master repository③ in Dataguard, if static registration is used, it is recommended to enter the same service name (SERVICE_NAME) in listener on the master repository.④ If the monitor is statically registered, then the service_name equals the Global_database_name value in the Listener.ora file.Global_database_name:①global_database_name is the listener configured external network connection name, can be any value② the service_name in the Tnsname

begin to do some research topics such as: RMAN, RAS, Statspact, DATAGUARD, tuning, Backuprecover, and so on. Development: For Oracle developers, after learning Oracle's basic architecture, focus on the Pl/sql and Oracle Development tools section. Pl/sql mainly includes how to write SQL statements, how to use the functions of

the component in trouble. Just Click on the alert icon to find out what ' s wrong. Click once again to learn what this alerts means and how can fix the problem Features Interactivity and extensibility Insider allows for two-way interactivity and extensibility. can choose to display the information your need on the insider screens such as used-defined alerts from any application Or you can redirect insider output to another application such as Oracle