Usefull rman backup commands listed below , hope it will help
DB full backup include Archive backup:
RUN
{
ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 10G;
BACKUP
FORMAT '/bkp_location/%d_D_%T_%u_s%s_p%p'
DATABASE
PLUS ARCHIVELOG
FORMAT 'bkp_location/%d_A_%T_%u_s%s_p%p';
RELEASE CHANNEL ch11;
}
Incremental backup:
RUN
{
CONFIGURE DEVICE TYPE disk PARALLELISM 2;
ALLOCATE CHANNEL disk1 DEVICE TYPE disk FORMAT 'D:\Bkp_Standby\ForStandby_%U' maxpiecesize 40 G;
ALLOCATE CHANNEL disk2 DEVICE TYPE disk FORMAT 'C:\db_inc_bkp\ForStandby_%U' maxpiecesize 30 G;
BACKUP INCREMENTAL FROM SCN 32079657 DATABASE;
}
Archive Backup:
RUN {
CONFIGURE DEVICE TYPE disk PARALLELISM 4;
set archivelog destination to 'bkp_location';
BACKUP ARCHIVELOG from logseq 56782 until logseq 56789 thread 1 format '/bkp_location/%d_D_%T_%u_s%s_p%p';
}
Decrypted encrypted backup:
RMAN> set DECRYPTION identified by 'password';
Point In Time restore and recovery:
RMAN> run {
allocate channel ch01 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
set until time="to_date('2017/10/19 18:00:00', 'yyyy/mm/dd hh24:mi:ss')";
restore database;
recover database;
}
Estimate RMAN Duplicate or Clone Timings:
alter session set nls_date_format = 'DD-MM-YYYY HH24:MI:SS';
select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at
from gv$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%';
No comments:
Post a Comment