RMAN Backup Script

Lupa!!! .... lupa .. lupa .. lupa .. lupa .. lupa lagi script rman nyaa (kuburan mode=on), biar gak lupa gw posting ah di blog :

run
{
set controlfile autobackup format for device type disk to '/oracle/autobackup/ctlf_%F';
configure controlfile autobackup on;
CONFIGURE COMPRESSION ALGORITHM 'ZLIB';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
crosscheck backup;
delete noprompt expired backup;
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database format='/oracle/backup/df_%T_%U' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '/oracle/backup/arch_%T_%U';
delete force copy of archivelog all completed before 'sysdate-1';
backup current controlfile format '/oracle/backup/ctlf_%T_%U';
release channel c1;
release channel c2;
}

kalo
CONFIGURE COMPRESSION ALGORITHM 'ZLIB';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
itu untuk di 11g nah kalo di 10g ato dibawahnya
ilangin aja configure diatasnya.
configure di set supaya hasil backup nya bisa lebih ngehemat space(disk)/tape

beberapa check dan script yang digunakan dalam Recovery Manager (RMAN) :

RMAN> list backup by file;

RMAN> report obsolete;

RMAN> list incarnation;

RMAN> show all;

RMAN> list backup;

RMAN> list archivelog all;