Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the steps of database reset DML configuration ogg", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "database reset DML configuration ogg what are the steps" it!

The production database and the ogg target database are completely corrupted for some reason, that is, the data is no longer synchronized

But the parameter file and the ogg installation directory still exist, and the following operation is established in this case--

The following steps need to log in before performing the operation

Dblogin USERID xxx, PASSWORD xxx

1. Delete the data of the source side and the target side, including the data of the collection side and the data received by the target side

Dblogin USERID xxx, PASSWORD xxx

Delete extract ERxx

Delete extract PRxx

Delete the source and destination et and rt files, that is, the files generated by the collection process and the sending process

Add the extraction process. ADD EXTTRAIL is followed by the file address, and et represents the file name.

Add extract ERxx tranlog,begin now

ADD EXTTRAIL xxx/et, EXTRACT ERxxx

Add sending process

Exttrailsource is followed by the place where the data is collected and put, and et indicates the beginning of the file.

RMTTRAIL indicates the address where the data is stored on the target rep side, and rt indicates the beginning name of the file

Add extract PRxx,exttrailsource xxx/et

ADD RMTTRAIL xxx/rt,EXTRACT PRxx

Reconfigure the location and starting point of the archive file extracted by the ogg extraction process

-extseqno stands for archivelog

Alter extract ERxxx, extseqno 2, extrba 0

Start EXTRACT ERxxx

Restart the file name and starting point that the configuration ogg sending process sends to the peer file

Alter extract PRxxx etrollover

Alter extract PRxxx, extseqno 0, extrba 0

Start EXTRACT PRxxx

Export prod requires derivative schema data and import it to the ogg target side

Select to_char (dbms_flashback.GET_SYSTEM_CHANGE_NUMBER) from dual

15727212700618

Create or replace directory dp as' xxx'

Expdp\'/ as sysdba\ 'directory=dp dumpfile=xxx_%u.dmp logfile=xxx.log content=data_only schemas=xxx

PARALLEL=3 FLASHBACK_SCN=15727212700618

Create or replace directory dp as' xxx'

Impdp\'/ as sysdba\ 'directory=dp dumpfile=xxx_%u.dmp logfile=xxx.log\

Schemas=xxx PARALLEL=3 TABLE_EXISTS_ACTION=TRUNCATE

Destination operation after import

Delete replicat RPTxx

Add target-side rep process

Add replicat RPTxx,exttrail xxx/rt, checkpointtable CHECKPOINTTABLE

Start RPTxxx aftercsn 15725097666036

Point the destination rep process to a starting point in a file

Alter REPLICAT RPTxxx,extseqno 1,extrba 0

At this point, I believe that everyone on the "database reset DML configuration ogg steps are what" have a deeper understanding, might as well to actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.