This article is about recovery of corrupted/damaged/lost/canceled NONSYSTEM datafile switching to an image copy when database in ARCHIVELOG mode.

We must have an image copy of my datafiles:

The following command is use to take copy.

Now let’s simulate a lost datafile of a NONSYSTEM tablespace

The RMAN report command is no more able to identify the size of the lost datafile

It’s time to restore and recover our datafile. First put it offline

Now the RMAN report command is able again to obtain information about your datafile

Source

About The Author

Leave a Reply