Home » RDBMS Server » Backup & Recovery » recovery of database
icon5.gif  recovery of database [message #110325] Sat, 05 March 2005 20:17 Go to next message
ns_deep
Messages: 1
Registered: March 2005
Junior Member
Hi,
I have a situation where I need to recover a database
this database was actually residing on say server1 and due to some problem is no more active .... I have the backup of the datafiles control and redo log files intact on a tape ....now I need to create or recover the data from the backup files as listed above onto a different server say server2 which has a diff format of filesystem when i tried to do this i got the below error
ORA-01203: wrong incarnation of this file - wrong creation SCN
the data in the datafiles is critical and I have to recover it.

Please Help
Note server1 & 2 and Unix Sun solaris servers.

Thanks in advance.
deep.
Re: recovery of database [message #110326 is a reply to message #110325] Sat, 05 March 2005 21:53 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
ORA-01203 wrong incarnation of this file - wrong creation SCN

Cause: The creation SCN in the file header is not the same as the creation SCN in the control file. This is probably a copy of a file that was dropped.

Action: Restore a current copy of the datafile and do recovery as needed.
---

Try to mount the database, do a select from v$datafile to see what files are causing problems and restore them again from backup.

If you cannot solve the problem, dump the file headers and log a TAR with Oracle Support for assistance:

alter session set events 'immediate trace name file_hdrs level 10';


Best regards.

Frank
Previous Topic: pl/sql or unix script for oracle dba to see database status
Next Topic: Script that save all tablespaces to file
Goto Forum:
  


Current Time: Thu Mar 28 16:53:17 CDT 2024