Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Standby database and UNRECOVERABLE

Re: Standby database and UNRECOVERABLE

From: M Hashim <m.a.n.hashim_at_sympatico.ca>
Date: Fri, 4 Oct 2002 14:34:24 -0700
Message-ID: <A8ln9.16937$Qh1.1765685@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 - 16:34:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US