Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dataguard/Standby database and NOLOGGING tables of primary database

rahulrasOct 12 2005 — edited Oct 13 2005

Hi all,

I am on 10.1 database and we have a standby database managed by dataguard.

My question is, is there a real need that when we have standby database, we should have all table/partitions/indexes as LOGGING?
If I create a table/tablespace with NOLOGGING, will that be a problem with the standby?
Is there a way to have a standby database and also some part of my database, may be few tables or a tablespace in NOLOGGING mode?

Please explain.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2005

Added on Oct 12 2005

#general-database-discussions

8 comments

813 views