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

Thread: Incremental backup

  1. #1
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Hi,
    Can anybody tell me if one can perform an incremental backup of a particular user objects.


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I think it is possible using RMAN utility, but, you have to backup the tablespace, datafile where the user schema resides. For detail refer RMAN documentaion.

    Hope this would help you,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Thanks Sambavan. But can you be more eloberate, because when I was going Through RMAN Docs, I didn't encounter anything like userwise backup.

    Thanks again.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    There are some sample rman scripts that would help you to get an idea.

    It is there at $ORACLE_HOME/rdbms/demo and check those scripts with "rcv" extensions. That would help you to do things.

    IF you have any problems, just let us know.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    Using RMAN u can take incremental tablespace backups. If your user belongs to a default single tablspace you can use this feature.
    All the best.

  6. #6
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    Incremental:Backing up all used blocks since the most recent backup at level n or lower.

    E.g. At differential level 2 backup RMAN determines level 1 or
    level 2 backup occurred recently and backs up all changed blocks

    At differential level 1 RMAN copies all changed blocks since the base level 0 backup.

    >We should have level 0 backup first to make 1 and 2 incremental backups.


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