nologging tables during failover
edited Feb 6, 2011 7:37PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 10 commentsAnswered ✓
hi
there is database which has a physical standby and has some tables which are in no logging mode.
i want to know if we change role what happens to that tables?
currently when we open standby database we can not read that tables
i have no idea what must happen when we fail over
is it supposed to encounter problem ?if no is it sync with the previous primary database?
( i heard some DBAs had no problem while failing over and data was completely sync with previous production,is it true?)
Please advice
Thanks
i want to know if we change role what happens to that tables?
currently when we open standby database we can not read that tables
i have no idea what must happen when we fail over
is it supposed to encounter problem ?if no is it sync with the previous primary database?
( i heard some DBAs had no problem while failing over and data was completely sync with previous production,is it true?)
Please advice
Thanks
0