Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11G using DG Broker create DataGuard     - Linux Network Programming - raw socket instance: MAC Address Scanner (Programming)

- Ubuntu Linux to create and increase the Swap partition tutorial (Linux)

- MySQL fuzzy query: LIKE and REGEXP pattern mode (Database)

- CentOS 6.5 install Firefox (Linux)

- Share and show your code on GitHub (Linux)

- Linux password file security issues detailed usage (Linux)

- DRBD + Heartbeat solve NFS single point of failure (Server)

- How to use the TF / SD card making Exynos 4412 u-boot boot disk in Ubuntu (Linux)

- MySQL how to export files with the date format (Database)

- Common data structures and functions of Linux process scheduling (Programming)

- To access an Oracle database using Instant Client (Database)

- Linux install the Java Runtime Environment and the output Hello World under (CentOS) (Linux)

- Basic Tutorial: Linux novice should know 26 commands (Linux)

- Use Vagrant up a local development environment tutorials (Server)

- Introduction and use of the Raspberry Pi (Linux)

- Iscsi package is installed on RHEL 6.3 x86-64 systems (Linux)

- Linux source code to install Apache and solutions to common errors (Server)

- Browser caching mechanism on the analysis (Linux)

- The free command in Linux (Linux)

- Android Service Lifecycle and usage (Programming)

 
         
  Oracle 11G using DG Broker create DataGuard
     
  Add Date : 2018-11-21      
         
         
         
  Oracle 11G using DG Broker create DataGuard

1. Environment:

. A host environment: CentOS6.5

b Software Environment:. oracle 11.2.0.4

. C Host Information:

DG1: 192.168.100.51 (database sid: atest)

DG2: 192.168.100.52

2. The premise of the work (master and slave should be set):

. A turn off the firewall: /etc/init.d/iptables stop

. B Close selinux: setenforce 0

View Status: getenforce (off: Permissive)

3.3 Main library settings:

. A set primary database db_unique_name:

alter system set db_unique_name = 'patest' scope = spfile;

. B Set the main library to force log:

alter database force logging;

Check status (YEs mandatory):

select name, force_logging from v $ database;

. C Setting standy_file_management:

alter system set standby_file_management = 'AUTO';

d created standbylog.:

alter database add standby logfile group 11 '/u01/app/oracle/oradata/ATEST/standbylog/standby11.log' size 50m;
alter database add standby logfile group 12 '/u01/app/oracle/oradata/ATEST/standbylog/standby12.log' size 50m;
alter database add standby logfile group 13 '/u01/app/oracle/oradata/ATEST/standbylog/standby13.log' size 50m;
alter database add standby logfile group 14 '/u01/app/oracle/oradata/ATEST/standbylog/standby14.log' size 50m;

. E Open archive (simply not elaborate):

alter system set log_archive_dest_1 = 'location = / u01 / app / oracle / oradata / ATEST / archivelog';
alter database archivelog;

. F Open DGbroker:

alter system set DG_BROKER_START = TRUE;

. G transmission pfile and password files:

 create pfile from spfile;
 scp initatest.ora orapwatest 192.168.100.52:/u01/app/oracle/product/11.2.0/db1/dbs/

. H Set up listeners: atest, patest, patest_DGMGRL

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = atest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = patest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = patest_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP) (HOST = vijay01.database.com) (PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = / u01 / app / oracle

i. Setting tnsnames.ora

ATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.51) (PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )


PATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.51) (PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

SATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.52) (PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

4. Preparation of library settings:

. A set listen: atest, satest, satest_DGMGRL

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = atest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = satest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = satest_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP) (HOST = vijay02.database.com) (PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = / u01 / app / oracle

b. Set tnsnames.ora

ATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.52) (PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )


SATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.52) (PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

PATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.51) (PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

5. Back up the master database:

a.rman target /

b.backup database;

6. clone the primary database on the standby database:

a. db_unique_name modifications prepared by the library on pfile = satest

. B Start the database to nomount:

startup nomount

. C Login rman:

rman target sys / 123456 @ patest auxiliary sys / 123456 @ satest

. D start cloning:

 duplicate target database for standby nofilenamecheck from active database;

7. Set DGbroker:

. A landing dgmgrl:

dgmgrl sys / 123456 @ patest

. B Set the main library:

create configuration dgc as primary database is patest connect identifier is patest;

. C add standby database:

add database satest as connect identifier is satest maintained as physical;

. D profiles enabled:

enable configuration

. E View DGbroker configuration:

show configuration [verbose];

show database [verbose] 'satest';

show database 'patest''StatusReport';

. F See DG state of the database:

SELECT GROUP #, dbid, archived, status from v $ standby_log;

select dest_id, valid_type, valid_role, valid_now from v $ archive_dest;

select process, status, group #, thread #, sequence # from v $ managed_standby order by process, group #, thread #, sequence #;

select name, value, time_computed from v $ dataguard_stats;

select timestamp, facility, dest_id, message_num, error_code, message from v $ dataguard_status order by timestamp;

select recid, archived, applied from v $ archived_log;

8.DG sync check steps:

1. Check the password file
2. Check the network
3. Check the parameter file
4. Check the firewall or selinux
5. As described above had no problems, only that dg environment problems, the need to re-build dg (retransmit the data file to the main library, resynchronization)
     
         
         
         
  More:      
 
- Docker ecosystem security is gradually maturing (Server)
- Linux System Getting Started Learning: Statistical process a number of threads in Linux (Linux)
- Redis 3.0.3 Cluster Setup (Database)
- Fedora10 use Git version Configuration Management (Linux)
- Ubuntu install VMware Workstation 11 tutorials at 14.04 / 14.10 (Linux)
- Linux System Getting Started Learning: Disable HTTP forwarding wget in (Linux)
- Fragment Android developers learning to resolve (Programming)
- Ubuntu users to install household financial management tools HomeBank 5.0.0 (Linux)
- Debian (Wheezy) were installed wxPython GUI development (Linux)
- 20 Unix / Linux command skills (Linux)
- Android in the event delivery and handling mechanism (Programming)
- Achieve single backup of MySQL by innobackupex (Database)
- How to adjust the system time CentOS (Linux)
- RedHat Linux 6.4 installation RTL8188CUS wireless network card driver (Linux)
- Oracle table compression Technology Introduction (Database)
- Two programs HAProxy + Heartbeat (note, the secondary server vip, normal HAProxy boot method) (Server)
- Go Languages Reviews (Programming)
- Linux Log File Browser --logrotate (Linux)
- SSH mutual trust configuration (Server)
- Ubuntu installation module Python rq (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.