Pages

Search This Blog ...

Thursday, March 31, 2016

Create Image Copy Backup using RMAN in Oracle 11g R2

In This tutorial i am show you how can we create an Image file backup using RMAN.

There are many method to create a backup as below,
  1. IMAGE COPY Backup
  2. WHOLE DATABASE Backup
  3. INCREMENTAL Backup
  4. ARCHIVAL [ HOT ] Backup
  here i am show you IMAGE COPY Backup  
  • It is a bit for bit duplication of datafile or tablespace.
  • It is a extra copy of datafile, logfile, controlfile.
  • It just like operating system [ OS ] command like copy, cp, .. doing any file copy one place to another place.
  • In this you can not compress it.
  • In this type you can only take backup in disk you can't use SBT [ system backup tap ].
  • Using this backup you can faster restore in the database.
  • Lest start Image copy backup some steps as below.
  1. Connect with sys user with sysdba privilege in sqlplus
  2. After check FLASH Recovery area.
Flash Recovery Area.
      3. Then Exit from sqlplus and now connect with RMAN.
      4. Then check no of datafile and other information of current database.
Report Schema
       5. configure no of Chanel, auto-backup on and redundancy policy.
               i am here set it something value for it but you can set this value according to your                    requirement.
Set Configuration setting for Backup
       6. And start database backup.
Image Copy Backup
       7. You can see that you get it the image copy backup.
       8. You can take a backup of any particular datafile like,
Particular Schema Backup
       9. Now you can see the taken backup in FLASH recovery area.   



No comments:

Post a Comment

Thank you for give me feedback : )