::|| RMAN COLD BACKUP AND RESTORE ||::

I'm going to show, how to execute cold backup using rman and restore the DB using cold backup. 

Note:

1. This exercise is done on 11.2.0.2 database with archivelog enabled.

2. FRA need to be configured. 

3. Controlfile auto backup must be enabled. 

Quick Question: How to ensure all data are restored ?

Answer: 

 Before executing the cold backup, let me create a dummy table and insert a marker transaction on it.  After restore, this marker transaction should be there. 

Let's start:-

Step 1: Create a dummy table and insert a marker transaction.

Step 2: Restart the db to mount mode.

Step 3: Take cold backup using RMAN. Ensure controlfile autobackup is enabled. 

With this step, the RMAN Cold Backup activity is completed. 

Quick Question:  whey there's an error message at the end of RMAN log ?

Now, I will start with restoring this cold backup and ensure it is working fine. Remember to verify the marker transaction at the end of restore. 

For this restoration exercise, I'm going to remove control, data and log files from my file system and then restore with the cold backup.

Step 4: Restart the database from mount mode to nomount mode.

Step 5: Start restore of controlfiles.

Step 6: Mount the Database.

Step 7: Restore the cold backup.

Step 8: Open the DB with resetlogs and confirm marker transaction is present. 

                                    

Feedbacks, updates, advises are welcome.

Ho