Database Administration (MOSC)

MOSC Banner

LogMiner and "UNKNOWN"."OBJ# and HEXTORAW

edited Apr 4, 2013 9:25AM in Database Administration (MOSC) 4 commentsAnswered
 Hi All,
Oracle 10g R2 Standard 

I had to dig into archived logs from last week for about 2 hour window on our production database.  Also we don't have additional supplemental logging on.
I'm mining on the same database.


But when I mine the logs, I got  -

update "UNKNOWN"."OBJ# 472665" set "COL 7" = HEXTORAW('c10d')

same thing for INSERTs.


I tried all 3 methods of using dictionary and still no luck. 
I know there is no DDL occured on the tables of interest, so why am I not getting actual object names and data values?

Is there anyway to get meaningful SQL REDO for this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center