How to fix the Oracle error ORA-01147: SYSTEM tablespace file string is offline?

In this post, you’ll learn more about the Oracle ErrorORA-01147: SYSTEM tablespace file string is offline with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01147: SYSTEM tablespace file string is offline

Reason for the Error ORA-01147: SYSTEM tablespace file string is offline

A file belonging to the SYSTEM tablespace has been marked offline by the DBA. The database cannot be started until all SYSTEM tablespace files are online and openable.

How to fix the Error ORA-01147: SYSTEM tablespace file string is offline ?

You can fix this error in Oracle by following the below steps

Bring the file online.