Re: RMAN MAXPIECESIZE doesn't appear to be working

Morning Steve,

I use the MAXPIECESIZE parameter on 12c but rather than setting it by channel type, I just change the RMAN configuration. Granted, this is going via SBT_TAPE to the cloud, but it really shouldn't make a difference: Notice I also include the section size parameter. Had some issues initially as we've got a couple of bigfile tablespaces and for some reason, that solved it.

spool log to '/home/oracle/scripts/backup/log/ORCL_FullBackup_CLOUD.log' APPEND; HOST 'echo Backup Started - >>
/home/oracle/scripts/backup/log/ORCL_FullBackup_CLOUD.log'; HOST 'date >> /home/oracle/scripts/backup/log/ORCL_FullBackup_CLOUD.log';

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 32 BACKUP TYPE TO BACKUPSET; CONFIGURE MAXSETSIZE TO 24576M; set encryption on identified by "xxxxxxxx" only;

set compression algorithm 'MEDIUM';

run {
allocate channel c1 type 'SBT_TAPE' parms 'BLKSIZE=524288,SBT_LIBRARY=/u01/app/oracle/product/12.2.0/dbhome_1/lib/libopc.so,ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/oci_config)'; allocate channel c2 type 'SBT_TAPE' parms 'BLKSIZE=524288,SBT_LIBRARY=/u01/app/oracle/product/12.2.0/dbhome_1/lib/libopc.so,ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/oci_config)'; BLAH, BLAH, BLAH backup DATABASE TAG "${FILETAG}" section size 24576M;

release channel c1;
release channel c2;

CONFIGURE MAXSETSIZE TO UNLIMITED;
}

HOST 'echo Backup Ended - >>
/home/oracle/scripts/backup/log/ORCL_FullBackup_CLOUD.log'; HOST 'date >> /home/oracle/scripts/backup/log/ORCL_FullBackup_CLOUD.log';

On Thu, May 14, 2020 at 8:02 PM Steve Wales (AddOns) < steve.wales_at_addonsinc.com> wrote:

> I feel like I’m missing something.
>
>
>
> Running a test on breaking down a backup into smaller pieces for loading
> into cloud based storage for a new offsite solution.
>
>
>
> The request was to make the files in the backup be about 4.5GB (hence
> 4608M)
>
>
>
> Running 18c Standard Edition / 18.10 Release Update / Linux 7 on OVM.
>
>
>
> When I run the following:
>
>
>
> run
>
> {
>
> allocate channel c1 device type disk;
>
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
>
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
> '/backups/db1/ctl-%F';
>
> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 4608M;
>
> backup as compressed backupset incremental level=0 database tag db1_FULL
> format '/backups/db1/%d_%T_%s_%p_FULL';
>
> }
>
>
>
> My database (which has a total footprint of a little over 500GB) gives me
> 1 x 66GB backup file.
>
>
>
> I did try
>
>
>
> Backup as compressed backupset section size 4608M ….
>
>
>
> That gave me lots (LOTS!) of smaller files, most of them not even close to
> 4.5GB.
>
>
>
> I’ve read the relevant sections of the 18c Documentation and it seems to
> me that I’ve got the right options defined in the right place and doing to
> old Google search found several people who have tried the same thing and
> haven’t had answers.
>
>
>
> Someone suggested FILESPERSET > total number of datafiles, but the
> documentation indicates that if you don’t specify filesperset what the
> default formula is to calculate it and it should have worked.
>
>
>
> So if anyone is able to tell me what I’m doing wrong and more importantly
> WHY – I’d appreciate the tip here.
>
>
>
> Thanks
>
> Steve
>
> *Disclaimer*
>
> The information contained in this communication from the sender is
> confidential. It is intended solely for use by the recipient and others
> authorized to receive it. If you are not the recipient, you are hereby
> notified that any disclosure, copying, distribution or taking action in
> relation of the contents of this information is strictly prohibited and
> may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
> automatically archived.
>

--
http://www.freelists.org/webpage/oracle-l