################################### DG ###################################
# here after the test can be a one-time brush script, but do not recommend that the operation of the production library there is a certain risk, it is recommended to fully understand the paragraph after the brush
# Case One: RAC + DUPLICATE + single node DG (complex, need to convert path)
# Master node RAC Main Library configuratio
Oracle Cluster (RAC) startup and shutdown
The following points need to be noted when Oracle RAC starts and shuts down:
First, check the shared device
Second, automatically start RAC and check related processes
Third, manually start RAC
In general, Oracle 11g R2 RAC provides the following features:
High Availability: shared-everything mode ensures that services are not stopped when a single node fails, and other nodes in the cluster will take over quickly
Scalability: multiple nodes share the load and can provide processing capabilities far beyond that of a single database. Addition and deletion of nodes can be completed online without
Operating Environment:
Server:oracle 10g RAC
Client:toad for Oracle 8.6
Description of the problem phenomenon:
Set a breakpoint on stored procedure load in editor, followed by the following error prompts:
Ora-12560:tns:protocol Adapter Error
Cannot connect debug session. In, to debug, connected to a RAC instance you must have entries for the individual
Oracle 11g Audit
The Oracle audit (Audit) function is used to monitor database operations performed by users. audit records can be stored in data dictionary tables (called audit records: SYS. in the AUD $ table, view dba_audit_trail)
Or operating system audit records (default location: $ oracle_base/admin/$ oracle_sid/adump.
Regardless of whether or not the database audit function is enabled, the following
[Oracle] deletes a node from RAC, which is a oraclerac node.
Environment:
OS: OEL5.6
RAC: 10.2.0.1.0
There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node.
1. Delete the database instance on the rac3 Node
[Oracle @ rac1 ~] $ Dbca-silent-deleteInstance-gdbName RACDB-inst
RAC asm restored to a single instance
Rac source server:
Rac1: 192.168.100.201
Rac2: 192.168.100.202
Target Server:
192.168.8.201
The recovery procedure is as follows:
Restore the initialization parameter file-> modify the parameter file-> restore control file-> resotre data file-> recover data file1. Correctly install a single instance database. 1) Check the rac
Oracle RAC
Full name: Oracle Real Application Clusters, that is, Oracle Real-Time ApplicationProgramCluster, so that different applications can access multiple Oracle instances as if accessing one Oracle instance (of course, the
The two machines use disk arrays to store ORACLE data files for RAC. Configure an Oracle service. In this way, the client can configure the Oracle address and service description on the two machines.
JDBC: oracle: thin :@(Description =(Load_balance = yes)(Failover = on)(Add
Before learning a new thing, you need to understand its purpose.
Article This section describes the advantages and disadvantages of Oracle RAC and other four components for future reference. The full text is as follows:
To improve performance, we have made a lot of trials on the methods or solutions provided by the Oracle database itself.It mainly includes:S
Oracle 11g R2 rac rman backup script example
1. Switch RAC to archive Mode
1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive.
SQL> alter system set cluster_database = false scope
Oracle RAC knowledge points
Database Planning should be oriented to business characteristics and needs, rather than RAC for the availability of RAC. In fact, RAC is not omnipotent, and the following knowledge points need to be mastered.
1. Benefits of using
10G RAC installation encountered the failed to upgrade Oracle Cluster Registry configuration, caused by the use of the DMM multipath software Device-mapper-multipath to trigger this bug.About the DMM multi-path software Device-mapper-multipath installation RAC, reference document Configuring RAW Devices (Multipath) for Oracle
For listeners that are not on the default port (1521), The pmon process does not register the service/instance to the listener, that is, dynamic registration is not implemented. Similar to a single instance, listeners with non-default RAC ports also set the local_listener parameter. In addition, you can remotely register an instance to achieve load balancing. This is achieved through the remote_listener parameter.
For more information about the basic
This article makes it possible to discover some of the problems of backup during the recovery process by using a complete backup of Oracle 10g RAC Rman for a different machine recovery process. such as the redundancy of the Regulation log, control the use of automatic backup of files and parameter files, and so on, this example takes an Rman backup set for backup, so there was a problem during the last star
This article introduces the connection management in Oracle RAC Environment in detail, and describes what is connect time load Balancing, Runtime Connection load Balancing, connect timer, respectively. Connection Failover and Runtime Connection Failover, as well as the TAF, ONS, FCF, FAN, LBA and many other knowledge points involved. This article focuses on connection management in
may be used in RAC.(4) If you want the FTP tool, you can also select gFTP in "Internet.(5) Before installing the database, you must install the following first package (the second package will be used in RAC ).Libaio-0.3.105-2.i386.rpm this package is this in 32-bit cases, if 64-bit, it carries * 64 characters. Otherwise: ORA-12547: TNS: lost contact error may occurOpenmotif21-2.1.30-11.RHEL4.6.i386.rpm (t
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.