ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman恢復部分script

rman恢復部分script

原创 Linux操作系统 作者:chengxideng 时间:2012-02-02 08:29:40 0 删除 编辑

部分表空間不恢復
run {
allocate channel t1 type DISK parms="ENV=(NB_ORA_CLIENT=chengxi)";
set archivelog destination to '/opt/oracle/arch/';
restore database skip tablespace TEMP,USERS;
recover database skip forever tablespace USERS;
release channel c1;
}


恢復全庫
run {
allocate channel t1 type DISK parms="ENV=(NB_ORA_CLIENT=chengxi)";
set archivelog destination to '/opt/oracle/arch/';
restore database;
recover database;
release channel c1;
}


恢復控制文件
run{
allocate channel t1 type DISK;
send 'NB_ORA_SERV=nbutest01,NB_ORA_CLIENT=chengxi';
set archivelog destination to '/opt/oracle/arch/';
sql 'alter session set nls_date_format="yyyy-mm-dd hh24:mi:ss"';
restore controlfile until time '2010-07-14 02:00:00';
release channel t1;
}

恢復數據文件
run{
allocate channel ch00 type DISK;
send 'nb_ora_serv=nbutest01';
send 'nb_ora_client=chengxi';
restore datafile 0002;
release channel ch00;
}


恢復到時間點
run{
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=nbutest01,NB_ORA_CLIENT=standbydb';
sql 'alter session set nls_date_format="yyyy-mm-dd hh24:mi:ss"';
restore database until time '2010-08-25 10:00:00';
recover database until time '2010-08-25 10:00:00';
sql 'alter database open resetlogs';
release channel ch00;
}

恢復archivelog
run{ allocate channel c1 type disk;
restore archivelog all;
release channel c1;
}


run {
allocate channel t1 type 'sbt_tape' parms="ENV=(NB_ORA_CLIENT=old_host)";
set until time "to_date('06/30/02 13:00:00','MM/DD/YY HH24:MI:SS')"
restore database;
recover database;
sql 'alter database open resetlogs';
release channel t1;
}

control file是二进制文件,需要用"strings 控制文件名"来查看


ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP

恢復到某個scn
run{
set until scn 2595310;
restore database;
recover database;
alter database open resetlogs;
}


run{
allocate channel d1 type disk;
allocate channel d2 type disk;
set until sequence 41 thread 1;
recover database;
release channel d1;
release channel d2;
}

閃回恢復
alter database flashback on;

flashback database to timestamp to_timestamp('08/24/10 18:00:00','MM/DD/YY HH24:MI:SS');

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25402324/viewspace-715478/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 創建catalog
请登录后发表评论 登录
全部评论

注册时间:2011-02-18

  • 博文量
    19
  • 访问量
    11329