Oracle Database Discussions

Hi all,

DB version is 10.2.0.2 and Applications 12.0.6 on RHEL 4

While creating data file mistakenly we created with '?' as follows:

"/d01/CRP/db/apps_st/data/tx_?data53.dbf"

After that we tried to rename those data file using below steps but we are geting error message as follows:

1.SQL>ALTER TABLESPACE APPS_TS_TX_DATA OFFLINE NORMAL; at DB in OPEN stage

2.$mv /d01/CRP/db/apps_st/data/tx_?data53.dbf /d01/CRP/db/apps_st/data/tx_data53.dbf

3.ALTER TABLESPACE APPS_TS_TX_DATA RENAME DATAFILE '/d01/CRP/db/apps_st/data/tx_?data53.dbf' TO '/d01/CRP/db/apps_st/data/tx_data53.dbf';

*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/d01/CRP/db/apps_st/data/tx_?data53.dbf"


After that we tried to revert back by moving to original name usinf os commnds i.e tx_?data53.dbf and tried to open the database as follows but getting error message as follows:

SQL> startup mount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1264892 bytes
Variable Size 440402692 bytes
Database Buffers 620756992 bytes
Redo Buffers 11317248 bytes
Database mounted.

SQL> recover database;
Media recovery complete.

SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


Please help us t oresolve the Issue

Edited by: 912734 on Feb 15, 2012 2:43 AM