This forum is currently locked. You can't register or post questions at this time. (read more)

tx and cache recovery - clean shutdown of DB

All posts relating to Oracle database administration.

Moderator: Tim...

Guest

tx and cache recovery - clean shutdown of DB

Postby Guest » Mon Nov 01, 2004 6:09 pm

Hello Tim,

In alert.log, I finding following type of info after NOMRAL / IMMEDIATE stop and start of database respectively -

disabling tx recovery
disabling cache recovery

enabling tx recovery
enabling cache recovery

I am aware that tx (ie transaction) recovery indicates rollback phase and cache indictaed rollforward phase of instance recovery

But the shutdown is not ABORT

Then why instance recovery details are reflected in alert log ?

Guest

RE:tx and cache recovery - clean shutdown of DB

Postby Guest » Mon Nov 01, 2004 6:09 pm

Any clues ??

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE:tx and cache recovery - clean shutdown of DB

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

Metalink Note:155754.1 states: "This behavior is intended functionality."

It's not a problem so ignore it. Provided you don't have a message like "Beginning crash recovery of 1 threads" you aer not doing a crash recovery.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron