Hi All,
I found this strange issue in SAP R3 db when an SAP guy asked me one solution on a test database when one of thier drive was full.
Sequence of steps:
1. We noticed that one drive say 'D:\' is full.
2. I randomly picked one tablespace PSAPSR3 and made it offline and copied one datafile say '.DATA3' which is part of PSAPSR3 tablespace to other drive say 'G:\'.
3. Issued command alter tablespace PSAPSR3 rename datafile '<old_path>' to '<new_path>'.
4. when queried the location of moved datafile, it promptly shows the new path.
5. when tried to bring the tablespace PSAPSR3 back online, it was throwing error as "ORA-01578: ORACLE data block corrupted (file # 14, block # 105719)"
Though I didn't touched the datafile 14 at all, I further saw the alert log and noticed that the data block was corrupted some six months back and since I had brought the tablespace offline which contains the data file 14, now not able to bring back the tablespace online.
We do not have any kind of database backup, I know its weird to hear the db without backup, since its a test db no one bothered to take the backup.
I tried bring the corrupted datafile offline and bring tablespace online, it didn't worked.
Please advise how to fix this kind of issue.
Thanks
Kishore