Hello,
is it recommended to set a datafile online if it´s in the status "revover" and currently offline?
If added on our system to each Tablespaces PSAPSR3 and PSAPSR3701 a new datafile.
Since this event, I reveive in the backuplog the follwing warning:
BR0334E Status of database file F:ORACLEC12SAPDATA2SR3_24SR3.DATA24 is RECOVER
DB13:
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 23 files on disk 5) 157102080 KB (> 34372260 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3701, value: (max_extn of 11 files on disk 5) 64819200 KB (> 34372260 KB)
BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: F:ORACLEC12SAPDATA2SR3_24SR3.DATA24
BR0970W Database administration alert - level: ERROR, type: FILE_OFFLINE, object: F:ORACLEC12SAPDATA4SR3701_12SR3701.DATA12
I want to make the following workaround to get the two datafiles online again:
ALTER DATABASE DATAFILE SR3.DATA24 ONLINE;
ALTER DATABASE DATAFILE SR3701.DATA12 ONLINE;
Sincerely,
Martin