start oracle with not controlfile

[Former Member]

Hello,

I want to restore test database from production on oracle 10g, but I dont have the controlfile anymore.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1660944384 bytes

Fixed Size                  2004712 bytes

Variable Size             838863128 bytes

Database Buffers          805306368 bytes

Redo Buffers               14770176 bytes

ORA-00205: error in identifying control file, check alert log for more info

SQL> show parameter control_file;

NAME                                 TYPE

------------------------------------ ---------------------------------

VALUE

------------------------------

control_file_record_keep_time        integer

30

control_files                        string

D:\ORACLE\test_sid\ORIGLOGA\CNTRL\C

NTRLtest_sid.DBF, D:\ORACLE\QAS\ORI

GLOGB\CNTRL\CNTRLtest_sid.DBF, F:\O

RACLE\test_sid\SAPDATA1\CNTRL\CNTRL

test_sid.DBF

SQL>

In these location, I have the control file from production system.

Can you please suggest me something, pls

thx

Chris

[Former Member · Accepted solution]

Please suggest me something:

E:\Brtools>brrestore -u / -p inittest_sid.sap -m all -b aeqwzfox.svd -d disk -c

BR0401I BRRESTORE 7.20 (42)

BR0156E Illegal value 'aeqwzfox.svd' found for option '-b'

BR0406I End of file restore: reqxdxrx.log 2015-07-08 10.31.49

BR0280I BRRESTORE time stamp: 2015-07-08 10.31.49

BR0404I BRRESTORE terminated with errors

SQL> create controlfile reuse database test_sid resetlogs noarchivelog

  2  ;

create controlfile reuse database test_sid resetlogs noarchivelog

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

[Former Member · Accepted solution]

The solution was: