Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unrecoverable_time column in v$datafile not being refreshed
My error was assuming that when you took the backup of the master database to refresh the Standby, the 'last unrecoverable' columns would be cleared, I now understand why you have a problem.
>
>This I am told will cause the Standby database to become unusable.
>
Not entirely true - although it may be effectively true for the application. Recover would continue and the database would start. It is just the object that was loaded unrecoverably that would be unusable, Oracle would mark the segments as 'logically corrupt'.
-- 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 <8t7ld0$414$1_at_nnrp1.deja.com>...Received on Thu Oct 26 2000 - 02:03:06 CDT
>
>11:00 - A direct load takes place. Log Shipping to the Standby is
>stopped because a change to the unrecoverable_time column has been
>detected. Now the Standby has to be refreshed and restarted with a
>backup from the Master database. This is done.
>
>11:55 Everything up and running again.
>
>12:00 Another direct load takes place. This time, though, it is not
>detected because the Monitor has detected no change to the
>unrecoverable_time column (because there hasn't been one even though a
>direct load has taken place) and the redo logs are transferred and
>applied to the Standby.
>
>This I am told will cause the Standby database to become unusable.
>