Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015

    Unanswered: Stop HADR for offline reorg


    I'm going to do offline reorg on some large tables(20 million records) on primary DB (10.5 on linux), secondary DB configured to be sync by by Async mode.
    Should I stop HADR before running offline reorg?
    I'm concern that generated logs during reorg causing secondary db huge gap log.


  2. #2
    Join Date
    May 2012
    Canberra, Australia
    Provided Answers: 6
    20 million records is not a huge table unless you have a large rowsize and/or inline lobs etc. Have you read this?

    We regularly run parallel reorgs on tables with 100 million+ rows and have not had a log space issue.
    What are the log parameters? logprimary, logsecond, logfilsiz

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

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