Theoretically when archiving is disabled the archives shouln't need to be archived but be able to write over themselve. However, I have observed in 8i that even after you have disabled archiving by issuing a alter system call yet the database remain in a confused state about whether to archive or not until you also issue the command alter database noarchive [in mount stage]. If you are stuck after doing the first step all you need is to issue a manual archive all statement and get out of the hung mode. Then go issue the second command. Please note you will have to log in as
svrmgrl
SVRMGRL>connect internal
or
sqlplus /nolog
SQLPLUS>Connect sys as sysdba
depending upon if you are in 8i or 9i

Gurmohan
www.onlymath.com - Place to learn and teach math.



-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x65397234.[Email address protected]
Sent: Thursday, December 29, 2005 12:11 PM
To: LazyDBA Discussion
Subject: RE: archive log stop: rollback:



If automatic archiving is disabled, then when all your redo logs fill up,
the database will stop because it cannot switch the log until an archive is
complete (which must be manually started since the auto archiving was
disabled).

I believe this is what happened. The problem is not with rollback, the
problem is the database has no more redo logs and can't archive.

| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x34403964.[Email address protected]
Sent: Thursday, December 29, 2005 10:01 AM
To: LazyDBA Discussion
Subject: archive log stop: rollback:

I disabled the automatic archive.



Delete data from table



SQL> delete from kill_load;



273848 rows deleted.



Elapsed: 00:02:04.01

SQL>



SQL > rollback



Which gave the following wait events

log file switch (archiving nee |0| 3| WAITING

log file switch (archiving nee |0| 9| WAITING

...



I tried to kill the sql process. Then database has hanged. I found the
following error in alert_log

"PMON failed to delete process, see PMON trace file",



Can some body tell what is the problem? Is there any problem in rollback
while automatic archive is disabled.



Regards,

Sree



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page