RMAN命令的傻瓜用法.doc

2006.11.23 19:37 作者：一剑封喉 | 评论：3 | 阅读：5912 rman target sys/adminORCL nocataloglist backup;命令去找出无效的备份级并删除report OBSOLETE RECOVERY WINDOW OF 4 DAYS;删除备份delete obsolete recovery window of 1 days;delete obsolete；delete expired backup; delete backupset id;delete backup；删除全部归档日志delete archivelog all;删除全部归档日志run allocate channel c1 type disk; delete archivelog all; release channel c1; 数据库完全备份backup database;RMAN run 2 # backup the complete database to disk 3 allocate channel dev1 type disk; 4 backup 5 full 6 tag full_db_backup 7 format /oracle/backups/db_t%t_s%s_p%p 8 (database); 9 release channel dev1; 10 恢复数据库restore database;recover database;备份表空间RMAN run 2 allocate channel dev1 type disk; 3 backup 4 tag tbs_users_read_only 5 format /oracle/backups/tbs_users_t%t_s%s 6 (tablespace users) 7 RMAN list backupset of tablespace users;.备份单独数据文件RMAN run 2 allocate channel dev1 type SBT_TAPE; 3 backup 4 format %d_%u 5 (datafile /oracle/dbs/sysbigdb.dbf); 6 release channel dev1; 7 2: 使用MML（media manager layer）分配磁带驱动器，必须指定类型为SBT_TAPE；使用下面的命令显示恢复目录中备份的表空间：RMAN list backupset of datafile 1;备份表空间和数据文件RMAN backup tablespace users,tools;RMAN backup datafile 1,2,3,4RMAN backup datafile ./users.dbf;RMAN backup datafile ./system01.dbf备份控制文件show controlfile autobackup;RMAN backup current controlfileRMAN backup device tablespace users include current controlfile;恢复控制文件restore controlfile to /tmp/control01.ctl from autobackup;restore controlfile from E:oracleproduct10.1.0flash_recovery_areaORCLBACKUPSET2006_12_01O1_MF_NCNNF_TAG20061201T134849_2PZJL4TC_.BKP备份归档日志文件和参数文件RMAN backup archivelog all;RMAN backup device type tape archivelog all delete allinputRMAN backup spfile;完全备份增量备份备份级别分为full,0,1,.9RMAN backup full databaseRMAN backup incremental level 1 tablespace tools备份集tag:表示一次特定的备份format:指定备份产生的文件的名称例如：backup full tablespace TEST tag aaaa format /tmp/%U;可用的变量%a 数据库的ID%d数据库的名称%e归档日志序列号我们平时都是使用手工进行删除归档日志的,但手工删除后,在数据库中并没有被标志被删除,所以,这时还需要使用RMAN进行操作.具体如下:1.crosscheck archivelog