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
Oracle LazyDBA home page