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: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 04 Oct 2002 19:28:17 +0200
Message-ID: <3sjrpugg5v43tqi35oet6el8n24bk03vtb@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 - 12:28:17 CDT

Original text of this message

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