RE: Shutodown ABORT - Problems?

I have heard both from Oracle personal. However, their manuals state that if you bring a database down in abort you should bring it up and bring it back down normal to allow it to do its recovery. I have never had an issue yet but typical I do do that if I bring a database down in abort mode.

-----Original Message-----
From: Alldaffer, Ron [mailto:ralldaff_at_siemens-psc.com] Sent: Thursday, September 14, 2000 1:01 PM To: Multiple recipients of list ORACLE-L Subject: Shutodown ABORT - Problems?

Hello,

Recently we had a Support Analyst from Oracle's Center of Excellence in house to diagnose quite a few problems we have running Parallel Server with 8.0.6 and 8.1.6 on IBM AIX RS6000 HACMP Clusters.

The workaround for one of our problems includes issuing shutdown aborts on our databases on one member of our cluster if a LAN becomes unavailable.

I asked Oracles support analyst if there is any problem doing a shutdown abort,
in particular database corruption or errors, and he claimed no, shutdown abort
is a perfectly safe thing to do.

Now, I am not one to routinely second guess employees of Oracle when they discuss their product, but I just don't believe this. It seems that a shutdown abort
may cause problems when you try to bring the database back up, especially if issued while one of the background tasks is in the process of moving data from
memory to disk.

Can anyone out there either confirm or deny these words of wisdom from Oracle support?

Thanks for your input.

Ron Alldaffer
Ciber, Inc.

-- 
Author: Alldaffer, Ron
  INET: ralldaff_at_siemens-psc.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).