实战班RMAN备份恢复实习指导.doc

CUUG数据库实战班 Rman备份与恢复实习指导 Rman与目标数据库的连接 1)没有目录服务器的连接 rman target / nocatalog RMANalter database mount; 2)连接到远程目标数据库 % rman NOCATALOG RMAN CONNECT TARGET sys/change_on_install@prod1; 3)连接到目标数据库并连接到目录数据库 % rman RMAN CONNECT TARGET / RMAN CONNECT CATALOG rman/rman@rcat 4)连接到目标数据库、目录数据库、辅助数据库 % rman RMAN CONNECT TARGET SYS/sysdba@prod1 RMAN CONNECT CATALOG rman/rman@rcat RMAN CONNECT AUXILIARY SYS/sysdba@dupdb 5)连接到远程目标数据库与目录数据库 #rman target sys/change_on_install@db160 catalog rman/rman@db01 Rman配置： 1)Configure automatic channels: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT /db01/BACKUP/%U; 2)Implement retention policy by specifying a recovery window: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 days; 3)Implement retention policy by specifying redundancy: CONFIGURE RETENTION POLICY TO REDUNDANCY 2; 4)Check what backup set was obsolete： REPORT OBSOLETE； 5) DELETE backup set about OBSOLETE： DELETE OBSOLETE； 5)Configure duplexed backup sets: CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE disk TO 2; 6)Configure backup optimization: CONFIGURE BACKUP OPTIMIZATION ON; 7)Use the CLEAR option to return to the default value: CONFIGURE RETENTION POLICY CLEAR; CONFIGURE CHANNEL DEVICE TYPE sbt CLEAR; 8)Automatic channel configuration settings SHOW CHANNEL; SHOW DEVICE TYPE; SHOW DEFAULT DEVICE TYPE; 9)RMAN retention policy configuration settings SHOW RETENTION POLICY; 10)Number of backup copies SHOW DATAFILE BACKUP COPIES; 11)Maximum size for backup sets SHOW MAXSETSIZE; 12)Tablespaces excluded from whole database backups SHOW EXCLUDE; 13)Status of backup optimization SHOW BACKUP OPTIMIZATION; 14)show all configure show all； 15)List backups of all files in the database: LIST BACKUP OF DATABASE; 16)List all backup sets containing the users01.dbf datafile: LIST BACKUP OF DATAFILE /db01/ORADATA/u03/users01.dbf; 17)List all copies of datafiles in the SYSTEM LIST COPY OF TABLESPACE SYSTEM; 18)What is the structure of the database? REPORT SCHEMA; 19)Which files need to be b