Re: standby database and nologging DDL
From: Gary Thrower <Gary.Thrower_at_oracle.com>
Date: Fri, 13 Jul 2001 13:58:47 -0600
Message-ID: <3B4F52F7.406916B_at_oracle.com>
Date: Fri, 13 Jul 2001 13:58:47 -0600
Message-ID: <3B4F52F7.406916B_at_oracle.com>
You can use nologging but you must recreate the standby database after the nologging has been performed. Probably more efficient to not use the nologging in production if using a standby database.
Regards,
Gary Thrower
ff wrote:
> After we failover to our standby database, I found some data are not
> available, oracle complains that datafile are corrupted because nologging
> was used for some index created at production database.
>
> Does it mean that when you are using standby database, you can not use
> nologging for DDL at all? Otherwise, how can you send the redo to the
> standby site?
>
> You input is highly appreciated.
Received on Fri Jul 13 2001 - 21:58:47 CEST