Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Urgent: DBrefresh error 354 while creating control file, oracle9i, SAP R3

Hi experts,

I have created trace file in Source system and moved the same to target system and edited and then while executing the trace file to create control file the following eeror is coming

my trace file is like this. . .

..............................................

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "P47" RESETLOGS ARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 336

MAXINSTANCES 50

MAXLOGHISTORY 8168

...

...

..

'/oracle/P47/sapdata9/btabd_63/btabd.data63',

'/oracle/P47/sapdata9/stabi_27/stabi.data27',

'/oracle/P47/sapdata9/btabi_122/btabi.data122',

'/oracle/P47/sapdata9/stabd_28/stabd.data28',

'/oracle/P47/sapdata9/btabi_123/btabi.data123',

'/oracle/P47/sapdata9/btabd_64/btabd.data64',

'/oracle/P47/sapdata9/btabi_124/btabi.data124'

CHARACTER SET WE8DEC

......................................................

i run command like this:

SQL> @/oracle/P47/saptrace/usertrace/control.sql

ORACLE instance started.

Total System Global Area 1249618992 bytes

Fixed Size 732208 bytes

Variable Size 788529152 bytes

Database Buffers 459022446 bytes

Redo Buffers 1335296 bytes

<b>354</b>

when I press 'enter' again SQL prompt is comming

Please help

rgds

Former Member
Not what you were looking for? View more on this topic or Ask a question