ORA-1503 & ORA-01565

[Former Member]

Hi,

I am trying to build a new system from a successful cold backup(Oracle 8.1.7.3). I am following SAP Note:174243.

I have restored all the datafiles according to the trace.

Due to space constranits I have done some reorganizations and created sql file to create a new contol file keeping all these in mind.Both the SIDs are same.

Now when I am executing

Startup nomount

Successful.

@X:\control.sql(we have made)

Error::

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1091246108 bytes

Fixed Size 75804 bytes

Variable Size 430657536 bytes

Database Buffers 659456000 bytes

Redo Buffers 1056768 bytes

SQL> @X:\control.sql

CREATE CONTROLFILE REUSE DATABASE "ALP" NORESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file 'L:\ORACLE\ALP\SAPDATA1\TEMP_1\TEMP.DATA1'

ORA-27046: file size is not a multiple of logical block size

OSD-04012: file size mismatch (OS 629153340)

SQL> show parameter db_block

NAME TYPE VALUE

-

---

-

---

-

---

db_block_buffers integer 80500

db_block_checking boolean FALSE

db_block_checksum boolean FALSE

db_block_lru_latches integer 8

db_block_max_dirty_target integer 80500

*dbblock_size integer 8192*_

Then I adjusted db_blocksize =4096

Then

Error at the same stage looks like:

SQL> show parameter db_block

NAME TYPE VALUE

-

---

-

---

-

---

db_block_buffers integer 80500

db_block_checking boolean FALSE

db_block_checksum boolean FALSE

db_block_lru_latches integer 8

db_block_max_dirty_target integer 80500

*dbblock_size integer 4096*_

SQL> @X:\control.sql

CREATE CONTROLFILE REUSE DATABASE "ALP" NORESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01160: file is not a data file

ORA-01110: data file : 'L:\ORACLE\ALP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

So what is the way out right now.

Need ur help.

[Former Member]

Dear

Dont change block size !!

Keep it same as earlier and try to create once again

In control.sql file verify all files locations and name

And try to follow exact required note.

Vinod

[Former Member]

Sorry,

I have mention the note nummer wrongly.

I am following note:::Note 147243 - R3COPY under NT Oracle.

In STep 15 I am getting the error.

That one also I have tried without changing the parameter.then also no result.

Even I tried removing the temp file entry from the control.sql script thinking that we can add it later but then it gave the same kind of error for POLI.DATA1 file.

Regards,

Mofizur

[Former Member]

Hi,

The backup was corrupted.

We took another backup and everything went smoothly.

Regds,

Mofizur

[Former Member]

The SAP note you are following is incorrect.

Note 174243 - Overview rental units: empty currency fields

[Former Member]

Hi,

try with that command

CREATE CONTROLFILE REUSE SET DATABASE "ALP" NORESETLOGS ARCHIVELOG