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.

pras

 Profile Answers by 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

skumarpenugonda

 Profile Answers by skumarpenugonda 

• Jul 7th, 2006

 

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

shabirwani

 Profile 

• 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. 

arun

• Sep 19th, 2006

 

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

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.

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.

fftoli

 Profile Answers by 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.

bhendega

 Profile Answers by 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.
 

erneha25s

 Profile Answers by 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.

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.

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.

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)

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.

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

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.

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.

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.

sandeep

• Sep 12th, 2014

 

its very imporatnt q as part of dba

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.

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.

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.