The system tablespace stores the data dictionary information. When the database is in the open state, if the data file corresponding to the system tablespace fails to contain media
The system tablespace stores the data dictionary information. When the database is in the open state, if the data file corresponding to the system tablespace fails to contain media
Restore data files in the system tablespace
The system tablespace stores the data dictionary information. When the database is in the open state and the data file corresponding to the system tablespace fails, the database will automatically shut down when I/O operations are performed on the data file; when the database is closed, if the data file corresponding to the system tablespace fails, the database cannot be opened.
Restoring the system tablespace must be in the mount state.
Example 1 the data file in the system tablespace is deleted by mistake.
Back up the database.
Delete the data file corresponding to the system tablespace.
Start the database to the mount status.
Use restore datafile to dump data files, use the recover datafile command to apply archive logs, and finally use alter database open to open the database.Example 2: the disk where the system tablespace data file is located is faulty.
Back up a database (omitted)
Delete the data file corresponding to the system tablespace.
Start the database to the mount status.
Before restore database, run set newname to specify a new location for the data file.
After the restore database, Run switch datafile to change the location and name of the data file in the control file.
Then, archive logs by executing the recover database application.
Finally, execute alter database open to open the database.