Home » RDBMS Server » Backup & Recovery » Recovery after INDEX rebuild.
Recovery after INDEX rebuild. [message #463574] Fri, 02 July 2010 01:06 Go to next message
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 #463576 is a reply to message #463574] Fri, 02 July 2010 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1> No, NOLOGGING is no logging.
2> INVALID, you have to rebuild/recreate the index.

Regards
Michel
Re: Recovery after INDEX rebuild. [message #463593 is a reply to message #463576] Fri, 02 July 2010 02:01 Go to previous messageGo to next message
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,
Re: Recovery after INDEX rebuild. [message #463600 is a reply to message #463593] Fri, 02 July 2010 02:26 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi Michel,

Could you please send me oracle note/documentation on the same?
I could not find the exact scenario on the google.

Thanks,
Amol
Re: Recovery after INDEX rebuild. [message #463606 is a reply to message #463600] Fri, 02 July 2010 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just try it by yourself, this is the best way to see and learn.

Regards
Michel

[Updated on: Fri, 02 July 2010 02:47]

Report message to a moderator

Re: Recovery after INDEX rebuild. [message #463611 is a reply to message #463606] Fri, 02 July 2010 03:56 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I really appreciate your help....

I referred Metalink note ID : 794505.1
Re: Recovery after INDEX rebuild. [message #463619 is a reply to message #463611] Fri, 02 July 2010 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And this note says you have to recreate the index.

Regards
Michel
Re: Recovery after INDEX rebuild. [message #463624 is a reply to message #463619] Fri, 02 July 2010 05:08 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Yes thats what i was searching for.

Anyways thank you.
Previous Topic: recreate parameter file on lost
Next Topic: Error in database cloing
Goto Forum:
  


Current Time: Thu Mar 28 11:16:09 CDT 2024