Re: ORA-16205: DDL skipped due to skip setting

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Wed, 14 Apr 2010 12:35:26 -0500
Message-ID: <w2xb32e774d1004141035ob4aca66fv468f0312e5b976df_at_mail.gmail.com>


  1. Assuming the datafile needs to be resized, yes, you will need to resize it manually.
  2. See the dba_logstdby_skip view.
--
Jason Heinrich


On Wed, Apr 14, 2010 at 10:59 AM, Roger Xu <wellmetus_at_gmail.com> wrote:


> Hi experts,
>
> - Oracle 9i logical standby
> - standby_file_management = MANUAL
> - dictionary managed
>
> Please see the first lines in the alert log file:
> LOGSTDBY event: ORA-16205: DDL skipped due to skip setting
> LOGSTDBY stmt: alter database datafile
> '/dnridx10/oradata/pdon/don_idx_2_06.dbf' resize 2000M
> Wed Apr 14 10:06:48 2010
> LOGSTDBY event: ORA-16204: DDL successfully applied
> LOGSTDBY stmt: ALTER USER W13190 IDENTIFIED BY VALUES '04EB784EDB4EADD2'
>
>
> 1. Do I need to manually resize the datafile in the standby database as
> well?
> 2. How do I find out what kind of DDL is set to skip?
>
> Thanks,
>
> Roger Xu
>
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 14 2010 - 12:35:26 CDT

Original text of this message