Oracle SQL Forum
May I know that What we can do if data file is corrupted and perform point in time recovery.
Kindly share your valuable views here.
Thanks in advance.
Your data file corrupted but not log file so if your recovery model is full then take log back up with notrancate then restore the database from old full, diff, corresponding all log backups include latest.
As you are data base already corrupted after taking normal log backup from log file your committed transaction will move to data file but here as file got corrupted between take log backup with no trancate option to keep your last transaction intact until you restore all (point in time Recovery ultimate).
Sign up for STechies
Ask Question From Our Experts