Bulk data update
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Bulk data update

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    Bulk data update

    DBAs,

    One bulk data update against one dev database. It got 20 millions of rows to update and so generated too much arch logs. We user SQL backtrack to backup the archive logs to Tivoli and then removes them,
    But the backup process is not fast enough to handle the fast archivelog generation process.
    It ended up fulling the arch destination and all the databases on that server hang there.

    What is the good solution for this scenario?

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    tune the code to produce less redo
    get a bigger filesystem to hold the archive logs

  3. #3
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    As it's a dev database, you could take it out of archive log mode. Kind of defeats the object of testing the code though.

  4. #4
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    thanks.

    I am thinking of taking this dev out of archivelog mode.

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