Not able to generate Control file

[Former Member]

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>

[former_member182657 · Accepted solution]

Hi Pooja,

HPUX-ia64 Error: 2: No such file or directory
Additional information: 1

First shutdown the database with immediate option & check for the following directories with dba permissions on the system (e.g),if not exists,you need to create

/oracle/origlogA/cntrl

/oracle/origlogB/cntrl

/oracle/sapdata1/cntrl

For the exact control file locations you could refer alert_<SID>.log file .

After creation of the directories try to re-execute the control.sql file to create control file.

Regards,

[Former Member · Accepted solution]

hi Pooja,

Do perform the activity as mentioned by Gaurav, also for the location of the control files do check your /oracle/QAS/<DBVersion>/dbs directory for initQAS.ora parameter .control_files.

And search for the control file locations. You may need to create the directory structure as Oracle while mounting the DB or while creatin control files does not create file structure.

Also do rename the old existing control files as they may give error while database mounting.

Let us know if you face any further issues.

Regards,

Ram

[Former Member]

SELECT NAME FROM V$CONTROLFILE; --- will output the name and path of control file.

Regards,
Shanthosh