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@xxxxxxxxxxxxx> 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.
