recovery of database [message #110325] |
Sat, 05 March 2005 20:17 |
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 |
Frank Naude
Messages: 4580 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
|
|
|