Recovery
I would like to know your view to handle a scenario like one user tablespace went offline due to hardware fault at 1 o'clock and we found that one memeber of redogroup is having those information from 12:30 pm which unarchived and we realise that this unarchied file is corrupted now how to recover this tablespace using rman and without rman.Please answer the question so that I can know the fact.
Also let me know the script or any method by which we can know which information is kept in which redo online file.Can we see those information?