OraFAQ Forum: Backup & Recovery » recovery of database

Home » RDBMS Server » Backup & Recovery » recovery of database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: recovery of database [message #110326 is a reply to message #110325]

Sat, 05 March 2005 21:53

Frank Naude
Messages: 4595
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:

Code: [Select all] [Show/ hide]

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

Best regards.

Frank

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 05 02:54:05 CST 2025