咨询微信： dbservice1234 7 x 24 在线支持！

首页

下载 DBRECOVER

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

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

Posted by PDSERVICE on 1月 18, 2016 In
 

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

Parnassusdata Software Database Recovery Team

Service Hotline:  +86 13764045638 E-mail: service@parnassusdata.com

 
APPLIES TO:
 
Oracle Server - Enterprise Edition - Version: 10.2.0.4
 
This problem can occur on any platform.
 
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.
 
 
 
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.