Emergency order over Qld dam revoked