What is the difference between recovery and restoring of the database.

Questions by ebymon

Showing Answers 1 - 14 of 14 Answers

Prabha Shrama

  • Apr 13th, 2006
 

The basic difference between recovery and restore is that in recovery the updated value from the database is removed while in resstore the value which is errased from database is restore.

  Was this answer useful?  Yes

pras

  • Apr 18th, 2006
 

Restoring a database is copying the physical files from a backup medium (disk or tape) to the appropriate file locations for database operationRecovery is process of updating database files restored from backup w/changes made to the database since backup, typically using redo log files.(Restored backup files + changes = Recovery)

Risham

  • Jun 21st, 2006
 

both the answers given seems to be contradictory

according to first one is we can get the changes made during restore

while according to the second one the changes are reflected during recovery.

please clear which one is write

Here is a scenario to understand Restore & Recovery

Sunday 10pm : Database is backed up. and is running fine. 

Monday 11am : Went down / crashed due to some reason.

To bring up the database, we have 2 options:

1. Simple Restore : copying files from backup taken sunday night and open the database. Here, we loose all the changes that are done since sunday night.

2. Restore and Recovery: Copying files from backup taken sunday night and applying all the archivelog and redo log files to bring up the database to the point of failure. Here you dont loose the changes done until monday 11 am.

Restore : copying files from the backup overwriting the existing database files

Recovery: applying the changes to the database till point of failure. these changes are recorded in online redolog and archivelog ( which are the backups of redolog) files.

Padmanathan

  • Aug 20th, 2006
 

Hi,

Restore means copying  already backed up files from tape to respective location.

recovery means rollforward the database by appying the redo logfiles

to bring the DB to latest stat.

Regards,

Padmanathan

  Was this answer useful?  Yes

shabirwani

  • Sep 17th, 2006
 

simply the restoration means copy the database object from the backup media to the destination where actually it is required. whereas recovery means to apply the database object copied earlier in order to bring the database to the consistent state. 

  Was this answer useful?  Yes

arun

  • Sep 19th, 2006
 

restore is replacing the corrupted or missing files. recovery is apply the redo logs

  Was this answer useful?  Yes

Chiranjeevi Manne

  • Mar 30th, 2007
 

1. Restoring the datafiles involves in copying the datafiles to their original locations from the last full backup.
2. Recovery involves in applying all the changes that we happen on the database after that full backup from which the datafiles are restored.

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Sep 18th, 2007
 

Restore means that you are copying either datafiles(or)controlfile from one database to another database. It is possible only through RMAN. While connecting through RMAN this stage require only at nomount.
Recover means that you are trying the recover database at mount stage.

  Was this answer useful?  Yes

fftoli

  • Dec 11th, 2008
 

The terms "recover" and "restore" both refer to retrieving files from a
backup device, such as a hard disk, external hard drive or other storage media.

However, recovering files typically refers to salvaging one or more files, while
a restore usually refers replacing a complete system or hard drive from a full
system backup.

  Was this answer useful?  Yes

bhendega

  • Feb 24th, 2009
 

Restore means
        Loss of physical files restore from latest backup aviable.
Recovery
        log apply from redo log files and archive log files.
 

  Was this answer useful?  Yes

erneha25s

  • Nov 20th, 2009
 

Restore:
1. Restore is process of Copying data from Tapes to Archive log destination.
2. It  has nothing to do with Backup.

Recovery:
Recovery is process when Archive log files are recovered or brought back from Archive log destination to Database.

  Was this answer useful?  Yes

krishna

  • Jul 20th, 2011
 

These two words are very interesting in the field of database.

Recovery :- Recovery Is nothing the process after the fail over the database . After fail over the database we are going to take the data backup through Backup Strategy , then the process is known as Recovery or Recovery of data.

Restoring:- Restoring means restore the data , which data we have as Backups. (suppose we have backup of database and we want to restore the data into database this process is known as Restoring or Restoring of data.

  Was this answer useful?  Yes

Mahi

  • Jul 26th, 2011
 

Restore - During media failure(means loss/corruption of datafiles and other files) just restore the last back up files.

Recover- Applying redologs to the database to roll it forward till the point of failure, typically using current redo log files and online redolog file.

  Was this answer useful?  Yes

Rock Boy

  • Jul 26th, 2011
 

Restoring a database is copying the physical files from a backup medium (disk or tape) to the appropriate file locations for database operation Recovery is process of updating database files restored from backup w/changes made to the database since backup, typically using redo log files.(Restored backup files + changes = Recovery)

  Was this answer useful?  Yes

Arjun Bansal

  • Oct 1st, 2011
 

Restore : A restore is, if you want, the opposite of a backup: the backed up files (that is: the backup) is copied back to their original location. Usually, a file is restored after a media failure. However, there are other situations where a file is restored, for example a point in time recovery.

Recovery : Since most probably, the files that were backed up (not the backup itself) have changed between a backup and a restore, the restored files must be recovered. During a recovery, all changes made to the restored file since the time of the backup are re-done. That's what the redo log and the archived redo logs are for. It is also possible to (at least incompletely) recover if the current redo log is lost or if the controlfiles are lost.

  Was this answer useful?  Yes

tridip ghosh

  • Oct 13th, 2011
 

Restoring a database is copying the physical files from a backup medium (disk or tape) to the appropriate file locations for database operation

Recovery is process of updating database files restored from backup w/changes made to the database since backup

  Was this answer useful?  Yes

tridip ghosh

  • Oct 13th, 2011
 

Restoring means to copying the data from a backup media(which is copied earlier in TApe or DIsk).

Recovery is process when Archive log files are recovered or brought back from Archive log destination to Database.

  Was this answer useful?  Yes

haroon

  • Jan 8th, 2012
 

Simply the restoration means copy the database object from the backup media to the destination where actually it is required. Whereas recovery means to apply the database object copied earlier in order to bring the database to the consistent state.

  Was this answer useful?  Yes

Rajesh Singh

  • Jan 15th, 2012
 

Restoring a database is copying the physical files from a backup medium (disk or tape) to the appropriate file locations for database operation.

Recovery is process of updating database files to roll it forward till the point of failure, the redo log files and archive log files are used in this process.

  Was this answer useful?  Yes

sandeep

  • Sep 12th, 2014
 

its very imporatnt q as part of dba

  Was this answer useful?  Yes

deepika

  • Nov 13th, 2014
 

Restore is the process in which physical files are copied from backup to required location.
Recovery is the process of making the copied datafiles up to date with the help of archive redo log files.

  Was this answer useful?  Yes

hari shankar

  • Oct 12th, 2015
 

Restore is the process in which RMAN is copying the backup file from backup location to proper database location.

Recover is the process in which applying the archive logs to and updating the data files.

  Was this answer useful?  Yes

Pravin Kumar

  • Feb 22nd, 2018
 

Restoring the database means copy the required datafiles from backup. Recovery means applying redolog or archived log to make the database up to given time, scn, lsn.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions