The error 'cannot allocate new log, archival required' suggests that your redo log files are small in size. You will tend to see this during a bulk insert/delete or during an import. Increase the size of the redo log files.