Skip to Content
0
Former Member
Apr 19, 2010 at 09:14 AM

Oracle Datafile in Revover Status and offline, set online?

429 Views

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