Oracle：Rman命令大全

3大备份工具： sqlplus + rman + export

 

http://space.itpub.net/23754390/viewspace-670336

 

http://liurizhaooracle.blog.163.com/blog/static/1231108722010111694845719/

 

数据文件：backup datafile 4,5/tablespace users,indexes format  '/u01/app/oracle/backup/orcl/orcl_%u' tag='datafile';

 

控制文件：backup current controlfile format '' tag='controlfile';

               sql " alter  database backup controlfile to trace as ' '/tmp/controlfile.sql' ' " ;

 

参数文件：backup spfile format '' tag='spfile';

 

归档文件：backup archivelog all delete all input format '' tag='archivelog';

 

全备份：backup as compressed backupset database plus archivelog delete all input format '' tag='fullbackup';

 

零级备份：backup incremental level 0 database format '' tag='level 0';

 

差异备份：backup incremental level 1 differential database format '' tag='level 1 diff';

               sql " alter system archive log current ";

 

累计备份：backup incremental level 1 cumulative database format '' tag='level 1 cumu';

               sql " alter system archive log current ";

 

=========================================================================================

51
Rman归档恢复：
1.mount下恢复：
       Using Rman in archivelog: startup mount;
                                 restore database;
                                 recover database;(使用日志文件恢复数据库)
                                 alter database open;
                      
   

2.open下恢复：                        
            数据文件: run{
                          sql 'alter database datafile 6 offline';
                          restore datafile 6;
                          recover datafile 6;
                          sql 'alter database datafile 6 online;
                         }
             表空间 ：run{
                          sql 'alter tablespace users offline immediate';
                          restore tablespace users;
                          recover tablespace users;
                          sql 'alter tablespace users online;
                         }          
 
         

restore to a new location: run{
                              set newname for datafile 6 to '/u01/oradata/app2.mdf';
                              restore database;
                              switch datafile all; (更新控制文件信息)
                              recover database;
                              alter database open;
                              }

3.控制文件无法mount下恢复：restore controlfile from '备份集名称' to                                                       '/opt/ora10/oradata/orcl/control01.ctl'
                           或者restore controlfile from autobackup;
                           或者restore controlfile(必须有连上catalog)
 
  spfile文件在无法nomount下恢复：restore spfile from '' to '/opt/ora10/dbms/dbs/spfileorcl.ora';
                                 或者restore controlfile from autobackup;
                                 或者restore controlfile(必须有连上catalog)

 

54
Rman不完全恢复：
 
  until time: mount;
               run{
                   allcate channel c1 type disk;
                   allcate channel c2 type disk;
                   allcate channel c3 type disk;
                   set until time "to_date('2011-05-19 01:38:49','yyyy-mm-dd hh24:mi:ss')";
                   restore database;
                   recover database;
                   alter database open resetlogs;
                   }
               
 until sequence:mount;
                run{
                    set until sequence 120 thead 1;
                    restore database;
                    recover database; #recovers through log 119,not including 120
                    alter database open resetlogs;
                    }

 

=============================================================================================================================

 

使用rman进行跨平台数据迁移

http://space.itpub.net/15779287/viewspace-678416

 

 

利用RMAN修复坏块

http://space.itpub.net/25937377/viewspace-704846

http://www.itpub.net/thread-991044-1-1.html