Re: RMAN MAXPIECESIZE doesn't appear to be working

Hi Steve,
you may try with one of these to put the maxpiece clause either before the allocate command or inside the backup command:

CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/db1/ctl-%F';

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 4608M; run

{

allocate channel c1 device type disk;

backup as compressed backupset incremental level=0 database tag db1_FULL format '/backups/db1/%d_%T_%s_%p_FULL';

release channel c1;

}

CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/db1/ctl-%F';
run

{

allocate channel c1 device type disk;

backup as compressed backupset incremental level=0 database tag db1_FULL MAXPIECESIZE 4608M format '/backups/db1/%d_%T_%s_%p_FULL';

}

Il giorno ven 15 mag 2020 alle ore 03:02 Steve Wales (AddOns) < steve.wales_at_addonsinc.com> ha scritto:

> 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