RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Can any 1 pls explain the complete procedure of RMAN in detail....
    Thanx

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hello

    look here first
    http://www.oracle.com/oramag/oracle/...ml?o20rec.html

    regards
    hrishy

  3. #3
    Join Date
    Jun 2001
    Posts
    316
    Thanx...
    But a bit confusion....

    I had copied step by step procedure from a posting in here...
    Now a few doubts in this posting..

    It says:

    (I ve just used //--// at places where I feel really confused!)



    1.Create a tablespace for recovery
    catalog

    create tablespace RMAN_DATA
    datafile 'disk1\data\rmandata01.dbf'
    size 50M;

    2.Create a user for administering
    recovery cat.
    create user RMAN identified by RMAN
    default tablespace RMAN_DATA
    temporary tablespace TEMP
    quota unlimited on RMAN_DATA;

    3.Grant the RMAN user
    SYSDBA,SYSOPER roles
    grant sysdba,sysoper to rman;

    4.Grant connect,resource roles to RMAN
    grant connect,resource to RMAN;

    5.Grant recovery_catalog_owner to RMAN
    grant recovery_catalog_owner to RMAN;
    //--//
    6.Run catrman.sql script as user RMAN
    Where do i find this script!!
    //--//

    After completing the above steps run the following command to start RMAN
    //--//
    RMAN target="sys/sys@bscs521"
    rcvcat="rman/rman@test521"
    Does this remain same or do I have to use diff eg: rman@test521 does it reamin so always?

    //--//
    U will be getting the RMAN prompt if u have configured correctly.The next step is to register ur target database with RMAN,At this stage all the database schema of the target database gets stored in ur recovery catalog.
    RMAN > register database;

    Now u can take backups of database,tablespace,redo log files,controlfiles including RMAN.I will give u some examples for each one of it using RMAN

    1.To take backup of ur entire database
    RMAN > run
    {
    allocate channel c1 type disk;
    allocate channel c2 type disk;
    backup
    filesperset 5 format 'disk1\backup\fullbackup.bus'
    (database include current controlfile);
    release channel c1;
    release channel c2;
    }

    //--//

    Do I have to follow these steps for all my table spaces?
    If yes then while recovery how do I work with that?

    //--//
    2. To take backup of tablespace(In RMAN u dont have to put ur tablespace in hot backup mode)
    RMAN > run
    {
    allocate channel c1 type disk;
    allocate channel c2 type disk;
    backup tablespace USERS_DATA;
    filesperset 5 format 'disk1\backup\USERSbackup.bus';
    release channel c1;
    release channel c2;
    }


    3. To take backup of ur controlfile(In RMAN u have to create image copy of ur controlfile and then copy to tape as image copies cannot be directly copied to TAPE)

    RMAN > run
    {
    allocate channel c1 type disk;
    copy
    current controlfile to '/disk2/rman/currentcontrol1204200.ctl';
    release channel c1;
    }

    4. To take backup of ur datafile
    RMAN > run
    {
    allocate channel c1 type disk;
    copy
    datafile 5 to '/disk2/rman/usersdata02.dbf';
    release channel c1;
    }

    5. To take backup of ur redo log files
    RMAN > run
    {
    allocate channel c1 type disk;
    allocate channel c2 type disk;
    backup
    filesperset 5 format 'disk1\backup\archbackup_%d_%s_%p.bus'
    (archivelog);
    release channel c1;
    release channel c2;
    }



    6. TO restore ur database using RMAN
    RMAN > run
    {
    allocate channel c1 type disk;
    allocate channel c2 type disk;
    sql "alter tablespace USERS_DATA offline";
    restore tablespace USERS_DATA;
    recover tablespace USERS_DATA;
    sql "alter tablespace USERS_DATA online";
    release channel c1;
    release channel c2;
    }



    Use 'create catalog' command instead catrman script in 8i

    Thank you


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width