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.

Wednesday, March 30, 2016

Configuring Database Backup Using RMAN in Oracle 11g

In This Session I'll be show to how configure a Database Backup using RMAN Utility

    




               1.   First connect with rman with target database

             Some basic steps for connect rman as below.
a.       Set environment variable
b.      Set oracle home
In where your oracle database is running
c.       After use rman command

What is ASM and it's Architecture in Oracle 11g r2

Overview

  • This features come since last oracle 10g.
  • The first foll ASM (Automatic Storage Management ) is one power-full tool that will help to oracle database file storage management into disk or tap drive. 
  • The ASM is really cool way to store database file, it's one of many feature of oracle that me-makes oracle database the premier relational database management system.
   

Description  

  • The ASM installed as a separate instance as part of gird infrastructure [ RAC / Standalone ] environment.
  • It don't including data-file, data-dictionary but it can read PASSWORD file.
  • If you want to connect with ASM instance then super user privilege is required [ SYSASM]  and it use PASSWORD file for authenticate.
  • If you want to access this functionality you must create ASM instance before your database start.