Saved Bookmarks
| 1. |
How Do You Recover From The Loss Of Data File If Database Is Running In Archive Log Mode? |
|
Answer» We can PERFORM this recovery in 2 ways. One is open database mode and another is database mount mode. After taking OFFLINE lost datafile, we can bring database open and after that RESTORE lost datafile from last backup. After restoration of datafile we can perform datafile level recovery for applying ARCHIVE logs and make it online. In database mount mode, we can restore datafile from backup and perform datafile recovery using "Recover datafile" command. We can perform this recovery in 2 ways. One is open database mode and another is database mount mode. After taking offline lost datafile, we can bring database open and after that restore lost datafile from last backup. After restoration of datafile we can perform datafile level recovery for applying archive logs and make it online. In database mount mode, we can restore datafile from backup and perform datafile recovery using "Recover datafile" command. |
|