Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Problems in replication
Hi,
We have a replication between production and reporting database.
Prodn Server Reporting server HP-UX 10.2 HP-UX 10.2 oracle 7.3.4.4.1 oracle 7.3.4.4.1
The os and oracle patches on the production server and reporting server are in sync.
Problem:-------------- The replication goes fine. On the reporting
database .
1) But sometimes a query hangs. Dropping and recreating a snapshot seems
to solve the problem and the query executes properly after that.
2) This has happened on different tables . We have reorged the database on
different disks .
3) Hp and EMC have confirmed that the problem does not lie with the disk. 4) The export for that particular table (snapshot) hangs. 5) We have dumped the related logical volume to a filesystem and did adbverify . That is ok.
Has anyone encountered such a problem . Any tips would be appreciated .
7) We have logged a tar on metalink , the responses obtained have been implemented , but the problem of a query hanging and working properly after a recreation of snapshot still continues.
shreepad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Shreepad.Vaidya_at_alltel.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 09 2002 - 07:42:24 CST