Oracle databas RMAN

以你之姓@ 2022-05-29 01:05 204阅读 0赞

# RMAN #

登录  
rman target sys/sys  
查看所有配置参数  
show all;  
恢复窗口配置为7天  
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  
控制文件自动备份  
configure controlfile autobackup on;  
控制文件备份到/bak/con/  
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/bak/con/%F’;

备份闪回  
backup recovry area;  
备份备份集  
backup backupset 18;  
检查归档文件  
crosscheck archivelog all;  
同步数据文件与归档文件  
delete expired archivelog all ;  
查看失效备份  
crosscheck backup;  
删除备份集  
delete backupset <备份集号> ;

--------------------

## image copy ##

禁用  
alter database datafile 6 offline;  
复制  
RMAN>copy datafile 6 to ‘+DATAVG/orcl/datafile/zz.dbf’;  
更改数据文件的位置  
alter database rename file ‘/data01/zz.dbf’ to ‘+DATAVG/orcl/datafile/zz.dbf’;  
恢复  
recover datafile 6;  
启用  
alter database datafile 6 online;

--------------------

增量备份  
run \{  
recover copy of database with tag ‘incr\_update’;  
backup incremental level 1 for recover of copy with tag ‘incr\_up’ database format ‘/bak/db\_%s.bak’;  
recover copy of database with tag ‘incr\_con’;  
backup incremental level 1 for recover of copy with tag ‘incr\_con’ current controlfile format =’/bak/c\_%s.bak’;  
recover copy of database with tag ‘incr\_sp’;  
backup incremental level 1 for recover of copy with tag ‘incr\_sp’ spfile format =’/bak/sp\_%s.bak’;  
\}

--------------------

# DRA #

list failure;  
advise failure;  
repair failure;

--------------------

编目RMAN元数据  
CATALOG DATAFILECOPY ‘/disk1/old\_datafiles/01\_01\_2003/users01.dbf’;  
CATALOG ARCHIVELOG ‘/disk1/arch\_logs/archive1\_731.dbf’, ‘/disk1/arch\_logs/archive1\_732.dbf’;  
CATALOG BACKUPPIECE ‘/disk1/backups/backup\_820.bkp’;  
CATALOG START WITH ‘/disk1/backups/’;  
备份脚本：

#zyz
    source ~/.bash_profile
    
    export BACK_DATE=`date +%Y%m%d`
    
    export BACKUP_PATH=/data/spi_bak/script/rman
    
    echo `mkdir -p ${BACKUP_PATH}/${BACK_DATE}`
    
    rman target /  msglog=${BACKUP_PATH}/${BACK_DATE}/bak_0_$BACK_DATE.log << EOF
    
    run  
    {  
    allocate channel ch1 device type disk;  #分配通道  
    allocate channel ch2 device type disk;  
    sql 'alter system archive log current'; #归档当前日志  
    backup database format '${BACKUP_PATH}/${BACK_DATE}/data_%s.bak';  
    backup format '${BACKUP_PATH}/${BACK_DATE}/conbak_%s.bak' current controlfile;  
    backup spfile format ='${BACKUP_PATH}/${BACK_DATE}/spfile_%s.bak';
    crosscheck backup;  
    crosscheck archivelog all; 
    sql 'alter system archive log current';  
    backup archivelog all format '${BACKUP_PATH}/${BACK_DATE}/arch_%s.bak' delete all input;  
    crosscheck backup;  
    crosscheck archivelog all;  
    delete noprompt expired backup;  
    delete noprompt obsolete;  
    delete noprompt backup of database completed before 'sysdate -1';  
    delete noprompt archivelog all;  
    delete noprompt backup of archivelog all completed before 'sysdate -1';  
    release channel ch1;  
    release channel ch2;  
    } 
    
    
    exit;
    
    EOF

backup archivelog all delete input format ='/home/u01/app/orabak/arch_%s.bak'  ;  
    backup database format='/home/bak/data_%s.bak';
    backup current controlfile format ='/home/bak/conbak_%s.bak';

数据文件损坏：

1、offline数据文件  
SQL>alter database datafile ‘/u01/data/orcl/block\_ts01.dbf’ offline;

2、copy数据文件到响应的位置(RMAN)  
rman>run \{  
recover copy of database with tag ‘incr\_datafile8’;  
backup incremental level 1 for recover of copy with tag ‘incr\_datafile8’ datafile 8 format=’/backup/datacopy/level1\_%d\_%T\_%s.dbf’;  
\}

3、对数据文件rename  
SQL>alter database rename file ‘/u01/data/orcl/tbs10.dbf’  
to ‘/flashback/ORCL/datafile/o1\_mf\_tbs10\_dn9plmd8\_.dbf’;

4、recover数据文件  
SQL>recover datafile ‘+DATADG/ywkdb/datafile/TS\_XG\_D.dbf’;

5、对数据文件online  
SQL>alter database datafile ‘+DATADG/ywkdb/datafile/TS\_XG\_D.dbf’ online;