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

   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@xxxxxxxxx> 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
>

Other related posts: