Oracle ORA-600 [4193] When Trying To Open The Database

Oracle ORA-600 [4193] When Trying To Open The Database

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

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.