Re: unrecoverable_time column in v$datafile not being refreshed

Does the unrecoverable_change# get updated, or does it behave the same way ?

Personally I would expect the manual to be wrong. What good does it do you to know when the LAST unrecoverable event occurred ? Surely you need to know when the FIRST one occurred ? After all, if the file goes unrecoverable after 11:00 because of a direct load, it is still notionally unrecoverable after 11:00 even if you do another direct load at 12:00.

Must be another case of the left hand tower not talking to the right hand tower at Redwood.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk


Practical Oracle 8i:  Building Efficient Databases - Publishers Addison
Wesley Longman
Book bound date now 1st Dec 2000


Steve Roper wrote in message <8t6k4f$58c$1_at_nnrp1.deja.com>...


>Hi,

>

>I just put this problem in as a TAR to Metalink, but I just wondered if

>anyone else had come across the same issue:

>

>Oracle8i 8.1.5.0.0 on SEQUENT DYNIX/ptx(R) V4.5.1

>

>I was testing the implementation of a standby database and required a

>script to monitor the LIVE database for operations that are not

>captured in the Redo Logs.

>

>As part of the test I used SQL Loader to insert data into a table using

>the direct path method.  After the direct path load, I queried the

>column "unrecoverable_time" in the v$datafile view.

>

>If the column was already null then a time stamp of the datafile change

>was recorded in the column.

>

>However, subsequent direct loads were not recorded in the

>"unrecoverable_time" column.

>

>In short the timestamp was not refreshed and consequently I was unable

>to ascertain that non-logged direct loads had occurred.

>

>The archived redo logs are required to be applied to a STANDBY

>database, which may become corrupt if unlogged activities have not been

>detected in time.

>

>This error does NOT occur (i.e. the timestamp IS updated) if SQL data

>changes are made unrecoverable in SQLPLUS.

>

>Any feedback would be most welcome.

>

>regards

>

>Steve Roper

>Database Administrator

>EDS (UK) Ltd

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.