Oracle Error :: ORA-01147
SYSTEM tablespace file string is offline
Cause
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.
Action
Bring the file online.
Comments (Add Comment)
28/09/2009 09:35:54 by akeel101@hotmail.com
II.1. One afternoon a disk crashed, losing the SYSTEM tablespace residing on the disk. As this happened at the peak processing time, Smith had to keep the down time to a minimum and open the database as soon as possible. He wanted to start the database first and then restore the datafile that was lost, so he took the SYSTEM data file offline. When he tried to open the database he got the following error:
ORA-01147 : SYSTEM tablespace file 1 is offline
Write down the steps you would perform to recover your database
26/01/2010 07:58:31 by Mike
The problem is; 'Smith' isn't a dba and shouldn't be allowed anywhere near an Oracle database under any circumstances, especially not for money.