ddy, Shrinivas (MED, Keane)
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 2:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: recovery during refresh
>
>
> Hi Gerardo,
>
> Thnq for responding.
>
> My doubt is , if I apply online lo
Hi Gerardo,
Thnq for responding.
My doubt is , if I apply online logs , will it cause index corruptions.
(ora - 600 error).
In my last refresh , I applied online redo log. I got the message when I
apply this log is Media recovery completed.
After that I opened the db with resetlogs. Everything
Run the following via svrmgrl or sqlplus
alter database backup controlfile to trace;
This generates a trace file in udump directory.
edit trace file:
1) strip out all lines prior to "STARTUP NOMOUNT..."
2) change all references to SID to test instance.
3) change all reference to file names t
Presumably all required transactions to be recovered were in the online
logs ? You cannot
copy the online logs "online" (when they are active !).
Check if those indexes were created NOLOGGING when the backup was running
-- that could
explain why the indexes could not be recovered.
If you canno
