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

Thread: RMAN backup

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    RMAN backup

    Hi Friends,
    Oracle 8.1.7.4, solaris 2.7

    I am doing a backup using RMAN with multiple channels and filesperset 2.

    Total no of datafiles to be backed are 56.Each datafiles are 1GB of size.Once the backup was over successfully, the total no. of files in the backup drive was only 30.Some backup files were 2 GB in size.

    Is this a norman process, if yes then during restore will RMAN identifiy these as two seperate files and do the recovery, please help me in understanding.

    This is the backup script

    run {
    allocate channel d1 type disk format='/disk/bckup/db_t%t_s%s_p%p';
    allocate channel d2 type disk format='/disk/bckup/db_t%t_s%s_p%p';
    allocate channel d3 type disk format='/disk/bckup/db_t%t_s%s_p%p';
    allocate channel d4 type disk format='/disk/bckup/db_t%t_s%s_p%p';
    set maxcorrupt for datafile
    212,1,2,3,4,5,6,7,8,9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35
    , 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53 to 100;

    backup (datafile 212,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 3
    4, 35 , 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53 filesperset 2);

    release channel d4;
    release channel d3;
    release channel d2;
    release channel d1;


    regards
    anandkl
    Last edited by anandkl; 01-08-2004 at 06:33 AM.
    anandkl

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    How many channels are you allocating?

    Don't compare size of your datafiles to the RMAN backup files. RMAN backs-up only used blocks. As long as RMAN doean't give any error you should be safe BUT again doing a test restore-recover is always recommended.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Sanjay,
    As u can see the script, i am allocating 4 channels.
    anandkl

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You need not worry about no. of backup pieces. RMAN calculates it internally based on no. of channels parallaly backing-up and filesperset.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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