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 a
dbverify . That is ok.
6) We have async io on both prod and reporting database and raw devices .
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
