Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ GoldenGate for Oracle data consistency initializing     - stat Usage: Get permission to file the corresponding figures (Linux)

- Redis Linux system installation guide (Database)

- Ubuntu system cp: omitting directory problem (Linux)

- What happens after the MySQL disk space is full (Database)

- C # mobile side and PC-side data exchange (Database)

- Linux common network tools: hping Advanced Host Scan (Linux)

- Online booking shocking information leakage risk, you dare book the tickets online? (Linux)

- Ansible module Know (Linux)

- Python closure and function objects (Programming)

- Vi (Vim) keyboard map and its basic commands (Linux)

- Linux shell string interception and stitching (Linux)

- Using Ruby to build a simple HTTP service and sass environment (Server)

- C # function (Programming)

- Ubuntu 14.04 after the restart the default maximum screen brightness solutions (Linux)

- CentOS install SystemTap-2.6 (Linux)

- Upgrade installation manual CentOS6.5 GCC4.8.2 (Linux)

- After CentOS configure SSH password Free, still prompted for a password (Linux)

- Select helps secure the system network management tools (Linux)

- Sublime Text 3 using summary (Linux)

- Install Mac OS X 10.9 systems VMware10 (Linux)

 
         
  GoldenGate for Oracle data consistency initializing
     
  Add Date : 2018-11-21      
         
         
         
  Operation and maintenance of the process is the continuous generation of new problems, and the need to continue research process forward. November holiday just after Oracle customers to synchronize the data before the phone telling inconsistencies need to be addressed, but they can not stop business.

Here studies using RMAN initializing

- Do not need to shut down the source database.

1. Environment Introduction:

Three customer database, mutual synchronization between the three DDL, DML

2. Introduction:

Availability of each scene is not the same, the process is different, but generally similar step. My fault can not go directly to handle such a failure, you need to analyze the differences of each library, which library data is normal at initialization to other database, start the synchronization. Because it is the production environment, real-time data in the database changes, the source extraction process needs to open (transfer process can be opened), the recovery target side is stopped, and then open until initialization is complete.

3. The steps are as follows:

Production side ===============================================

1) Use the oracle user, execute rman backup

- Backup database:

mkdir -p / data / backup / data / dbback / gpofullbak

chown -R oracle.oinstall / data / backup / data / dbback / gpofullbak

rman target /

run {

allocate channel ch00 type disk maxpiecesize 30g;

allocate channel ch01 type disk maxpiecesize 30g;

crosscheck backupset;

delete noprompt expired backupset;

sql 'alter system archive log current';

backup as backupset skip inaccessible tag hot_db_bk_level0

full database

format '/ data / backup / bk_% s_% p_% t';

release channel ch00;

release channel ch01;

}

- Backup and archive control file:

run {

ALLOCATE CHANNEL ch00 TYPE DISK MAXPIECESIZE 30g;

ALLOCATE CHANNEL ch01 TYPE DISK MAXPIECESIZE 30g;

sql 'alter system switch logfile';

sql 'alter system switch logfile';

sql 'alter system switch logfile';

sql 'alter system archive log current';

BACKUP ARCHIVELOG ALL FORMAT '/ data / backup / ARCH_% U';

BACKUP CURRENT CONTROLFILE FORMAT '/ data / backup / bk_controlfile';

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}

- Perform the source machine

SQL> select * from Gv $ log;

  INST_ID GROUP # THREAD # SEQUENCE # BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE # FIRST_TIM NEXT_CHANGE # NEXT_TIME

---------- ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ----------- ----------- ------------ ---------

        1 1 1 795 52428800 512 1 YES INACTIVE 17689009 09-OCT-15 17689018 09-OCT-15

        1 2 1 796 52428800 512 1 YES INACTIVE 17689018 09-OCT-15 17689026 09-OCT-15

        1 3 1 797 52428800 512 1 NO CURRENT 17689026 09-OCT-15 2.8147E + 14

The record SCN number 17689018

========================================

SQL> create pfile = '/ tmp / initora11g.ora' from spfile;

scp -rp /tmp/initora11g.ora root@192.168.80.71: /u01/app/oracle/product/11.2.0/db_1/dbs/

scp -rp / data / backup / / data / dbback / root@192.168.80.71: / data

Target end ===============================================

2) Start the database to the state nomount

SQL> startup nomount

3) Start RMAN to restore the control file

rman target /

RMAN> restore controlfile from '/ data / backup / bk_controlfile';

4) Change the database to mount state

sqlplus / as sysdba

SQL> alter database mount;

5) Start RMAN to restore the database

rman target /

RMAN> restore database;

RMAN>

run

{

  set archivelog destination to '/ u01 / app / oracle / flash_recovery_area';

  SET UNTIL SCN 17689018; # Note the use of the previous record number of scn

  RECOVER DATABASE;

}

6) View

SQL> SELECT CHECKPOINT_CHANGE #, CHECKPOINT_TIME FROM V $ DATAFILE_HEADER;

CHECKPOINT_CHANGE # CHECKPOIN

------------------ ---------

          17689018 09-OCT-15

          17689018 09-OCT-15

          17689018 09-OCT-15

          17689018 09-OCT-15

          17689018 09-OCT-15

          17689018 09-OCT-15

          17689018 09-OCT-15

          17689018 09-OCT-15

8 rows selected.

SQL> alter database open resetlogs;

Here backup and recovery has been completed.

7) Start Recovery

start rini_1, aftercsn 17689018
     
         
         
         
  More:      
 
- Copy and paste in Linux terminal and Vim (Linux)
- Fatal NI connect error 12170 error in Alert Log (Database)
- Hadoop 0.23 compile common errors (Server)
- Linux novice common commands (Linux)
- Why you should choose Python Programming (Programming)
- Java input and output common class Scanner (Programming)
- Shell script to crawl through AWR SQL Report Problems (Database)
- Grep how to find files based on file contents in UNIX (Linux)
- ActiveMQ5.11.1 and JDK version matching relation (Linux)
- Ordinary users how to use the firewall software (Linux)
- Solaris 10 installation configuration mrtg monitoring system (Linux)
- JDK comes with tools JPS (Linux)
- Linux system security settings after installation (Linux)
- To explore the caching mechanism for Android ListView (Programming)
- How to view the Linux QPS (Linux)
- To teach you how to safely send mail (Linux)
- Perl said method B if A judge (Programming)
- RCU lock in the evolution of the Linux kernel (Linux)
- CentOS7 installation hardware monitoring for Zabbix enterprise applications (Server)
- Install VLC player on Ubuntu 14.10 (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.