| Роскошный Сайгак |
|---|
| Что нужно сделать, чтобы бэкап выполнился быстрее? |
1) incremental backup
2) распараллелить запись
Использовать несколько каналов, но чтобы один файл лить в несколько потоков, нужно
Чтобы выполнять backup одного файла в несколько потоков:
| + Oracle® Database Backup and Recovery Reference 11g |
SECTION SIZE sizeSpec Specifies the size of each backup section produced during a data file backup.
By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy.
File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set.
If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.
Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job.
Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.
|
Чтобы backup не грузил основную базу:
использовать split mirror, BCV
Делать backup со standby