-
Executing the following sql:
CREATE CONTROLFILE REUSE DATABASE "ORACLE" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 600
MAXINSTANCES 10
MAXLOGHISTORY 1000
LOGFILE
'/u01/app/oracle/oradata/oracle/redo01.log',
'/u01/app/oracle/oradata/oracle/redo02.log',
'/u01/app/oracle/oradata/oracle/redo03.log'
DATAFILE
'/u01/app/oracle/oradata/oracle/tools01.dbf',
'/u01/app/oracle/oradata/oracle/drsys01.dbf',
'/u01/app/oracle/oradata/oracle/users01.dbf',
'/u01/app/oracle/oradata/oracle/indx01.dbf',
'/u01/app/oracle/oradata/oracle/rbs01.dbf',
'/u01/app/oracle/oradata/oracle/temp01.dbf',
'/u01/app/oracle/oradata/oracle/system01.dbf'
;
Results in the following error:
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/u01/app/oracle/oradata/oracle/drsys01.dbf'
Does this mean that the dbf is corrupted? ie: Is the database toasted????
Thanks
-
Was it a raw disk backup, on such cases you have to skip the raw device's header bytes. You might want to use dd. It also could be a reason that your DB_BLOCK had been set low. Remember that your DB_BLOCK should be the same as the imported DB.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Sam,
Actually, there are no backups involved. Yestedray Network admins' had to shut down the server, I was not here when they did, but when I got back oracle server was down. They told me they had not been able to do a normal shutdown nor a startup. The error by then was the following:
SVRMGR> startup
ORACLE instance started.
Total System Global Area 72708256 bytes
Fixed Size 73888 bytes
Variable Size 55685120 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
ORA-00201: controlfile version incompatible with ORACLE version
ORA-00202: controlfile: '/u01/app/oracle/oradata/oracle/control01.ctl'
Hence I decided to drop the control files and recreate them using the sql script posted on my first thread, but now I'm getting the datafile error. Fortunately is just a test database, and therefore I have no backup at all. I was just trying to see trough it but not the easy way.... So if you happen to have any advice please drop it here !
Thanks and Regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|