SCRIPT RMAN

[felipegParticipante]

[quote=”fabiommiranda”:2ujiq3zm]Fala pessoal to precisando de um exemplo de script rman de seg a sab incremental e domingo full . levando os archives e compactado.[/quote]

Ola, bom dia,

Então, se for um banco grande você pdoe seguir esta estratégia
Minha window no RMAN é de 7 dias

Sabado / Domingo – Full
Segunda – Cumulativo
Terça – Cumulativo Diferencial
Quarta – Cumulativo
Quinta – Cumulativo Diferencial
Sexta – Cumulativo
Archive de 15 em 15 minutos

OBS: Habilitar BLOCK CHANGING TRACK e alterar nos scripts os valores que você precisa

RMAN0

RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
ALLOCATE CHANNEL c4 DEVICE TYPE DISK;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0
FORMAT '/u02/backup/bkfull_%d_%s_%p.bak'
DATABASE TAG 'bkp_full';

CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;
}


RMAN1

RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
ALLOCATE CHANNEL c4 DEVICE TYPE DISK;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1
FORMAT '/u02/backup/in_%d_%s_%p.bak'
DATABASE TAG 'bkp_1';

CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;
}


RMAN1 cumulativo

RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
ALLOCATE CHANNEL c4 DEVICE TYPE DISK;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 CUMULATIVE
FORMAT '/u02/backup/incl_%d_%s_%p.bak'
DATABASE TAG 'bkp_1c';

CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;

}


Archives

RUN{

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET
FORMAT '/u02/backup/arch_%d_%s_%p.arc'
ARCHIVELOG ALL DELETE INPUT;

}

Espero ter ajudado.
Atenciosamente,
Felipe.