Hello,

We want to update a very large table in steps.
While updating we want to use the not logged initially, as following

ALTER TABLE log ACTIVATE NOT LOGGED INITIALLY;
update log set message = 'XXX' where timestamp >='2010-08-25 00:00:00.000000' and timestamp <'2010-08-26 00:00:00.000000' ;
COMMIT;

We know that in this case the HADR database won't get updated.
But will the HADR database still work and can we use the table if we need to set the HADR database as primary?

Thanks in advance.

The standby database will work, but I believe the table will be unusable after the take-over.

Nick's statement is correct. HADR standby needs everything to be logged otherwise there is no way to implement the change(s).
Dave

Thanks, we have decided not to use the 'not logged initialy' statement.