Hi Oracle Guru,
I want to restore OLD RMAN backup of prod database in test environment , But I have control file backup in trace format only I didn't find control file rman backup.
So I was trying to create control file from trace command. But its failing every time. I tried to google also but didn't find solution. So posting for help.
DB Version : 11.2.0.3
Window OS Version : Window Server 2008
Steps i followed.
1. SQL> startup nomount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 616563632 bytes
Database Buffers 444596224 bytes
Redo Buffers 5517312 bytes
SQL>
2.
SQL> CREATE CONTROLFILE SET DATABASE "UCAS" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 2422
7 LOGFILE
8 GROUP 4 (
9 'E:\Oracle\UCAS_TEST\REDO4A.LOG',
10 'E:\Oracle\UCAS_TEST\REDO4B.LOG'
11 ) SIZE 500M BLOCKSIZE 512,
12 GROUP 5 (
13 'E:\Oracle\UCAS_TEST\REDO5A.LOG',
14 'E:\Oracle\UCAS_TEST\REDO5B.LOG'
15 ) SIZE 500M BLOCKSIZE 512,
16 GROUP 6 (
17 'E:\Oracle\UCAS_TEST\REDO6A.LOG',
18 'E:\Oracle\UCAS_TEST\REDO6B.LOG'
19 ) SIZE 500M BLOCKSIZE 512,
20 GROUP 7 (
21 'E:\Oracle\UCAS_TEST\REDO7A.LOG',
22 'E:\Oracle\UCAS_TEST\REDO7B.LOG'
23 ) SIZE 500M BLOCKSIZE 512
24 -- STANDBY LOGFILE
25 DATAFILE
26 'E:\Oracle\UCAS_TEST\SYSTEM01.DBF',
27 'E:\Oracle\UCAS_TEST\SYSAUX01.DBF',
28 'E:\Oracle\UCAS_TEST\UNDOTBS01.DBF',
29 'E:\Oracle\UCAS_TEST\USERS01.DBF',
30 'E:\Oracle\UCAS_TEST\UCAS_01.DBF',
31 'E:\Oracle\UCAS_TEST\UCAS_02.DBF',
32 'E:\Oracle\UCAS_TEST\UCAS_DATA_01.DBF',
33 'E:\Oracle\UCAS_TEST\UCAS_DATA_02.DBF',
34 'E:\Oracle\UCAS_TEST\UCAS_INDEX_01.DBF',
35 'E:\Oracle\UCAS_TEST\UCAS_INDEX_02.DBF',
36 'E:\Oracle\UCAS_TEST\GGS_DATA_01.DBF',
37 'E:\Oracle\UCAS_TEST\TELEX_01.DBF',
38 'E:\Oracle\UCAS_TEST\UCAS_NEW01.DBF',
39 'E:\Oracle\UCAS_TEST\UCAS_NEW02.DBF',
40 'E:\Oracle\UCAS_TEST\UCAS_DATA02.DBF'
41 CHARACTER SET AL32UTF8
42 ;
CREATE CONTROLFILE SET DATABASE "UCAS" RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file 'E:\Oracle\UCAS_TEST\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
I am not getting why Oracle is trying to search for system file while creating controlfile.
Please if anybody has faced this issue and resolved it please help me.
Best Regards
Jamsher Khan