RMAN full database backup script :


configure backup optimization on;

configure controlfile autobackup on;

configure controlfile autobackup format for device type disk to '/archiva/backup/%F';

configure maxsetsize to unlimited;

configure device type disk parallelism 4;

run

{

allocate channel c1 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

allocate channel c2 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

allocate channel c3 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

allocate channel c4 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

backup as compressed backupset incremental level 0 check logical database plus archivelog;

release channel c1 ;

release channel c2 ;

release channel c3 ;

release channel c4 ;

} 

RMAN INCR db backup run block 


configure backup optimization on;

configure controlfile autobackup on;

configure controlfile autobackup format for device type disk to '/archiva/backup/%F';

configure maxsetsize to unlimited;

configure device type disk parallelism 4;

run

{

allocate channel c1 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

allocate channel c2 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

allocate channel c3 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

allocate channel c4 type disk format '/archiva/backup/%I-%Y%M%D-%U' maxpiecesize 3G;

backup as compressed backupset incremental level 0 check logical database plus archivelog;

release channel c1 ;

release channel c2 ;

release channel c3 ;

release channel c4 ;

} 

delete archive older than 1 day 


DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-1';

CROSSCHECK ARCHIVELOG ALL;

DELETE EXPIRED ARCHIVELOG ALL; 

Backup all archivelogs known to controlfile

backup archivelog all;

Backup all archivelogs known to controlfile and delete them once backed up

backup archivelog all delete input ;

Backup archivlogs known to controlfile and the logs which haven't backed up once also

backup archivelog all not backed up 1 times;


Monitor rman backup progress 

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,

ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"

FROM V$SESSION_LONGOPS

WHERE OPNAME LIKE 'RMAN%'

AND OPNAME NOT LIKE '%aggregate%'

AND TOTALWORK != 0

AND SOFAR <> TOTALWORK; 

Restore archivelog from rman tape 

-----Below  script will restore the archive sequences from 7630 to 7640 to /dumparea location

connect target sys/******@CRM_DB
connect catalog RMAN_tst/*****@catdb

run
{
allocate channel t1 type SBT_TAPE parms ‘ENV=(NSR_SERVER=nwwerpw,NSR_CLIENT=tsc_test01,NSR_DATA_VOLUME_POOL=DD086A1)’connect sys/****@CRM_DB;
set archivelog destination to ‘/dumparea/';
restore archivelog from sequence 7630 until sequence 7640;
release channel t1;
}