Obama says history will remember the attack on Congress as “a moment of great dishonor and shame for our nation”.