基于catalog 的RMAN 备份与恢复

--=================================-- 基于catalog 的RMAN 备份与恢复--================================= RMAN的备份与恢复存储仓库的数据通常存放于控制文件或恢复目录中，本文主要讲述基于catalog的备份与恢复。关于catalog的创建请参考：RMAN catalog的创建和使用 http://www.linuxidc.com/Linux/2013-08/88788.htm catalog方式的RMAN备份与恢复只不过是将备份恢复信息数据放在catalog目录内，普通的rman方式则是存放在控制文件中catalog方式可以存储常用或特定的备份与恢复的脚本有关catalog方式RMAN存储脚本请参考：基于 catalog 创建RMAN存储脚本 http://www.linuxidc.com/Linux/2013-08/88789.htm 一、基于catalog来备份数据库（目标数据库orcl，恢复目录数据库asmdb）首先基于catalog创建备份脚本--连接到RMAN[Oracle@oradb ~]$ rman target sys/RedHat@orcl catalog rman/rman@asmdbconnected to target database: ORCL （DBID=1263182651）connected to recovery catalog database --创建全局删除废弃备份的脚本RMAN> create global script global_del_obsocomment "A script for obsolete backup and delete it" {2> allocate channel ch1 device type disk;3> delete obsolete recovery window of 7 days;4> release channel ch1;5> } new incarnation of database registered in recovery catalogstarting full resync of recovery catalogfull resync completecreated global script global_del_obso --创建全局归档日志的备份脚本RMAN> create global script global_arch2> comment " A script for archivelog and delete it "3> {4>allocate channel ch1 device type disk;5>sql " alter system archive log current";6>set limit channel ch1 readrate=10240;7>set limit channel ch1 kbytes=2048000;8>backup as compressed backupset archivelog all delete input9>format="/u01/bk/rmbk/arch_%d_%U"10>tag="Archbk";11>release channel ch1;12> } created global script global_arch --创建全局0级增量备份脚本RMAN> create global script global_inc02> comment " A script for backup database using incremental level 0"3> {4>execute global script global_del_obso;5>allocate channel ch1 device type disk;6>set limit channel ch1 readrate=10240;7>set limit channel ch1 kbytes=2048000;8>backup as compressed backupset incremental level 0 database9>format="/u01/bk/rmbk/inc0_%d_%U"10>tag="Inc0";11>release channel ch1;12>execute global script global_arch;13> } created global script global_inc0 --列出已经创建的全局脚本RMAN> list global script names; List of Stored Scripts in Recovery Catalog Global Scripts Script NameDescription-----------------------------------------------------------------------global_archA script for archivelog and delete it global_del_obsoA script for obsolete backup and delete it global_inc0A script for backup database using incremental level 0 --启用控制文件的自动备份功能RMAN> configure controlfile autobackup on;RMAN> configure controlfile autobackup format for device type disk to "/u01/bk/rmbk/auto_ctl_%d_%f"; --删除以前的备份RMAN> delete noprompt backupset; --备份前验证归档日志是否存在RMAN> crosscheck archivelog all; --删除无效的归档日志信息RMAN> delete noprompt expired archivelog all; --使用0级增量备份数据库RMAN> run { execute global script global_inc0;} --查看刚刚完成的备份情况RMAN> list backupset summary;RMAN> list backupset ;RMAN> list backup of controlfile ;RMAN> list backup of archivelog all;RMAN> list backup of database;RMAN> list backup of datafile n ;

基于catalog 创建RMAN存储脚本Oralce 10g 使用DBCA创建数据库相关资讯 rman catalog rman备份

RMAN备份报 RMAN-06059 错误（05月13日）
RMAN备份文件远大于数据库大小的原（01月09日）
Oracle RMAN备份之控制文件备份（12/20/2015 20:07:06）

RMAN备份策略修正案例实录（02月29日）
Oracle 11g R2 RAC RMAN备份脚本示（12/27/2015 11:33:20）
RMAN备份时遇到ORA-19588 （07/23/2015 15:01:01）

本文评论查看全部评论（0）