Refresh error in phase @CONTROL.SQL

[Former Member]

Hello during system refresh procedure in received the following errors mesages

SQL> @CONTROL.SQL

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 616562688 bytes

Fixed Size 2046032 bytes

Variable Size 318769072 bytes

Database Buffers 293601280 bytes

Redo Buffers 2146304 bytes

CREATE CONTROLFILE REUSE SET DATABASE "PJE"

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-00200: control file could not be created

ORA-00202: control file: '/oracle/PJE/sapdata1/system_1/cntrl/cntrlPJE.dbf'

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

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

ALTER DATABASE OPEN RESETLOGS

*

ERROR at line 1:

ORA-01507: database not mounted

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/PJE/sapdata1/system/temp_1/temp.data1'

*

ERROR at line 1:

ORA-01109: database not open

Thanks for your support

Eric

[Former Member]

Hello

Solved by fixing in control file path.

Regards

[Former Member]

Dear Eric,

Please go through below points :

1) Goto sqlplus and check the locations of control files using below commands :

sql> show parameter control_files or

sql> select * from v$controlfile;

Please make sure cntrl directory exists in all these locations.

2) Adapt your control.sql file as suggested by Jiggi

3) Remove "alter database open resetlogs" line from control.sql. This can make your database inconsistent and database

recovery would not be possible.

Regards,

Ankit

[Former Member]

Dear Eric,

Please make sure that your control file looks like below.

************************************************************************

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "WBD" RESETLOGS NOARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 2336

LOGFILE

GROUP 1 (

'F:\ORACLE\WBD\ORIGLOGA\LOG_G11M1.DBF',

'C:\ORACLE\WBD\MIRRLOGA\LOG_G11M2.DBF'

) SIZE 50M,

GROUP 2 (

'F:\ORACLE\WBD\ORIGLOGB\LOG_G12M1.DBF',

'C:\ORACLE\WBD\MIRRLOGB\LOG_G12M2.DBF'

) SIZE 50M,

GROUP 3 (

'F:\ORACLE\WBD\ORIGLOGA\LOG_G13M1.DBF',

'C:\ORACLE\WBD\MIRRLOGA\LOG_G13M2.DBF'

) SIZE 50M,

GROUP 4 (

'F:\ORACLE\WBD\ORIGLOGB\LOG_G14M1.DBF',

'C:\ORACLE\WBD\MIRRLOGB\LOG_G14M2.DBF'

) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

'H:\ORACLE\WBD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

'H:\ORACLE\WBD\SAPDATA4\UNDO_1\UNDO.DATA1',

'H:\ORACLE\WBD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

'H:\ORACLE\WBD\SAPDATA1\SR3_1\SR3.DATA1',

'H:\ORACLE\WBD\SAPDATA2\SR3_2\SR3.DATA2',

'H:\ORACLE\WBD\SAPDATA3\SR3_3\SR3.DATA3',

'H:\ORACLE\WBD\SAPDATA4\SR3_4\SR3.DATA4',

'H:\ORACLE\WBD\SAPDATA1\SR3700_1\SR3700.DATA1',

'H:\ORACLE\WBD\SAPDATA1\SR3700_2\SR3700.DATA2',

'H:\ORACLE\WBD\SAPDATA2\SR3700_3\SR3700.DATA3',

'H:\ORACLE\WBD\SAPDATA2\SR3700_4\SR3700.DATA4',

'H:\ORACLE\WBD\SAPDATA3\SR3700_5\SR3700.DATA5',

'H:\ORACLE\WBD\SAPDATA4\SR3700_6\SR3700.DATA6',

'H:\ORACLE\WBD\SAPDATA1\SR3USR_1\SR3USR.DATA1',

'H:\ORACLE\WBD\SAPDATA4\UNDO_2\UNDO.DATA2',

'H:\ORACLE\WBD\SAPDATA5\SYSTEM_2\SYSTEM.DATA2'

CHARACTER SET WE8DEC

;

************************************************************************

use following commands to crete control files. place thsi control file on desktop and run folowing commands.

C:\Documents and Settings\wbdadm\Desktop>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Mar 16 21:38:46 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> @controlfile_wbd.sql

ORACLE instance started.

Total System Global Area 557842432 bytes

Fixed Size 1290604 bytes

Variable Size 289410708 bytes

Database Buffers 264241152 bytes

Redo Buffers 2899968 bytes

Control file created.

Regards

Jiggi

[anindya_bose]

Hi Eric

>CREATE CONTROLFILE REUSE SET DATABASE "PJE"

I think the statement will be CREATE CONTROLFILE SET DATABASE "PJE"

Why REUSE and SET both?

Also check the following:

Remove the line 'alter database open'

Remove the line 'RECOVER DATABASE USING BACKUP CONTROLFILE'

Save the control.sql

by the way, what is your source SID and what is target SID?

Did you rename the directory file from Source SID to Target SID?

Regards

Anindya

[Former Member]

Hi,

ORA-00202: control file: '/oracle/PJE/sapdata1/system_1/cntrl/cntrlPJE.dbf'
ORA-27040: file create error, unable to create file
HPUX-ia64 Error: 2: No such file or directory

You might deleted all subdirectories under /oracle/PJE/sapdata<n> and control.sql trying to find "cntrl" directory which is not created or restored from backup.

Check all 3 locations of controlfiles and make sure that those destinations are exists. If not, create those directories "cntrl" asp per the controlfile statement as ora<sid> user.

Then try again...

Regards.

Rajesh Narkhede

[stefan_koehler]

Hello Eric,

> ORA-01503: CREATE CONTROLFILE failed

>ORA-00200: control file could not be created

>ORA-00202: control file: '/oracle/PJE/sapdata1/system_1/cntrl/cntrlPJE.dbf'

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

It seems like the folder "/oracle/PJE/sapdata1/system_1/cntrl/" does not exist or the permissions are not correct.

Please check this - all the other errors are subsequent faults.

Regards

Stefan

[markus_doehr2]

> ERROR at line 1:

> ORA-01503: CREATE CONTROLFILE failed

> ORA-00200: control file could not be created

> ORA-00202: control file: '/oracle/PJE/sapdata1/system_1/cntrl/cntrlPJE.dbf'

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

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

Did you modify/adapt the SQL script so it reflects your actual filesystem configuration?

Did you create all the directories?

Markus