Datafile deleted how to recover database :
Scenario : By any chance datafile deleted and backup has not been taken any backup for Database , now need to recover Database
Solution :
For the solution we need to know datafile name which is missing and we can come to know from control file
So we have to follow below steps to recover database.
1.Create a new datafile as named in control file.
2.Restore Database backup or if there is no backup taken and archive log mode on we can recover from archive log.
Scenario : By any chance datafile deleted and backup has not been taken any backup for Database , now need to recover Database
Solution :
For the solution we need to know datafile name which is missing and we can come to know from control file
So we have to follow below steps to recover database.
1.Create a new datafile as named in control file.
2.Restore Database backup or if there is no backup taken and archive log mode on we can recover from archive log.
No comments:
Post a Comment