Part-I ---- how to setup stream replication between two databases
http://dbataj.blogspot.com/2008/01/oracle-streams-setup-between-two.html
Part-II --- how to add new site in existing stream replication
http://dbataj.blogspot.com/2008/01/oracle-streams-adding-new-site-in.html
New TARGET Database alert
knllgobjinfo: MISSING Streams multi-version data dictionary!!!
Source Database: DB1
Existing TrgtDB: DB2
New Trgt DB: DB3
WORKAROUND:
Existing Target Database: DB2
1. Stop apply process at all existing target sites
SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> exec dbms_apply_adm.stop_apply('apply_stream');
PL/SQL procedure successfully completed.
Source Database: DB1
2. Prepare instantiation SCN
SQL> conn strmadmin/strmadmin@db1
Connected.
SQL> begin
2 dbms_capture_adm.prepare_table_instantiation(table_name => 'scott.taj');
3 end;
4 /
PL/SQL procedure successfully completed.
Existing Target Database: DB2
3. Start apply process at all existing target database
SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> exec dbms_apply_adm.start_apply('apply_stream');
PL/SQL procedure successfully completed.
5 comments:
Hi, constantly i used to check blog posts here early in the break
of day, since i enjoy to gain knowledge of more and more.
my site; yellow
Spot on with this write-up, I seriously feel this
web site needs much more attention. I'll probably be returning to read through more, thanks for the information!
Also visit my web site; laythes
I tend not to create a leave a response, but I read a few of the responses on this page "knllgobjinfo: MISSING Streams multi-version data dictionary!!!".
I do have 2 questions for you if it's okay. Is it simply me or do a few of the comments look like they are written by brain dead visitors? :-P And, if you are writing at other online sites, I would like to keep up with you. Would you post a list of every one of your shared pages like your twitter feed, Facebook page or linkedin profile?
Here is my page :: samhoun
Every weekend i used to pay a visit this website,
as i wish for enjoyment, as this this site conations truly pleasant funny
stuff too.
Have a look at my website :: customized twitter backgrounds
I have been exploring for a little for any high quality articles or weblog posts on this kind
of space . Exploring in Yahoo I at last stumbled upon this web site.
Studying this info So i'm happy to exhibit that I've a very
good uncanny feeling I came upon exactly what I needed.
I so much for sure will make sure to do not overlook this
website and give it a look on a continuing basis.
Here is my weblog: methods to buy followers on social media service twitter
Post a Comment