Oracle 11g Dataguard Duplicate physical standby configuration (i) Create configuration for physical repositories
# ver:1.5 Fifth time modified
# modify:2013.8.16
# Author:koumm
Description
The installation of this article is configured with Oracle
Description
This article installs the Oracle 11g Dataguard physical repository and tests the 11g Dataguard physical Repository's new feature active Data Guard, which is a function of Oracle Database Enterprise Edition, which requires the amount External authorization, this article is for testing only.
First, the envi
Tags: Modify OCA res scope control File View 11g routed iOS1. Understanding Backup and Recovery issuesThree indicators related to backup recovery are: MTBF average trouble-free timeMTTR mean failure recovery time.Data loss: How much to lose the book data.There are three advanced options for Oracle RAC Steam and DG that have an impact on performance (good bad)2. T
Today is. after a busy day, I finally have time to write something. Some time ago I wrote about how to recover from the existence of a backup in RAc ocr. Today I wrote about how to reconstruct ocr and olr without a backup?
The biggest tragedy is that the database is broken and the backup is gone. It reminds me of a popular saying in the past few years: "the biggest tragedy is that people are living and money is gone ". In short, backup is more importa
open;Six check to see if it takes effectSelect Archiver from V$instance;alter system switch logfile;Ls/oracle/archive3) Configure delay segment creation offalter system set DEFERRED_SEGMENT_CREATION=FALSE;4) Change Password default policyAlter profile default limit Password_life_time Unlimited--=========== 7: Test port# # Test 1521 and 22 ports availableYum-y Install TelnetTelnet 10.1.1.74 1521SSH [email protected]--=========== 8: Other configuration
Oracle 11g Dataguard Snapshot standby database functionality, which places the standby in open read/write state and simulates the test in the main library of the production environment. When the standby snapshot standby task completes, you can switch back to the physical repository role. In the state of snapshot standby database, the repository can accept the log from the main library, but it cannot apply t
Installation and configuration of EM in Oracle 10g and 11g
I set up an Oracle environment locally. I first installed the database with EM. After the installation, I wanted to modify the listener port and replace the port 15521 with another one, as a result, several parameter files are modified in the directory, and EM
First install CentOS6.0
==============
Not to mention. Install it. The only thing to note is that the Checking the Software Requirements section in the Oracle 11G Installation guide will require the Installation of some Software.
These software are available in CentOS6 DVD images. You can configure the repos of a DVD image by yourself.
The command format is as follows:Rpm-qa | grep nameBinutils-2.17.50.0.6
Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux
1. re-build the Oracle user group of the host and standardize uid gid to ensure the permission specification for shared storage mounting or other requirements
Userdel-r oracleGroupadd-g 500 oinstallGroupadd-g 501 db
NextReport a prompt, found that the listener is running, the purpose to achieve, select NoGo back to configure the main page, select the Local network service name configuration, click NextIn the drop-down box, select Orcl NextService Name Fill ORCL NextSelect TCP Nexthostname complete localhost, using standard port number 1521 nextCheck to test nextShow the test is unsuccessful, it's OK, click Change Login, Test success will not point the next stepF
After half a month of Oracle Dataguard physical repository configuration and learning, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. In the process of nearly 10 dataguard
.
_ Archiver (ARCn)
Archiving logs
Managed recovery process (MRP)
Apply the archive file to the backup machine
Logical standby Processes
_ Remote file server (RFS)
Receives archive files from the primary database.
_ Archiver (ARCn)
Archiving logs
Logical standby process (LSP)
Apply the archive file to the backup machine
Lab environment:
In this test, the vmware server 1.6 virtual machine is used. The IP address planning is as follows:
192.168.137.93 primary database
192.168.137.94 standby Data
Manual EM configuration in Linux for Oracle 11g
This article permanently updates the link address:Oracle installed with the OTK tool does not have EM configured by default. The configuration and startup process are recorded below!
First create EM and execute the following command
$ Emca-config dbcontrol db-repos recrea
After half a month of configuration and learning about the physical standby database of Oracle replicaset uard, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. During the las
Oracle 11g installation and configuration EM, 11gem
You cannot log on to EM. If you execute emca-config dbcontrol db, you do not know that the default port number is 1522. But google will execute the command in step 2... (My listeners are fine)
1. Open the Net Configuration Assistant in the
The database and the client are on different machines.Before installing, navigate to the following folder on the server where the Oracle database is installed.Change localhost in Listener.ora and Tnsnames.ora to the IP address of the machine, my 192.168.1.102Then start installing OracleClientSelect Custom and be able to customize the installed components.Cancels the selection of the Oracle Scheduler Agent c
Tags: http os ar file data div on art adThe database and the client are on different machines.Before installing, navigate to the following folder on the server where the Oracle database is installed.Change localhost in Listener.ora and Tnsnames.ora to the IP address of the machine, my 192.168.1.102Then start installing OracleClientSelect Custom and be able to customize the installed components.Cancels the selection of the
This paper uses Oracle 11g Dataguard broker Fastfailover Test
Oracle 11g Dataguard Fast failover configuration, requires a primary database to turn on the flash back function, flash back to open this article skip.
When the flash-back is activated to the
configuration are the most critical parts. Iv. Unloading of the database Go to the installation directory and go to product-->11.2.0-->dbhome_1-->deinstall-->deinsytall.bat Continue through the carriage return to achieve the next step, come here follow the prompts to enter Y Go back in and enter Y here Continue to enter the database after the cleanup operation, a few minutes (in fact, a long time), the database is uninstalled, the process may fail
Docker Image: wnameless/oracle-xe-11gcommand to start mirroring:Docker run-d-v/data/oracle_data:/data/oracle_data-p 11522:22-p 11521:1521-e oracle_allow_remote=true--name oracle-1 1g wnameless/oracle-xe-11gTo enter the mirroring command:Docker exec-it Oracle-11g/bin/bash1. E
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.