Performing Oracle Advanced Recovery - OCP: Oracle Database 12c Administrator Certified Professional - page 311

This would complete your disaster-recovery operation. If you needed to restore database
files to a different location, you would use the SET NEWNAME RMAN command as dis-
cussed in Chapter 6.
8. After you have completed the restore and recovery of the database data files, you
would open the database with the ALTER DATABASE OPEN RESETLOGS command.
If you are doing user-managed backup and recovery, the process is not all that different,
as you can see here:
1. Restore the OS.
2. Restore the Oracle software.
3. Configure Oracle networking.
4. Ensure that you have access to the database backups that you will be restoring.
5. Restore the database parameter file or spfile from your backup media.
6. Once the database parameter file or spfile is restored, you can mount the database with
the ALTER DATABASE MOUNT command.
7. Use a backup control file or the CREATE CONTROLFILE command to recreate the control
file of the database.
8. Once the database control file is restored, move the backups of the database data files
from the backup media.
If you are restoring the database data files to a different location, you will need to
rename them in the database control file.
9. Use the ALTER DATABASE RENAME FILE command for this operation.
10. Restore the needed archived redo logs from the backup media.
11. Use the RECOVER DATABASE command to complete the database recovery.
You will need to perform an incomplete recovery, since the online redo logs are not
available. See Chapter 3 for more on incomplete user-managed recoveries.
12. Once the RECOVER DATABASE command has completed its work, open the database with
the ALTER DATABASE OPEN RESETLOGS command.
Backup Best Practices for
Data Warehouses
Oracle has a set of best practices that offer a guide with respect to how you should perform
your database backups. RMAN is part of that solution. Another part of that solution offers
a set of best practices for how to best use RMAN to backup large databases, such as data
warehouses.