Recovery after INDEX rebuild. [message #463574] |
Fri, 02 July 2010 01:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi,
Suppose i have taken full backup at 1AM.
After that at 4 AM i rebuild index with nologging option.
1> Will it create logs for rebuilding?
Then after thar at 6 AM if i will go for recovery.
2> then what is the status of index? Will it be at previous state from the backup or will it be from rebuild state?
Thanks for any help.
|
|
|
|
Re: Recovery after INDEX rebuild. [message #463593 is a reply to message #463576] |
Fri, 02 July 2010 02:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Can you please explain why it will be in INVALID state?
Because i think that as we are going for recovery we can recover the index untill INDEX rebuild happened.
Am i correct?
Thanks,
|
|
|
|
|
|
|
|