Home » RDBMS Server » Server Utilities » backup_problem_with_repliction_project (oracle 10.2.0.2 win xp)
backup_problem_with_repliction_project [message #511367] Sun, 12 June 2011 07:47 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_repliction_project [message #511406 is a reply to message #511367] Sun, 12 June 2011 13:09 Go to previous message
John Watson
Messages: 8644
Registered: January 2010
Location: Global Village
Senior Member
This is your problem,
Quote:
ORA-02019: connection description for remote database not found

Your database link is missing. You need to create it. Is it a public link, or did you create it in the SYS schema? If so, was it included in the export/import?
Previous Topic: character set erro while importing.
Next Topic: Datapump API
Goto Forum:
  


Current Time: Wed Dec 08 04:54:47 CST 2021