| Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-01 |
|
|
View PDF |
| Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-01 |
|
|
View PDF |
To restore a file is to replace it with a backup file. Typically, you restore a file when a media failure or user error has damaged or deleted the original file. The following files are candidates for restore operations:
Datafiles and control files
Archived redo logs
Server parameter file
In each case, the loss of a primary file and the restore of a backup has the following implications for media recovery.
| If you lose . . . | Then . . . |
|---|---|
| One or more datafiles | You must restore them from a backup and perform media recovery. Recovery is required whenever the checkpoint SCN in the datafile header does not match the checkpoint SCN for the datafile that is recorded in the control file. |
| All copies of the current control file | You must restore a backup control file and then open the database with the RESETLOGS option.
If you do not have a backup, then you can attempt to re-create the control file. If possible, use the script included in the |
| One copy of a multiplexed control file | Copy one of the intact multiplexed control files into the location of the damaged or missing control file and open the database. If you cannot copy the control file to its original location, then edit the initialization parameter file to reflect a new location or remove the damaged control file. Then, open the database. |
| One or more archived logs required for media recovery | You must restore backups of these archived logs for recovery to proceed. You can restore either to the default or nondefault location. If you do not have backups, then you must performing incomplete recovery up to an SCN before the first missing redo log and open RESETLOGS. |
| The server parameter file | If you have a backup of the server parameter file, then restore it. Alternatively, if you have a backup of the client-side initialization parameter file, then you can restore a backup of this file, start the instance, and then re-create the server parameter file. |
|
Note: Restore and recovery of Oracle-managed files is no different from restore and recovery of user-named files. |
