RMAN MAXPIECESIZE Followup

From: Steve Wales (AddOns) <"Steve>
Date: Mon, 18 May 2020 19:36:39 +0000
Message-ID: <CY4PR20MB1527F55EA3C5B49F8AC3A316F1B80_at_CY4PR20MB1527.namprd20.prod.outlook.com>

Oracle support did get back to me, so here’s the follow up as promised for those who may care 😊

ACTION PLAN :

---

1. Set "MAXPIECESIZE 4608M" as part of RMAN Persistent Configuration as below :

$ RMAN target /

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/db1/ctl-%F';
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 4608M;

2. Remove "allocate channel c1 device type disk;" from the backup command and execute backup as below : * Channel allocation would happen with maxpiece size from RMAN Persistent Configuration.

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

Followed those steps and got what I needed. Tested it and results were as required.

As an aside, of course, now I’ve found that it’s not needed because I was told this morning that the cloud storage was configured incorrectly and we can actually use much bigger files than the 5GB I was originally told about.

Thanks to all who took the time to look at my question and respond.

Regards,
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






(image/gif attachment: image001.gif)

Received on Mon May 18 2020 - 21:36:39 CEST