RE: Oracle Archiving insanely

By any chance HOTBACKUP is turned on?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-----Original Message-----
Sent: Sunday, November 04, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L

H All,

        I am facing a very typical problem. One of my client's database has suddenly started archiving
like mad. There is no change ( claimed by users) made to the database. I checked Alert log, but could
not find anything.

        Many times it generates up to 50 Mb of Archives per minute( Earlier max upto 2-3 Mb/Min). I
did shutdown immediate, which took around 15 min ( acceptable), but immediately after next startup
(with no user logged on), in next 3 minutes, it generated 100 Mb of
Archives ( how'z that possible) ???????

        How can I find out what is the thing that's causing such a massive load on database. There is no
hotbackup going on. There is no Oracle scheduled job running. On OS side also there is no scheduled job in
cron. Please suggest how to get down to the problem. How can I find out which session/user is generating
so much of Redo? What possible preventive measures can I take???

        We are on Oracle 8.1.6.0.0 on TRU64 Unix.

Appreciate your suggestions and immediate help,

Rajesh

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.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). 


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).