data guard oracle 11g step by step

ASM concepts 1. what is Automatic Storage Management (ASM, it is a disk management tool that can implement strip, image data files, recovery files, and other files among multiple physical devices. The distribution unit is AUs (allocation units) the balance is distributed across all disks in the disk group. ASM uses the index technology to track the positions of each AUs and supports the dynamic increase and decrease of online disks. When the disk chan

as setting different passwords for different accounts, selecting database languages, product languages, and automatic backup, custom installation and backup storage options (Automatic Storage Management ). By default, Oracle provides basic installation. Select the appropriate installation method and click Next. I am an advanced installation. 4 ). Select the installation type: Enterprise Edition, Standard Edition, Personal Edition, and custom edition

Oracle Installing Oracle 9ir2 on RHEL as 3 step-by-step Author: fenng Installing Oracle 9ir2 on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3) Red Hat, the world's largest Linux manufacturer, recently released the Red Hat Enterprise Linux 3. This version boasts the

Apply Oracle-step by step [Author] Li bingyang [same as the author's work][Release news agency] China Water Conservancy and hydropower press [book no.] 9787508469614[Shelving time][Publication date] on December 16, January 2010 [Opening] [Page code] 554 [version times] 1-1Free sample trial: http://www.china-pub.com/196252 [Content Overview]This book, as a practic

RENAME FILE ' 3) If the new datafile location on the primary is different from the standby, please make sureDb_file_name_convert init parameter is set on the standby database. Note 47325.1 Init. ora Parameter "DB_FILE_NAME_CONVERT" Reference Note If db_file_name_convert init parameter has already been set, then you cocould ignore this step. 4) Cancel the managed recovery SQL> alter database recover managed standby database cancel; 5) set standby_fil

Step by step: How to completely delete an Oracle database Many of my friends only use Oracle to delete the system. However, in many cases, he may find that the next installation page disappears when the system is re-installed, and he may have to reinstall the system, in fact, this is not the case if your database is no

Oracle, as a large database, is widely used in financial, post and telecommunications, power, civil aviation, and other important sectors with a large data throughput and a wide spread of computer networks. For system administrators, it is especially important to ensure stable network operation and improve database performance to make it more secure and efficient. Database fragmentation, a major factor affe

Tags: style blog http io ar color OS using SPOracle RAC (12.1) installs virtual machines on Linux, step-by-step wizardtoday we will see how to installC version 1 RAC (real application cluster) database 2 Linux 64-bit virtual machineuse vmware or Oracle VirtualBox. Oracle's "C" C represents "Cloud"There are some important and interesting changes when installing a

How to uninstall oracle step by step in Windows nt: 1. Start-> set-> Control Panel-> Administrative Tools-> stop all Oracle services. 2. Start-> Program-> Oracle-OraHome9i-> Oracle Installation Products-> Universal Installer unins

Step-by-step explanation of ORACLE (Lecture 2)1. Common ORACLE Data Types (not commonly used for other types) (1) character type 1. char fixed length, up to 2000 characters. For example, put the first four characters of char (10) 'xiaoming 'and then add 6 spaces to complete.

Part 1: installation and configurationTo develop a webapp under the command line interface (*), you can only compress it into an ear package to deploy the app. If you use it to debug the program, it is very troublesome. Can I develop and automatically package and release the data in the JBuilder integrated with the development of the Enterprise Edition? Borland has provided us with a plug-in that can be easily implemented.The following describes how t

Step by step to clean up the oracle 10g RAC environment that fails to be installed due to problems with the previous installation of clusterware, so reinstall the environment, but each time you execute the root. sh always has Failure at final check of Oracle CRS stack. 10. start querying questions. the previously insta

Step-by-Step Oracle part of Notes 1. Do not use the user name/password directly/as sysdba is the operating system authentication method, change the security method sqlnet. SQLNET. AUTHENTICATION_SERVICES = (ETS) indicates that operating system authentication is enabled. When this parameter is commented out or set to NONE: SQLNET. AUTHENTICATION_SERVICES = (NONE)

Tags: style blog http io ar sp for on 2014ODAC InstallationDownload ODACIn the. NET Framework 4.5, System.Date.OracleClient.dll contains many of the methods that Microsoft has given up. The. NET access to Oracle has a better choice, which is the components provided by ODAC.: http://download.oracle.com/otn/other/ole-oo4o/ODTwithODAC121012.zip?AuthParam=1415440199_d43971653a20b522e5588d174fef4821Installing ODACCatalog selection:Select a build, the recom

to facilitate the MapReduce direct access to the relational database (mysql,oracle). Hadoop offers two classes of Dbinputformat and Dboutputformat. Through the Dbinputformat class, the database table data is read into HDFs, and the result set generated by MapReduce is imported into the database table according to the Dboutputformat class.error when executing mapreduce: java.io.IOException:com.mysql.jdbc.Dri

Step-by-step explanation of ORACLE (Lecture 3)I. Common oracle system functions1. Date Functions(1) to_date (string, Format) SQL> select to_date('2014-10-11 12:13:14','yyyy-mm-dd hh:mi:ss') from dual;TO_DATE('2014-10-1112:13:14','------------------------------2014-10-11 12:13:14 (2) obtain the first day of the current

Tags: ODA engine sof ado oracl ora ACL best OLEDo you know what data engine you use, ADO?I've touched a similar one before, and I have two options:1. L ADO to 2.7 or more2. Do not use Microsoft OLE DB Provider for Oracle and use Oracle Provider for OLE DBIn particular, 2nd, Microsoft OLE DB Provider for Oracle is defin

Introduction: The first two blog posts (Database DesignStep by step (5)-understand user requirements and database designIn step by step (6) -- extract business rules), we analyze database requirements, focusing on two topics: 1. understanding user requirements; 2. Extracting business rules. After the requirement analysis is complete, we will enter the conceptual

Tags: hadoop mysql map-reduce import export mysqlto facilitate the MapReduce direct access to the relational database (mysql,oracle), Hadoop offers two classes of Dbinputformat and Dboutputformat. Through the Dbinputformat class, the database table data is read into HDFs, and the result set generated by MapReduce is imported into the database table according to the Dboutputformat class. when running MapRe

This section continues to learn WCF distributed development step-by-step for Win (7): WCF Data Contract and serialization. Data contract is an important concept in WCF application development, it is a very important step to realize the serialization of