Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Standby database and UNRECOVERABLE
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...Received on Fri Oct 04 2002 - 15:19:47 CDT
> 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
>
>