RMAN create multiple backup sets when "keep" clause is used
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RMAN create multiple backup sets when "keep" clause is used

  1. #1
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29

    RMAN create multiple backup sets when "keep" clause is used

    Dear All,

    I am trying to use the following command to backup the spfile with retention period 7 days:

    >>>>
    RMAN> backup spfile keep until time 'sysdate+7' tag='D_SP_TEST';
    <<<<

    However, RMAN creates 4 backup sets instead of one. Does anyone has any idea why? If I don't use the "keep" clause, I don't have this problem.

    Any suggestions are welcome.

    Thanks and Regards,

    -- Chris

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Typically, KEEP will create multiple backup sets. Therefore, it would seem that one is for the SPFILE, one is for the archivelogs, one is for the controlfile and the additional one would be for any datafiles and since you aren't backing up any datafiles, it produces a backupset with just another backup of the spfile.

    To create only one backupset, you could issue the following instead:

    Code:
    backup spfile keep until time 'sysdate+7' nologs tag='D_SP_TEST';

  3. #3
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29
    Thanks a lot for your information!

    Regards,

    -- Chris

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    You will also generate multiple backups sets by using multiple channels during the backup.
    this space intentionally left blank

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    Quote Originally Posted by gandolf989 View Post
    You will also generate multiple backups sets by using multiple channels during the backup.
    However, in the case presented above with the NOLOGS, only one backupset (piece) will be created. Unless of course, CONTROLFILE AUTOBACKUP is ON.

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