Corrupted/lost data file of system tablespace can be recovered using RMAN provided that there is a backup.
Here below is an example of RMAN job command script for restoring system tablespace.
RMAN> RUN { RESTORE TABLESPACE SYSTEM; RECOVER TABLESPACE SYSTEM; ALTER DATABASE OPEN; } RUN { RESTORE TABLESPACE NEWTBS; RECOVER TABLESPACE NEWTBS; ALTER DATABASE OPEN; }
meda Changed status to publish 05/03/2022