NOLogging vs HotBackup
I have some set of tables where temporary data is stored into them when ever a report is run. Due to which, lot of arhive log is getting generated. To avoid access log being created, I disabled LOGGING on those tables. Right from that time, the every day hotbackup is taking 3 times longer than regular time.
Is there any trade off between NOLOGGING and HotBackup ??
As far as I know it should not have a affect on hotbackup.
Also nologging is only used for direct loads and CTAS. So just altering table to nologging does not have any affect on log generation unless you are doing either direct load or CTAS.
I would check on any abnormal activity during hotbackup time to troubleshoot.
Are you using proper temporary tables for this?
Click Here to Expand Forum to Full Width