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.
1 2 3 4 5 6 7 8 9 10 11 12 13 | 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