Please find below the RMAN basic operations and commands along with Hands-on dummy data :
Q:> What is RMAN?
Sol : RMAN (Recovery Manager) is a backup and recovery manager supplied for Oracle databases (from version 8) created by the Oracle Corporation. It provides database backup, restore, and recovery capabilities addressing high availability and disaster recovery concerns.
Q:> What are the advantages of using RMAN over User Managed Backups and Recoveries ?
Sol : 1 > In User Managed Backup and recovery we take the full backup of a Datafile always even it is 30% full and 70% empty. In RMAN we have an option to backup only the USED blocks of a datafile(i.e.30%).In this process the backup file will me smaller in size and thus saves disk space and performs faster unlike copying datafiles manually using OS commands in user Managed backups.
2> In RMAN we can take Incremental backups which will be explained in this section.Incremental backups are faster and consumes less disk space compared to full backup strategies as here we are only taking backup of the changed/modified blocks since Level 0 Incremental Full backup. We can use BCT which will be explained here to boost up the performance of Incremental backups.
3> In RMAN backups, the storage location is stored in Control File or Recovery Catalog in a different Database. Hence ,we don't need to remember the storage location path of the backup pieces.
4> In RMAN we have a option f compression, in which backups will be compressed into small size backup sets thus it will save disk space.
Types of Backups RMAN can take :
RMAN : Starting with basic backup and recovery Commands
RMAN : Full Database backup without Archivelog
RMAN : Full database backup plus archivelog
RMAN : Take Backup of Current Controlfile
RMAN : Take backup of SPFile
RMAN : Take backup of Tablespace
RMAN : Report schema
RMAN : Taking Backup of a Single Datafile/ Mutliple Datafiles
RMAN : Deleting Backups
RMAN : Obsolete backups
Q:> What is RMAN?
Sol : RMAN (Recovery Manager) is a backup and recovery manager supplied for Oracle databases (from version 8) created by the Oracle Corporation. It provides database backup, restore, and recovery capabilities addressing high availability and disaster recovery concerns.
Q:> What are the advantages of using RMAN over User Managed Backups and Recoveries ?
Sol : 1 > In User Managed Backup and recovery we take the full backup of a Datafile always even it is 30% full and 70% empty. In RMAN we have an option to backup only the USED blocks of a datafile(i.e.30%).In this process the backup file will me smaller in size and thus saves disk space and performs faster unlike copying datafiles manually using OS commands in user Managed backups.
2> In RMAN we can take Incremental backups which will be explained in this section.Incremental backups are faster and consumes less disk space compared to full backup strategies as here we are only taking backup of the changed/modified blocks since Level 0 Incremental Full backup. We can use BCT which will be explained here to boost up the performance of Incremental backups.
3> In RMAN backups, the storage location is stored in Control File or Recovery Catalog in a different Database. Hence ,we don't need to remember the storage location path of the backup pieces.
4> In RMAN we have a option f compression, in which backups will be compressed into small size backup sets thus it will save disk space.
Types of Backups RMAN can take :
- Full : Hot Backup and Cold Backup
- Incremental : Cumulative and Differential
Below is the hands-on note performed on live server you can practice :
Click on the below links to access the information.
No comments:
Post a Comment