ITPub博客

首页 > 数据库 > Oracle > rman备份相关

rman备份相关

原创 Oracle 作者:d_ball_apple 时间:2014-08-04 17:04:36 0 删除 编辑

RMAN:
show all ;查看备份参数 或者 查看动态性能视图 v$rman_configuration
configure controlfile autobackup on;打开对控制文件自动备份

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 3;配置磁带并行度为3;

 查看相关配置:
RMAN> SHOW CONTROLFILE AUTOBACKUP FORMAT;
RMAN> SHOW EXCLUDE;
RMAN> SHOW ALL;

恢复默认设置:
RMAN> CONFIGURE BACKUP OPTIMIZATION CLEAR;
RMAN> CONFIGURE MAXSETSIZE CLEAR;
RMAN> CONFIGURE DEFAULT DEVICE TYPE CLEAR;

disk磁盘 tape/sbt磁带

设置默认到磁盘还是磁带  分配通道
RMAN> CONFIGURE DEVICE TYPE sbt;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt ...
RMAN> BACKUP DATABASE;

RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
BACKUP DATABASE PLUS ARCHIVELOG;
}
RMAN> backup database plus archivelog;命令的理解!

 

个人理解如下:

 

执行命令后系统 切换redo log并归档à备份归档文件(scn:604010~609123)à备份数据文件(ckp scn:

609130/609129)à切换redo log并归档à备份归档文件(scn:609123~609152)à备份spfile和control file

(ckp scn:609158)



backup copies 2(备份两份) datafile 4 format ='路径';备份,并设置备份到的路径;


RMAN> CONFIGURE BACKUP OPTIMIZATION ON;优化设置,备份时跳过没发生过变化的部分

backup as compressed backupset database;压缩备份

CONFIGURE COMPRESSION ALGORITHM 'HIGH/MEDIUM/LOW/BASIC'备份强度
run {
SET COMPRESSION ALGORITHM 'HIGH/MEDIUM/LOW/BASIC';
..
}



第五章:
 
以备份集的形式备份到。。。
RMAN> BACKUP AS BACKUPSET
   2> FORMAT '/BACKUP/df_%d_%s_%p.bus'
  3> TABLESPACE hr_data;

list backup of datafile 4;显示4号文件的备份信息

crosscheck backup; 检查操作系统和数据库上的备份信息


全拷贝:
RMAN> BACKUP AS COPY DATAFILE '/ORADATA/users_01_db01.dbf'; 
RMAN> BACKUP AS COPY ARCHIVELOG LIKE '/arch%';


imagecope另一种拷贝方法(直接复制):
针对数据文件
copy datafile 4 to '/home/oracle/users....bak';


全备:
backup full datafile 4;
0级备份
backup incremental level 0 datafle 4;
增量备份:
backup incremental level 1 datafle 4;
累积增备:
backup incremental level 1 cumulative datafle 4;

备份全部数据库 转移到磁盘:
RMAN> BACKUP DEVICE TYPE DISK AS BACKUPSET  
   2> DATABASE PLUS ARCHIVELOG;
RMAN> BACKUP DEVICE TYPE sbt BACKUPSET ALL;


alter database enable block change tracking using file '路径';开启块改变跟踪


并行备份:

BACKUP DATAFILE 5 SECTION SIZE = 25M ;分成多块备份  一块25M


保留策略:

backup keep until time 'sysdate+365' datafile 4 format'';保留一年,不能保存到快速恢复区
backup keep forever datafile 4 format'’;永久保留

change backup tag(+tag编号) nokeep; 取消保留策略


把快速恢复区做个全部备份
backup recovery area to destination '路径';
备份所有的备份文件
backup recovery files

delete copy/backup 删除备份

把所有备份备份到磁带
run{
 allocate channel c1 device type sbt;
 backup recover files;
}

LIST: Displays information about backup sets, proxy copies, and image copies recorded in the

repository
REPORT: Produces a detailed analysis of the repository
REPORT NEED BACKUP: Lists all data files that require a backup看没有备份且需要备份的数据文件备

份
REPORT OBSOLETE: Identifies files that are no longer needed to satisfy backup retention

policies查看多余的备份

delete OBSOLETE 删除多余的备份

report need backup recovery window of 3 days;三天内要过期的需要备份的备份

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28889722/viewspace-1245131/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: rman加密备份
下一篇: RMAN还原恢复
请登录后发表评论 登录
全部评论

注册时间:2013-05-15

  • 博文量
    39
  • 访问量
    84862