Skip to Content
0
Former Member
Aug 19, 2015 at 04:40 AM

Not able to generate Control file

529 Views

Dear Team,

I have restore Full Online Production data in Quality Server.

After restoration , I have generate control file in Production ,

Now I have prepare this control file according to QAS Server.i.e.

sapqas:/sapdump>

-rw-r--r-- 1 root sys 21201 Aug 18 16:31 PRD_ora_26217.trc

-rw-r--r-- 1 root sys 7787 Aug 19 10:09 Control.sql

sapqas:/sapdump>chmod 777 Control.sql

sapqas:/sapdump>more Control.sql

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS ARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 1000

MAXINSTANCES 50

MAXLOGHISTORY 2336

LOGFILE

GROUP 1 (

'/oracle/QAS/origlogA/log_g11m1.dbf',

'/oracle/QAS/mirrlogA/log_g11m2.dbf'

'/oracle/QAS/sapdata5/sr3_120/sr3.data120',

'/oracle/QAS/sapdata5/sr3_121/sr3.data121',

'/oracle/QAS/sapdata5/sr3_122/sr3.data122'

CHARACTER SET UTF8

;

sapqas:/sapdump>

When I run below command for generate control file in QAS server ,Its give below error.

SQL> @/sapdump/Control.sql

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size 2190320 bytes

Variable Size 2348811280 bytes

Database Buffers 2315255808 bytes

Redo Buffers 10530816 bytes

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-00200: control file could not be created

ORA-00202: control file: '/oracle/QAS/origlogA/cntrl/cntrlQAS.dbf'

ORA-27040: file create error, unable to create file

HPUX-ia64 Error: 2: No such file or directory

Additional information: 1

SQL>