-
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 ??
Thanks
Kishore Kumar
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|