All Blog Posts Tagged 'ORA-00265:' (1)

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

ACTION = Clean Shutdown Required  SHUTDOWN NORMAL , SHUT IMMEDIATE

SQL> select name , log_mode , flashback_on , dbid from v$Database;



NAME      LOG_MODE          FLASHBACK_ON             DBID

--------- ------------ ------------------       ----------

ORCL     …

Continue

Added by Rohit Khurana on February 28, 2012 at 11:30pm — 5 Comments

Monthly Archives

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…

Continue

Posted by Kirill Loifman on April 15, 2014 at 12:53am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service