RE: streams capture specify SCN without dbms_cature_adm.build

It is not necessary that you run the dictionary build procedure as long as there aren't any schema changes.

You could try to set the instantiation SCN at the target site using the following procedure and initiate the streams: begin

    dbms_apply_adm.set_schema_instantiation_scn (

    source_schema_name    => '<schema>',
    source_database_name  => '<dbname>',
    instantiation_scn     => SCN########,
    recursive             => true);   

In most instances you may be successful, worst case if you see errors for a few objects, you could refresh only those objects.

-Upendra

> Date: Thu, 7 Apr 2011 21:29:49 -0700
> From: mark.van.de.wiel_at_gmail.com
> To: afatkulin_at_gmail.com
> CC: ujang.jaenudin_at_gmail.com; oracle-l_at_freelists.org
> Subject: Re: streams capture specify SCN without dbms_cature_adm.build
>
> If your table definitions have not changed since the import then you can
> use GoldenGate to capture all transactions since the import. You cannot
> tell GoldenGate's capture process (extract) to start at an SCN, but
> rather you use a date/time. If you want to process transactions only
> after a certain SCN then you can do so when you start the apply process
> (replicat).
>
> Of course, GoldenGate is separately licensed...
>
> Mark.
>
> On 04/07/2011 10:13 AM, Alex Fatkulin wrote:
> > The build is required for data dictionary build to be dumped into the
> > redo stream which can then be used to populated the MVDD.
> >
> > If you didn't do the dictionary build then you won't be able to start
> > your capture process (it will be in "waiting for dictionary redo"
> > forever).
> >
> > On Thu, Apr 7, 2011 at 5:22 AM, Ujang Jaenudin<ujang.jaenudin_at_gmail.com> wrote:
> >> dear lists,
> >>
> >> we had done impdp, and didn't do dbms_capture_adm.build before expdp.
> >> but we noted the scn before expdp and specify that SCN during expdp.
> >>
> >> so my question, can we set SCN for the capture process
> >> by using dbms_logmnr.start_logmnr(STARTSCN...
> >> ... OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);
> >>
> >> we are in 10.2.0.1
> >>
> >>
> >> --
> >> thanks and regards
> >> ujang jaenudin
> >> jakarta - indonesia
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> >>
> >>
> >>
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
                                               

--
http://www.freelists.org/webpage/oracle-l