Hi Team,
I will be grateful if any help could be provided as I am in the middle of an activity. The activity is Moving Datafiles etc from +DATA05/icctst/datafile/ to onother mount point but i am getting the following error:
SQL> select distinct status from dba_tablespaces where tablespace_name='OGG_TS';
STATUS
---------
OFFLINE
SQL> alter tablespace OGG_TS online;
alter tablespace OGG_TS online
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 42 cannot be read at this time
ORA-01110: data file 42: '+DATA05/icctst/datafile/ogg_ts02.dbf'
ORA-06512: at line 1169
ORA-00376: file 42 cannot be read at this time
ORA-01110: data file 42: '+DATA05/icctst/datafile/ogg_ts02.dbf'
1) I am using oracle database 11.2.0.4 and Operating System is Linux 6 64 Bit. A 2 node RAC cluster
2) I am unable to put any other tablespace into offline state also due to the above error.
3) I am unable to drop the said tablespace also.
Any suggestions would be highly appreciated .
Regards
Azmat