Oracle Database Discussions

Hi all,

I wanted to change the db name so i created new controlfile with trace and set it as.I have created controlfile successfully,my db opened successfully but when i shut it down and again tried it to open i saw below error message



CREATE CONTROLFILE SET DATABASE "db2" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\REDO01.LOG' SIZE 50M,
GROUP 2 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\REDO02.LOG' SIZE 50M,
GROUP 3 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\REDO03.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\SYSTEM01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\UNDOTBS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\SYSAUX01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\USERS01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB2.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB21.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB211.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB212.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB213.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB214.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB215.DBF'
CHARACTER SET WE8MSWIN1252;

ALTER DATABASE OPEN RESETLOGS;




SQL> @e:\creatdbdb2.sql;

Control file created.


Database altered.

SQL> select file_name from dba_data_files;

FILE_NAME
---------------------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB215.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB214.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB213.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB212.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB211.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB21.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\DB2.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\USERS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\SYSAUX01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\UNDOTBS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\db2\SYSTEM01.DBF

11 rows selected.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\DB_3\DATABASE\LOG2db2.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.