Re: Need to examine some redo logs.

DA Morgan wrote:
> Precisely what do yo mean by "I need to examine ... archive redo logs?"
>

I need to list what objects are inserted/deleted/updated. That's all.

> I would hate to give you any advice without knowing precisely what it
> is you are planning to do. Because so far what you've written gives
> no sense of confidence that you should be doing anything other than

Why thanks. I'm glad you see it this way. Unfortunately, my boss doesn't. So I'm stuck trying to figure out what the heck our clients are doing with our software, before they threaten to leave us, along with their $400k account, and my boss canning me too. :)

Since, I'm new to the company, and I've developed Oracle programs, never did any DBA work, much less know the issues surrounding redo logs, I'm completely clueless. All our senior developers left within a week without training the juniors, and that's where I am today.

Our software examines redo logs to report on who was poking around on a database and what they did. Our clients gave us their archive redo logs to run locally. Our software is not picking up any activity given about 10GB worth of archive redo logs. It just spins it's wheels, then exits 0. I suspect they plainly gave us the wrong files from a different instance, and because of quirks in our software, I'd really need to examine the contents of the redo logs.

I could use logminer, and that would be my next question, but I'd like to know how to dump another oracle instance's redo logs. And just examine the output.

Examining the output would be a great way for me to learn our software.  A great deal of knowing our software is knowing how oracle redo logs work. I think there's an advantage of going 'straight to the source', than reading our code directly and learning what another guy thought how oracle redo logs worked. yes, there's advantages in each viewpoint. I've done the latter a few times. I want and even need the former.

> passing this to someone that knows what they are doing.

Sure I'd love to, but I have to learn it sometime. I'd rather get my lumps now, than later.

> I would hate to give you any advice

Well now you know. But really, why be so caring? This bit of knowledge won't get me into trouble. Client threatening to leave, a company on hobbling around, and a CEO hoping it a junior developer can bail it out of it's woes, these issues really trouble the mind. The trouble this information can get me into is really trivial when you consider the larger picture.

Sorry to get all cathartic on you. It would have been easier to just fork over the information, and care for larger issues like global warming, than a junior DBA sinking with the ship. :) Received on Mon Jul 04 2005 - 10:14:23 CDT