oracle rman备份恢复练习讲义教材.ppt

RMAN configure channel 1 device type disk clear;清楚通道1 RMAN configure channel device type disk clear;清楚所有通道 * RMANCONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT /bak/rman/backup_%U‘ MAXPIECESIZE 100M; * RMANconfigure maxsetsize to 7500K； 使用的时候要非常小心，超出这个大小，备份不成功，会报错，强烈建议不要指定它的大小 * RMAN configure controlfile autobackup on;---配置控制文件自动备份 new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored RMAN configure controlfile autobackup format for device type disk to /bak/contf/ecoalchina_%F; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/bak/contf/ecoalchina_%F’;---自动备份控制文件到指定位置 new RMAN configuration parameters are successfully stored * configure device type disk parallelism 2 * RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 3;---保存3个备份-----备份冗余备份保存策略-----很少备份的情况下 RMANCONFIGURE RETENTION POLICY TO RECOVERY WINDOWS OF 7 DAYS;----------保存7天的备份----恢复窗口备份保存策略 可以与change命令一起使用 * RMANCONFIGURE EXCLUDE FOR TABLESPACE XXX; * RMANCONFIGURE BACKUP OPTIMIZATION ON; 启动了备份优化，oracle会默认不备份没有发生变化的表空间-----如只读表空间 RMANBACKUP DATABASE FORCE;强制备份包含只读表空间的所有文件。 * SQL create tablespace catalog_tbs datafile /dat/DBData/oradata/NACEC/catalog.dbf size 20M; Tablespace created. SQL CREATE USER RCAT_USER IDENTIFIED BY ecoalchina default tablespace catalog_tbs quota unlimited on catalog_tbs; User created. SQL grant connect,resource,recovery_catalog_owner to rcat_user; Grant succeeded. RMAN connect catalog rcat_user/ecoalchina connected to recovery catalog database RMAN create catalog; recovery catalog created [oracle@localhost ~]$ rman target / catalog rcat_user/ecoalchina----连接目标数据库及恢复目录 Recovery Manager: Release 10.2.0.4.0 - Production on Wed Mar 19 08:26:09 2014 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: NACEC (DBID=364029283) connected to recovery catalog database RMAN register database;----在恢复目录中注册数据库 取消数据库注册使用 RMAN u