RMAN学习.docx

第一讲、FULL backupTarget databseRecovery ctalog databseAuxiliabry database（Auxi 助动词）第一讲 target database 检查archivelog模式：sqlarchive log list2)select archiver from v$instance;3)select log_mode from v$database;检查rman命令的有效：保证￥PAT顺序Rman or rman nocatalogConnect target /List backupset(查看已备份的信息)，report shcema, list copy等Backup database(全备份)，产生 .bkp的备份文件第二讲、增量备份查看rman默认参数：show all;Backup incremental level=0 database;(0级增量备份)Backup incremental level 1 database;(1级增量备份)查看 .bkp二进制文件 strings controlo1.ctl可以看到所有nocatalog备份的信息注：Rman默认创建的增量备份是Differential方式，如果要建立Cumulative方式(累积增量)的增量备份，在执行BACKUP命令时显式指定即可，例如：RMAN BACKUP INCREMENTAL LEVEL=2 CUMULATIVE DATABASE;***只有rman能进行增量备份，rman能在noarchivelog下进行增量备份，(前提是：mount状态)，rman也能在数据库关闭情况下进行增量备份(前提：Recovery ctalog)第三讲、备份归档/控制/表空间/数据文件备份archivelog:backup database plus archivelog delete input;(同时备份数据库)备份controlfiel: backup current controlfile;Backup database incude current controlfile;Configure conctrolfile autobacup on;备份表空间： backup tablespace wspy;备份指定数据文件:select file_name,file_id,tablespace_name fromdba_data_filesbackup datafile n;第四讲、批命令批命令: run{Allocate channel cha1 type disk;BackupFormat “/u01/rmanbak/full_%t.bkp”Tag full-backupDatabase;Release channel cha1;} 第五讲、自动备份自动备份=备份脚本 + crontabBakl0 (baklevel0)Exp: run{Allocate channel cha1 type disk;BackupIncremental level 0Format “/u01/rmanbak/inc_%U_%T.bkp”Tag inc-backupDatabase;Release channel cha1;}Bakl1Bakl2Rman target / msglog=/u01/rmanbak/inc0.log cmdfile= /u01/rmanbak/scripts/bakl0;Crontab –e用户名: crontab –e -u oracle (root用户执行)编辑内容重新启动crontab：[root] service crond restart (crond是后台进程)附：RUN { CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO d:/backup/%F; ALLOCATE CHANNEL CH1 DEVICE TYPE DISK Format d:/backup/%U; BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10 PLUS ARCHIVELOG FILESPERSET 20 DELETE ALL INPUT;(not input all) RELEASE CHANNEL CH1; } ALLOCATE CHANNEL FOR M