Home » Server Options » Replication » backup_problem_with_replication (Release 10.2.0.1.0, win XP)
backup_problem_with_replication [message #505257] Sun, 01 May 2011 00:18 Go to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi all,

i want to ask something regarding import/export utility... recently i commenced a replication project via materialized views. after successfully completing it, i wanted to take a safe point backup, so i opted for a full database export of both of my master site database and materialized view site's database (plus cold backups of both databases too). then i recreated the two databases & gave the same set of database names (global database names), set the oracle net etc..., imported the dump files at its respective sites and tried the replication activity but it didnt work...


there were alot of warnings while at the import activity, seemingly they were not of great signaficance but may be
that were the main reason of replication failure...

can some 1 advise me, is there any way out from this...? or what should be the best backup type for a repliction
project where there are database links and FROM clauses in the snapshots...

i use oracle Database 10g Enterprise Edition Release 10.2.0.1.0

following are some of the warnings that appeared in the import activity...

hoping for help...

regards


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

SQL> execute refresh_hamza; -- this procedure contains all the manual refreshes of my mat views, & it always worked earlier...
BEGIN refresh_hamza; END;

*
ERROR at line 1:
ORA-02019: connection description for remote database not found
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at "HAMZA.REFRESH_HAMZA", line 4
ORA-06512: at line 1


>>
---------------------------------------------------------------
warnings at master (HBFP) site:


IMP-00015: following statement failed because the object already exists:
"CREATE TRIGGER "SYSMAN".sev_annotation_insert_tr"


IMP-00015: following statement failed because the object already exists:
"CREATE TRIGGER "SYSMAN".sev_annotation_delete_tr"


IMP-00015: following statement failed because the object already exists:
"CREATE TRIGGER "SYSMAN".space_metrics_purge_trigger"


IMP-00017: following statement failed with ORACLE error 1:
"BEGIN SYS.DBMS_IJOB.SUBMIT(JOB=>1,LUSER=>'SYSMAN',PUSER=>'SYSMAN',CUSER=>"


IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_IJOB", line 210
ORA-06512: at line 1
. importing REPADMIN's objects into REPADMIN
. importing SH's objects into SH
. importing IX's objects into IX
---------------------------------------------------------------


warnings at materialized view (HBFM) site:


IMP-00017: following statement failed with ORACLE error 4021:
"ALTER PACKAGE "MGMT_BLACKOUT_ENGINE" COMPILE REUSE SETTINGS TIMESTAMP '2005"


IMP-00003: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object SYSMAN.MGMT_BLACKOUT_ENGINE
. importing SYSTEM's objects into SYSTEM
. importing HAMZA's objects into HAMZA
. importing SYSMAN's objects into SYSMAN


IMP-00015: following statement failed because the object already exists:
"CREATE TRIGGER "SYSMAN".sev_annotation_insert_tr"
" INSTEAD OF INSERT ON MGMT_SEVERITY_ANNOTATION"
" BEGIN"
" INSERT INTO MGMT_ANNOTATION"


IMP-00015: following statement failed because the object already exists:
"CREATE TRIGGER "SYSMAN".sev_annotation_delete_tr"
" INSTEAD OF DELETE ON MGMT_SEVERITY_ANNOTATION"
"BEGIN"
" DELETE FROM MGMT_ANNOTATION"


IMP-00015: following statement failed because the object already exists:
"CREATE TRIGGER "SYSMAN".space_metrics_purge_trigger"
" INSTEAD OF INSERT OR UPDATE OR DELETE ON mgmt_space_purge"


IMP-00017: following statement failed with ORACLE error 1:
"BEGIN SYS.DBMS_IJOB.SUBMIT(JOB=>1,LUSER=>'SYSMAN',PUSER=>'SYSMAN',CUSER=>"


IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_IJOB", line 210
ORA-06512: at line 1
. importing MVADMIN's objects into MVADMIN
. importing SYSMAN's objects into SYSMAN
. importing SYS's objects into SYS
. importing SYSMAN's objects into SYSMAN
. importing SYS's objects into SYS
. importing SYSMAN's objects into SYSMAN
. importing MUAWIYAH's objects into MUAWIYAH
. importing HAMZA's objects into HAMZA
. importing MUAWIYAH's objects into MUAWIYAH
Re: backup_problem_with_replication [message #506130 is a reply to message #505257] Fri, 06 May 2011 11:07 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>can some 1 advise me, is there any way out from this...? or what should be the best backup type for a repliction

1. Physical hot backup

2. RMAN backup

3. Cold backup but not export / import

Babu
Re: backup_problem_with_replication [message #511718 is a reply to message #506130] Tue, 14 June 2011 13:17 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi babu,

can u clarify my thought...? if for suppose i take rman full database backup. and after a month or so i reinstal a database with same structure and try to restore this backup. wont it give me any problem?? and whose db_id should i use then? the newer one or the db_id of the backup db???? plus how could i restore the control file and the spfile?

hoping for help,

regards
icon8.gif  Re: backup_problem_with_replication [message #511733 is a reply to message #511718] Tue, 14 June 2011 15:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your database link is missing, probably because it is in the SYS schema and not included in the export. You need to create it.

I already suggested this in your other topic on exactly this question, but you never repled. Not very polite of you. Frown
Re: backup_problem_with_replication [message #512324 is a reply to message #511733] Sun, 19 June 2011 02:57 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi john watson,

i couldnt find out my previous topic, sory for that...

i would like to tell you that all of my links reside in the system schema and the schema whose objects are replicated (hamza). Plus the export backup which i am talking about is the full database export. then why are the links not backed up???

hoping for even more courtesy
regards
Re: backup_problem_with_replication [message #512346 is a reply to message #512324] Sun, 19 June 2011 09:16 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
all of my links reside in the system schema and the schema whose objects are replicated (hamza)

Prove it! What do you have in dba_db_links on both daabases?
And what are your export and import scripts?
Re: backup_problem_with_replication [message #512348 is a reply to message #512324] Sun, 19 June 2011 09:25 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
shehpar wrote on Sun, 19 June 2011 09:57
i couldnt find out my previous topic, sory for that...


All your messages can be found in your profile:

/forum/fa/9125/0/
  • Attachment: profile.PNG
    (Size: 16.27KB, Downloaded 2454 times)
Previous Topic: Materialized View Not Refreshing Automatically
Next Topic: Problem using goldengate to extract data from ASM - 10G
Goto Forum:
  


Current Time: Thu Mar 28 07:26:32 CDT 2024