Re: Standby database and UNRECOVERABLE

From: Karsten Farell <kfarrell_at_medimpact.com>
Date: Fri, 04 Oct 2002 20:52:22 GMT
Message-ID: <acnn9.745$5u3.62169313@newssvr13.news.prodigy.com>

Simply: yes and/or no.

For the 'yes': As you mentioned, copying the data files will require a recovery to sync the control files (that step would be the same as if you lost the disk on which the index tablespaces were located). That means you have to copy more than the data files (ie, some/all of the redo or archive log files).

For the 'no': Depending on the current contents of your standby database, you could mess things up even more by copying just certain pieces of the database. What you're likely to end up with is a database that Oracle can't figure out how to properly recover ... the indexes will be newer/older than the data they index ... constraints might be violated ... and on and on. Oracle recovery (by restoring data files of any kind - data/index) is meant to be done against the same database they were hot backup'd from.

Conclusion: drop the indexes and recreate them (or rebuild them) ... but only if you can find a day or so that you can have the database to yourself (it can't be quick to create a 10g+ index).

As for some people who answer a poster's questions with unhelpful remarks ... well, I've found you have to have a pretty tough geek-skin to dare to post in this newsgroup. There are a lot of helpful people here ... I listen to their posts. There are a lot of not-so-helpful people here ... I ignore their posts. Works for me. :)

Chuck wrote:

> One has to wonder whether Sybrand can ever give a straight answer too.
> Anyone want to try answering the actual question? A simple Yes or No will
> do. BTW I figured that performing recovery on the standby was obvious so I
> didn't mention it. Perhaps I should have.
> --
> Chuck
> 
> "M Hashim" <m.a.n.hashim_at_sympatico.ca> wrote in message
> news:A8ln9.16937$Qh1.1765685_at_news20.bellglobal.com...
> 

>>One wonders whether there is ANY preliminary work done before such a
>>question is posted. Have to agree with you Sybrand.
>>
>>"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
>>news:3sjrpugg5v43tqi35oet6el8n24bk03vtb_at_4ax.com...
>>
>>>On Fri, 4 Oct 2002 11:31:33 -0400, "Chuck" <chuckh_at_softhome.net>
>>>wrote:
>>>
>>>
>>>>Oracle 8.1.7.
>>>>
>>>>I have a primary and a managed standby database. I need to build two
>>>

> very
> 

>>>>large indexes (10g+) on the primary database. If I use the
>>>

> unrecoverable
> 

>>>>option to speed it up, can I copy the datafiles for the tablespaces
>>>

> that
> 

>>>>contain the indexes to the standby database to get the indexes over
>>>

> there
> 

>>or
>>
>>>>will I still be missing pieces from the data dictionary? Obviously this
>>>>would need to be a hot backup.
>>>>TIA
>>>
>>>
>>>Try it and report the results.
>>>or better still: read the manual before screwing up.
>>>
>>>
>>>Regards
>>>
>>>
>>>Sybrand Bakker, Senior Oracle DBA
>>>
>>>To reply remove -verwijderdit from my e-mail address
>>
>>

>
> Received on Fri Oct 04 2002 - 15:52:22 CDT