This content has been marked as final. Show 3 replies
The SYSTEM Tablespace datafile will always have the status 'SYSTEM' in the V$DATAFILE view. This is the case with all your databases -- including the Primary for this Standby.
The reason why SYSTEM is status 'SYSTEM' while others can be 'ONLINE' or 'OFFLINE' is that the SYSTEM tablespace can never be 'OFFLINE'. It cannot be manually taken Offline or brought Online.
So setting the status 'SYSTEM' is to say 'it cannot be offline or online, it is not treated the same as other datafiles'
Hemant K Chitale