Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11G using DG Broker create DataGuard     - Linux / CentOS 7.0 installation and configuration under Tomcat 8.0 (Server)

- Tmux create the perfect terminal management tool under CentOS (Linux)

- Oracle 12c PDB Analysis (Database)

- Go build the locale under Windows (Linux)

- C ++ overloaded stream insertion operator and the stream extraction operator (Programming)

- iOS constants, variables, properties and characteristics (Programming)

- JIRA 3.6.2 Upgrade from older version to the new version 6.0.8 (Linux)

- How Mutt mail client to use cipher text password (Linux)

- pga_aggregate_target and _pga_max_size can not use absolute limit actual PGA (Database)

- Linux regex awk Comments (Linux)

- Export error: ORA-04063: package body dmsys dbms dm model exp has error (Database)

- OpenSSL for secure transmission and use of skills of files between Windows and Linux (Linux)

- C ++ CBitmap, HBitmap, Bitmap difference and contact (Programming)

- Docker manage data (Linux)

- Linux raw socket (Programming)

- Java memory analysis tool uses detailed MAT (Programming)

- Linux System Getting Started Learning: The Linux command line burn ISO or NRG image to DVD (Linux)

- Depth understanding of the TCP protocol (Database)

- Mac OS X 10.9 compiler OCI8 module (Programming)

- RedHat Linux 9.0 under P4VP-MX motherboard graphics resolution of problems (Linux)

 
         
  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:      
 
- Java filter (Programming)
- How to protect the Apache website under Linux system (Linux)
- MNIST presentation and database conversion (Database)
- Linux Open coredump (Linux)
- To compile and install Clang 3.5.0 in Linux CentOS (Linux)
- Python several standard types of built-in functions (Programming)
- Java 8 stream parsed into SQL (Programming)
- QEMU code analysis: BIOS loading process (Linux)
- The development environment to build Nodejs under Ubuntu 14.04 (Linux)
- Install Firefox 28 on Ubuntu, Linux Mint (Linux)
- Video editing captions under Linux (Linux)
- Improve the efficiency of Linux development tools 5 (Linux)
- Android Studio 1.0.2 set the memory size (Linux)
- Java interview questions in nine radio (Programming)
- PLSQL Developer synchronization table tools (Database)
- Linux Getting Started tutorial: hard disk partition and to deal with traps (Linux)
- Gnu Linux - Ubuntu System Clean-term consolidation (Linux)
- To install GCC development environment under SUSE11 (Linux)
- Yii2 Advanced Version Copy New Project Problem Solved (Programming)
- Xshell upload files to achieve Windows host Linux (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.