Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 13, 2007 at 07:29 AM

    I can´t see any error.... I just see "354"...

    Do you see anything in your Oracle alert log?

    --

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Good to hear! 😊

      I would though path the target system up to 9.2.0.7. If you copy the database from that version, the internal Oracle dictionary has a different version than the software on the filesystem which may lead to all sorts of strange errors.

      --

      Markus