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

Thread: How to take incremental level 1 backup

  1. #1
    Join Date
    Aug 2005
    Posts
    5

    How to take incremental level 1 backup

    Hi

    Last week i took rman full database backup. Now i want to take incremental backup. But i am not getting syntax to take incremental backup. Plz help me.

    Thanks,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well tell us what you have tried and we can see where you have gone wrong

  3. #3
    Join Date
    Mar 2004
    Posts
    8
    I have an example, FYI:
    Consider u had done a full database backup with RMAN, so it's a level 0 backup, I use this sentence:
    BACKUP INCREMENTAL LEVEL 0 DATABASE;
    And the level 1 backup sentence is:
    BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
    or:
    BACKUP INCREMENTAL LEVEL 1 DIFFERENTIAL TABLESPACE users;
    By the way, u can reference Oracle doc(no:b14194).

  4. #4
    Join Date
    Aug 2005
    Posts
    5
    I took my database backup using rman last week and the database is running in archive log mode, now i want to take these one week data backup i.e. incremental backup. and i want to take cumulative level 1 backup. But i dont know the code for this kind of backup. so, i need ur help.

    Thanks,

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well as i said, tell us what you have got so far and we can see where you are going wrong

  6. #6
    Join Date
    Aug 2005
    Posts
    5
    for level 0 i used this code:
    rman> run{
    allocate channel c1 type disk;
    backup database filesperset 2 format 'aug%s%t';
    }

    this i took backup on 5th august. now i dont want to take full database backup. whatever changes happend only that backup, incremental backup i want to take. but code i dont know. ex: i am trying in this way.

    rman>run{
    allocate channel c1 type disk;
    backup database incremental level 1 format 'aug%s%t' filesperset 2;
    }

    my problem is i dont know the code at all.

    Plz help me in giving code both in cumulative and differential.

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