Hi Experts,
I have On issue here..Someone has created to datafiles with name
1. F:\oracle\sid\sapdata1\system_1\.Ora
2. F:\oracle\sid\system_1\sapdata1\Btabi.data1
for the tablespace PSAPBTABI ..long ago..now the table space is almost full ..i tried to add new datafile thru SAPDBA...but it is not creating new datafile for table space PSAPBTABI, it shows that this tablespace is not following SAP cinventional datafile name...as one datafile has the name simply, <b>.ORA</b> and more over these two datafiles are created in the directiory SYSTEM_1 instead of F:\oracle\sid\sapdata4\BTABI\...
So the thing goes like this..i tried to change the name and path of these two datafiles as below;
svrmgrl>Alter tablespace psapbtabi offline;
Moved the two datafiles to new location and rename it as .ORA ->BTABI.DATA5
and other to BTABI.DAT
svrmgrl>alter tablespace psapbtabi rename datafile '' to '';
svrmgrl>Alter tablespace psapbtabi online;
then it shows that these two fileneeds media recovery..
My question is whether i shud create a crontrolfile by
svrmgrl>alter databse backup controlfile to trace;
then make appropriate changes and then do recover the database ..or is there any other option..Please Suggest me some solution....
Enviroment : 4.6c,ora817,winnt
Kind regards
Umesh K