NOLogging vs HotBackup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: NOLogging vs HotBackup

  1. #1
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317

    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

  2. #2
    Join Date
    May 2001
    Location
    Seattle
    Posts
    9
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Are you using proper temporary tables for this?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width