详解ORA-00600[4193]错误

SYMPTOMS Copying database from one server to another server and getting an ORA-600 {4193] error when trying to open the database on the destination server. CAUSE The online redo logs were copied when the source database was open, online redo logs should never be copied when the database is open. SOLUTION In this instance the datafiles were being copied properly after the tablespaces were put in to backup mode, however, online redo logs should only be copied if the source database is shutdown first before copying the online redo logs. The source database needed to remain open so, the datafiles were copied again (with the tablespaces in backup mode) and then a number of archivelogs were transferred over to the new server and after the last archivelog was applied the database could be opened with resetlogs and new online redo logs were created on the destination server. REFERENCES NOTE:39282.1 - ORA-600 [4193] "seq# mismatch while adding undo record"