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

Thread: RMAN script

  1. #1
    Join Date
    Jul 2007
    Posts
    32

    RMAN script

    hi,

    I have taken full backup yesterday including archivelog files upto sequence# 2848.Now i need to take incremental backup of database plus archivelog files from that sequence#2848 to till now.
    Oracle version :10.2.0
    WindowsNT


    I tried using this script :
    Run
    {
    allocate channel c1 device type disk format='f:/backup/increment/Increment_bkp_Jul31/db_%U';
    backup incremental level 1 database;
    backup archivelog from sequence 2849;
    }


    Is there any other way? if ? guide me plz...

    TIA,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and what happened when you used that script

  3. #3
    Join Date
    Jul 2007
    Posts
    32
    hi,
    ya it works but it takes 30 minutes to complete. And also i want to know? if there is any other method?

    TIA

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Enable block change tracking

  5. #5
    Join Date
    Jul 2007
    Posts
    32
    hi,
    what is it used for?

    TIA

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    See brief description here
    http://www.oracle.com/technology/ora...v/o64rman.html

    For more details you will have to consult the documentation

  7. #7
    Join Date
    Nov 2001
    Posts
    335
    It might be doing a full backup in case you did not run level 0 backup.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  8. #8
    Join Date
    Jul 2007
    Posts
    32
    hey Bore Thanks for ur reply,
    Can u give some links of detailed documentation of Enable Block change tracking mechanism.

    TIA,

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