Исходные данные: 2 ноды RAC (ora-big1, ora-big2), сервер netbackup (vm-netbackup)
Задача: настроить корректную схему бэкапа - incr 0 (1/month), cumm (1/week), incr 1 (1/day)
Скрипты бэкапов:
::::::::::::::
/opt/oracle-shared/backup/arch_backup.rman
::::::::::::::
backup device type sbt archivelog all delete all input;
::::::::::::::
/opt/oracle-shared/backup/cumm_backup.rman
::::::::::::::
backup incremental level 1 CUMULATIVE database plus archivelog delete input;
delete noprompt backup of archivelog until time 'sysdate-1';
crosscheck backup;
#delete noprompt obsolete;
::::::::::::::
/opt/oracle-shared/backup/full_backup.rman
::::::::::::::
crosscheck archivelog all;
crosscheck backup;
backup incremental level 0 database plus archivelog delete input;
#delete noprompt obsolete ;
::::::::::::::
/opt/oracle-shared/backup/incr_backup.rman
::::::::::::::
Проблема: по умолчанию ноды не видят бэкапы сделанные другой нодой. соответственно crosscheck уводит в expired бэкапа сделанные другой нодой, а delete nopromp obsolete затирает их
Решение:
в rman:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
Задача: настроить корректную схему бэкапа - incr 0 (1/month), cumm (1/week), incr 1 (1/day)
Скрипты бэкапов:
::::::::::::::
/opt/oracle-shared/backup/arch_backup.rman
::::::::::::::
backup device type sbt archivelog all delete all input;
::::::::::::::
/opt/oracle-shared/backup/cumm_backup.rman
::::::::::::::
backup incremental level 1 CUMULATIVE database plus archivelog delete input;
delete noprompt backup of archivelog until time 'sysdate-1';
crosscheck backup;
#delete noprompt obsolete;
::::::::::::::
/opt/oracle-shared/backup/full_backup.rman
::::::::::::::
crosscheck archivelog all;
crosscheck backup;
backup incremental level 0 database plus archivelog delete input;
#delete noprompt obsolete ;
::::::::::::::
/opt/oracle-shared/backup/incr_backup.rman
::::::::::::::
backup incremental level 1 database plus archivelog delete input;
delete noprompt backup of archivelog until time 'sysdate-1';
crosscheck backup;
#delete noprompt obsolete ;
Решение:
в rman:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=oraPOLICY,NB_ORA_SERV=vm-netbackup,NB_ORA_CLIENT=ora-big1)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=oraPOLICY,NB_ORA_SERV=vm-netbackup,NB_ORA_CLIENT=ora-big2)';
на vm-netbackup
cd /usr/opnv/netbackup/db/altnames echo "ora-big2" >> ora-big1 echo "ora-big1" >> ora-big2