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.

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

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.

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.