OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database Recovery

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

Database Recovery [message #63934]

Fri, 26 November 2004 09:34

Oz
Messages: 3
Registered: November 2004

Junior Member

I copied the datafiles from our HPUX 11 server to Windows 2000 and attempted to restore the database. When recreating the controlfile, I got the following errors:

CREATE CONTROLFILE REUSE SET DATABASE "prod" RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file 'F:oracleoradataprodDATA01.DBF'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: invalid file header

I'm using Oracle 8.1.7. I ran the above statment under internal credentials. The path mentioned above is correct. Below is the actual oracle statement I executed.

CREATE CONTROLFILE REUSE SET DATABASE "prod" RESETLOGS NOARCHIVELOG
LOGFILE
GROUP 1 ('F:oracleoradataprodREDO01.LOG') SIZE 5M,
GROUP 2 ('F:oracleoradataprodREDO02.LOG') SIZE 5M
DATAFILE 'C:TEMPCADLIVEALTARIS_DATA01.DBF',
'F:oracleoradataprodDATA02.DBF',
'F:oracleoradataprodDATA03.DBF',
'F:oracleoradataprodDATA04.DBF',
'F:oracleoradataprodINDEX01.DBF',
'F:oracleoradataprodINDEX02.DBF',
'F:oracleoradataprodINDEX03.DBF',
'F:oracleoradataprodINDEX04.DBF',
'F:oracleoradataprodCADLIVEROLLBACK01.DBF',
'F:oracleoradataprodCADLIVESYSTEM.DBF',
'F:oracleoradataprodCADLIVETEMP01.DBF',
'F:oracleoradataprodCADLIVETOOLS01.DBF',
'F:oracleoradataprodCADLIVEUSERS01.DBF'

Report message to a moderator

Re: Database Recovery [message #63935 is a reply to message #63934]

Fri, 26 November 2004 18:52

Suresh
Messages: 189
Registered: December 1998

Senior Member

There is a problem in 'F:oracleoradataprodDATA01.DBF',

Pls. check DATA01.DBF is exist in that location.
If so change your Oracle statment accordingly.

http://www.easywebtech.com/oracle/hotbakup.html

Report message to a moderator

Re: Database Recovery [message #63944 is a reply to message #63934]

Sun, 28 November 2004 19:55

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Hi,

You cant restore datafiles from different platform. For successfull restoration the platform must be same.

The error is absolutely correct ur windows machine is unable to read the file headers written by HP UX.

Try to restore ur datafile on HPUX machine only.

Best of Luck.
Daljit Singh.

Report message to a moderator