| Error when re-creating CONTROL-file [message #51165] |
Sun, 05 May 2002 18:33  |
Ashwin Jog
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
Hi,
I had restored the data files of a database and re-created the control file on a new box.
The re-creation worked succesfully.
After a couple of weeks I started the restore of a fresh cut of data files, I followed the process as before, but this time around I recd a error file re-creating the control file the error is listed below.
SVRMGR> STARTUP NOMOUNT pfile='/apps/oracle/product/8.0.5/dbs/initWPTPROD.ora'
ORACLE instance started.
Total System Global Area 11094372 bytes
Fixed Size 47460 bytes
Variable Size 10088448 bytes
Database Buffers 819200 bytes
Redo Buffers 139264 bytes
SVRMGR> @create_ctl_wptprod.sql
CREATE CONTROLFILE REUSE DATABASE "WPTPROD" NORESETLOGS NOARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/db/NZ-REDO-01/WPTPROD/WPTPROD_REDO_01.DBF
ORA-27046: file size is not a multiple of logical block size
THe problem is that during the 1st restore the redo lod had a size of 10M each, while now it has been changed to 30M.
I don't know how to resolve this issue, I need to bring the database up soon, can anybody help .. HELP...
Regards
Ashwin
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
