In this scenario we assume that we have lost all the database files (Data Files & Redolog Files & Control Files), the database is running in Archivelog Mode.

Of course you can find out about any problem with the database by the Alert.log file or the file.trc files or by the messages sent by the Oracle Server.

In this scenario, we need the following steps:-

1- Restore all database files from the last backup, which is making a copy of the database files from the last backup via the operating system.

D:\>COPY D:\BACKUP\*.* D:\oradata\orcl\

Or

cp /backup/*  /oradata/orcl/

This is how we have completed the Full Restore process.

Make sure that all database files have been restored from the last backup.

2- Run the database in Mount mode.

STARTUP MOUNT

3- Perform a database recovery, but since we lost the Current online Redolog File, we will perform an Incomplete recovery as we mentioned previously, because the Complete Recovery requires the Current online Redolog File.

ALTER DATABASE RECOVER AUTOMATIC USING BACKUP CONTROLFILE UNTIL CANCEL;

4- Open the database in RESETLOGS mode.

ALTER DATABASE OPEN RESETLOGS;

Thus we have completed the recovery process, but you must now create a new Backup because all the backup files that were placed before the database was opened in RESETLOGS mode are no longer useful as we mentioned earlier.