Re: ORA-16205: DDL skipped due to skip setting
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: Jason Heinrich <jheinrichdba@xxxxxxxxx>
- Date: Wed, 14 Apr 2010 14:38:56 -0500
SQL> select count(*) from dba_logstdby_skip ;
COUNT(*)
----------
0
SQL>
On Wed, Apr 14, 2010 at 12:35 PM, Jason Heinrich <jheinrichdba@xxxxxxxxx>wrote:
>
> 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:
