rman使用小记.doc

/docs/cd/B10501_01/server.920/a96566/toc.htm Introduction to Recovery Manager 3个重要的特点： 在线热备不需要ALTER TABLESAPCE … BEGIN BACKUP or END BACKUP，并且不会产生更多日志 Incremental backups and restores. Can recover a NOARCHIVELOG database. However, only take incremental backups of a NOARCHIVELOG database after a consistent shutdown. 只备份HWM以下的blocks 检测数据库坏块(interruption blocks), Computes checksums for each block during a backup Tests whether files can be backed up or restored without actually performing the backup or restore. Overview of the RMAN Environment RMAN executable （必须的） Target database （必须的） Recovery catalog database Media management software Connecting to Databases with RMAN Starting RMAN: Overview 连接3种数据库： % rman TARGET SYS/oracle@trgt CATALOG rman/cat@catdb --rman用户需要RECOVERY_CATALOG_OWNER 角色 % rman TARGET SYS/oracle@trgt NOCATALOG --目标数据库用户需要sysdba权限，因为是默认，所以不用额外注明as sysdba。NOCATALOG 是默认形式，一旦使用了这种形式，就不能在连接catalog了。 % rman TARGET / CATALOG rman/cat@catdb AUXILIARY SYS/oracle@auxdb 或者： % rman RMAN CONNECT TARGET SYS/oracle@trgt RMAN CONNECT CATALOG rman/cat@catdb 连接RAC(3个instance): % rman TARGET SYS/oracle@trgt2 CATALOG rman/cat@catdb CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE DEVICE TYPE sbt PARALLELISM 3; CONFIGURE CHANNEL 1 DEVICE TYPE sbt CONNECT = SYS/oracle@trgt1; CONFIGURE CHANNEL 2 DEVICE TYPE sbt CONNECT = SYS/oracle@trgt2; CONFIGURE CHANNEL 3 DEVICE TYPE sbt CONNECT = SYS/oracle@trgt3; BACKUP DATABASE; Quick Start to Recovery Manager 参考?/rdbms/demo/*.rcv RMAN基本命令(NOCATALOG mode) Connecting to the Target Database % rman target sys/admin@donnydb2 可以在rman中操作数据库 RMAN STARTUP MOUNT 产生schema reports RMAN report schema; 备份数据库 有2中方式：full(all blocks. datafiles, controlfile, parameter file) 和 incremental(only the blocks that have changed since a previous backup) Full Backup: RMAN BACKUP DATABASE; 默认device type 是disk，除非用configure 配置其到tape Incremental Backup RMAN BACKUP INCREMENTAL LEVEL 1 DATABASE; 差异增量，累计增量。 RMAN compares the current datafiles to a base backup