Course - CoreDBA-Backup/Recovery

 RMAN Backup Script for Non-RAC Database

Sample Shell Scripts for Scheduling RMAN Backup 

1. Introduction
2. User Managed Backup Terminology 
3. RMAN Managed Backup Terminology
4. Different Type of backup
5. Type of Recovery
6. RMAN: RESTORE Concept
7. RMAN with a Recovery Catalog
8. How to Configure RMAN
9. Complete Steps for Using RMAN through Catalog
10. Recovery Case Study (Without using RMAN)

• Recovery from missing or corrupted redo log group

         Case 1: A multiplexed copy of the missing log is available.

         Case 2: Only A redo log file backup copy available (but Redo Log is not current and archived) 

         Case 3: If missing Redo log is CURRENT

         Case 4: All redo log file or any one redo log file missing and we have no backup copy  of redo log file or no multiplexing redo log file.

         Case 5: Redo log is not CURRENT and not archived, means missing file is in ACTIVE status.

• Recovery form missing or corrupted control file

          Case 1: A multiple copy of the control file is available

          Case 2: If All Control files loss or corrupted and you have no backup

          Case 3: If All Control file loss or corrupted and you have control file backup by using alter database backup control file to trace command. 

• Recovery form missing or corrupted Data File

          Case 1: Recover from corrupted or missing data file

          This scenario deal with a situation where data file has gone missing or corrupted at the time of open  the database. 
          Case 2: Recover from corrupted or missing data file (When database is Open)

         This scenario deal with a situation where data file has gone missing or corrupted and databases already open.

         Case 3: Lost newly created data file and no backup (if instance terminated or abort)

         Case 4: Lost newly created data file and no backup (if instance is remain open and read Write mode)

         Case 5: If all database lost (Disaster) and we have no backup of newly created data file.

• Disaster Recovery

 

11.    Recover Case Study (With using RMAN) 

• Data File Recovery

          Case 1: Recover from corrupted or missing data file

           This scenario deal with a situation where data file has gone missing or corrupted at the time of open the database. 

          Case 2: Recover from corrupted or missing data file.

          This scenario deal with a situation where data file has gone missing or corrupted and databases already open.

          Case 3: Lost newly created data file and no backup (if instance terminated or abort)

          Case 4: Lost newly created data file and no backup (if instance is remain open and read Write mode)
             Case 5:  If all database lost and we have no backup of newly created data file.

• Control File recovery

         Case 1: A multiple copy of the controlfile is available

         Case 2: All Control file lost 

• Redo Log File Recovery 

             Case 1: A multiplexed copy of the missing log is available 
             Case 2: All members of a log group lost.

 

• Disaster Recovery

13.    Point-in Time recovery

14.    Time Based, Change Based or SCN Based Recovery
15.    Recover UNDO Data File                                                                                                              
         Case 1: If undo data file lost after cleanly shutdown 
         Case 2: The Database was not cleanly shut down 

         Case 3: The Database is UP and Read Write mode 
         Case 4: Handling Errors dropping UNDO Segments. 

16.    Restoring/Recovering the Database to a same host with different location 
17.    Restore /Recover the Database to a new host with a same directory structure
18.    Restore/Recover database to a new host with different directory structure
19.    Checking the Progress of RMAN Backup Recovery
20.    Useful Query
21.    Recovery from Block Corruption
22.    Tablespace Recovery