Shulou(Shulou.com)06/01 Report--

1031 ogg restore operation

1. Stop the replication process on the destination side and delete the replication process of the destination side OGG

Ggsci > dblogin userid ggtarget,password ggtarget

Ggsci > stop repesse

Ggsci > delete replicat repesse

2. Stop the transmission and extraction process on the source side, delete the transmission process of the source side OGG, and extract the process

Ggsci > dblogin userid ggsrc, password ggsrc

Ggsci > stop dpesse

Ggsci > stop extesse

Ggsci > DELETE EXTTRAIL / home/ogg/dirdat/es

Ggsci > DELETE rmttrail / home/ogg/dirdat/es

Ggsci > delete EXTRACT extesse

Ggsci > delete EXTRACT dpesse

3. Clear the TRAILS files on the source side and the destination side

Log in to the source server:

Cd / home/ogg/dirdat/

Rm-rf *

Log in to the target server:

Cd / home/ogg/dirdat/

Rm-rf *

4. Back up the parameter file

Log in to the source server:

Cd / ogg/dirprm

Mv extesse.prm extesse.prm.old

Mv dpesse.prm dpesse.prm.old

Log in to the target server:

Cd / ogg/dirprm

Mv repesse.prm repesse.prm.old

5. Configure the extract process on the source side

Ggsci > add extract extesse, tranlog, begin now, threads 2

Ggsci > edit params extesse

Extract extesse

Setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)

USERID ggsrc, PASSWORD ggsrc

Reportcount every 120 minutes, rate

Report at 01:00

Reportrollover at 01:15

EXTTRAIL / home/ogg/dirdat/es

TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY INSTANCE essedb2 / home/arch3, ALTARCHIVELOGDEST INSTANCE essedb1 / home/arch2

TRANLOGOPTIONS ASMUSER SYS@ESSEDBASM,ASMPASSWORD ORACLE

Threadoptions maxcommitpropagationdelay 30000

Discardfile. / dirrpt/extesse01.dsc, append megabytes 100

Discardrollover at 01:15

Warnlongtrans 4h, checkinterval 5m

Dynamicresolution

Table shema.tablename

Ggsci > add exttrail / home/ogg/dirdat/es, extract extesse, megabytes 50

Ggsci > start extesse

6. Configure the datapump process on the source side

Ggsci > add extract dpesse, exttrailsource / home/ogg/dirdat/es

Ggsci > edit params dpesse

Extract dpesse

Setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)

USERID ggsrc, PASSWORD ggsrc

Rmthost 10.154.2.80, mgrport 7809

Rmttrail / home/ogg/dirdat/es

Passthru

Discardfile. / dirout/dpesse01.dsc, append megabytes 100

Discardrollover at 00:00 on sunday

Reportcount every 30 minutes, rate

Report at 01:00

Reportrollover at 01:15

Dynamicresolution

Table shema.tablename

Ggsci > add rmttrail / home/ogg/dirdat/es, extract dpesse, megabytes 50

Ggsci > start dpesse

7. The target side configures the replicat process, but does not start it.

Ggsci > add replicat repesse exttrail / home/ogg/dirdat/es

Ggsci > edit params repesse

Replicat repesse

SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")

Userid ggtarget, password ggtarget

Assumetargetdefs

ReportCount Every 30 Minutes, Rate

Report at 01:00

ReportRollover at 01:15

Reperror default, abend

Discardfile. / dirout/repesse01.dsc, append, megabytes 100

DiscardRollover at 02:00 ON SUNDAY

Dynamicresolution

MAP shema.tablename, target shema.tablename

8. Initialize data

SQL > select dbms_flashback.get_system_change_number from dual

16423942351

Cd / home/backup/expdpdir

Export NLS_LANG=american_america.ZHS16GBK

Export using expdp

Create dumpfile

Create directory expdpdir as'/ home/backup/expdpdir/'

Create a new directory / home/backup/expdpdir/ on 94

Create the export file expdp1031.par:

DIRECTORY=expdpdir

DUMPFILE=esse1031_%U.dmp

LOGFILE=esse1031.log

Tables=tablenames...

ACCESS_METHOD=DIRECT_PATH

Filesize=10000M

Parallel=4

Flashback_scn=16423942351

Nohup / usr/bin/time-p expdp dbuser/dbuserpasswd@orcl parfile=expdp1031.par > / home/backup/expdpdir/expdp1031.log &

10. Prepare the library for import

Create dumpfile

Create directory expdpdir as'/ home/backup/expdpdir/'

Create a new directory / home/backup/expdpdir/ on 94

Create the export file impdp1031.par:

DIRECTORY=expdpdir

DUMPFILE=esse1031.dmp

LOGFILE=esse1031.log

Remap_tablespace=TS_KCS_FLOW:EAPP_DATA1,IDX_KCS_FLOW:EAPP_IDX1

TABLE_EXISTS_ACTION=SKIP

Parallel=10

Nohup / usr/bin/time-p impdp dbuser/dbuserpasswd@bkorcl parfile=impdp1031.par > / home/backup/expdpdir/imp0801.log &

When ORA-01659: unable to allocate MINEXTENTS beyond 4 in tablespace appears

Resize the resize data file without changing the size

Alter database datafile'/ home/oracle/oradata/bmzbbdb/EAPP_IDX1.dbf' resize 20480m

11. Start the replication process

Start repesse, aftercsn 16423942351

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.