oracle数据库管理-常用脚本rman恢复

1 rman转化脚本

RMAN> CONVERT DATAFILE

2>'C:\Temp\sales_101.dbf',

3>'C:\Temp\sales_201.dbf'

4>TO PLATFORM="Microsoft Windows IA (32-bit)"

5>FROM PLATFORM="Solaris[tm] OE (32-bit)"

6>DB_FILE_NAME_CONVERT=

7>'C:\Temp\','C:\app\orauser\oradata\orawin\'

8> PARALLELISM=4;

 

>rman target /
RMAN> convert tablespace ‘表空间名’
to platform=’目标平台‘
db_file_name_convert=’数据文件位置’,’转换后的位置’;
如：将HP-UX (64-bit) Big 转换成Linux IA (64-bit) Little
RMAN> convert tablespace ‘test1’ 
to platform=’Linux IA (64-bit)’ db_file_name_convert=’/u01/oradata/test01.dbf’,’/temp/test01.dbf’;

2 常用rman恢复脚本

restore archivelog all

restore archivelog from logseq 6160 thread 2

恢复从第5个归档日志起
restore archivelog from logseq 5;
只恢复 5到10这四个归档日志文件
restore archivelog from logseq 5 until logseq 10;
恢复7天内的归档日志--默认恢复所有线程的日志。
restore archivelog from time 'sysdate-7';

run{
set archivelog destination to '/soft/arc';
}

 

run{
set archivelog destination to '/soft/arc';
restore archivelog all;
}

恢复控制文件
RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'

parms="ENV=(NB_ORA_SERV=KGNBU01,NB_ORA_CLIENT=t4)";

SEND 'NB_ORA_SERV=K,NB_ORA_CLIENT=t4';

RESTORE controlfile from '&BACKUPSETNAME_CONTROLFILEBAKPP';

RELEASE CHANNEL ch00;

}

恢复数据库
RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

SEND 'NB_ORA_SERV=K,NB_ORA_CLIENT=t4';

RESTORE database ;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}

基于RPO恢复数据库
RUN {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

SEND 'NB_ORA_SERV=K,NB_ORA_CLIENT=t4';

RECOVER database UNTIL TIME  TO_DATE(&TIMESTAMP,’YYYY-MM-DD HH24:MI:SS’);

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}
 

 

 

NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'; export NLS_DATE_FORMAT
ORACLE_SID=htqd1; export ORACLE_SID
rman target /  nocatalog <<EOF
run {
SET UNTIL TIME '2014/06/30 14:00:00';
ALLOCATE CHANNEL ch00;
set newname for datafile 1 to '/htqdbak_huawei/htqdbak/rlv3system01';
set newname for datafile 2 to '/htqdbak_huawei/htqdbak/rlv3undotbs11';
set newname for datafile 3 to '/htqdbak_huawei/htqdbak/rlv3undotbs21';
set newname for datafile 72 to '/htqdbak_huawei/htqdbak/rlv3htqd10g005';
set newname for datafile 73 to '/htqdbak_huawei/htqdbak/rlv3htqd4g042';
set newname for datafile 74 to '/htqdbak_huawei/htqdbak/rlv3htqd4g043';
set newname for datafile 75 to '/htqdbak_huawei/htqdbak/rlv3htqd4g044';
set newname for datafile 89 to '/htqdbak_huawei/htqdbak/rlv3htqd4g080';
set newname for datafile 90 to '/htqdbak_huawei/htqdbak/rlv3htqd4g081';
set newname for datafile 91 to '/htqdbak_huawei/htqdbak/rlv3htqd4g082';
set newname for datafile 92 to '/htqdbak_huawei/htqdbak/rlv3htqd4g083';
set newname for datafile 93 to '/htqdbak_huawei/htqdbak/rlv3htqd4g075';
set newname for datafile 152 to '/htqdbak_huawei/htqdbak/rlv3htqd4g142';
set newname for datafile 153 to '/htqdbak_huawei/htqdbak/rlv3htqd4g143';
set newname for datafile 154 to '/htqdbak_huawei/htqdbak/rlv3htqd4g144';
set newname for datafile 155 to '/htqdbak_huawei/htqdbak/rlv3htqd4g145';
set newname for datafile 226 to '/htqdbak_huawei/htqdbak/rlv3htqd4g190';
set newname for datafile 262 to '/htqdbak_huawei/htqdbak/rlv3htqd10g062';
set newname for datafile 275 to '/htqdbak_huawei/htqdbak/rlv3htqd10g075';
set newname for datafile 356 to '/htqdbak_huawei/htqdbak/rlv3htqd10g161';
set newname for datafile 357 to '/htqdbak_huawei/htqdbak/rlv3htqd10g162';
set newname for datafile 358 to '/htqdbak_huawei/htqdbak/rlv3htqd10g163';
set newname for datafile 426 to '/htqdbak_huawei/htqdbak/rlv3htqd10g239';
set newname for datafile 454 to '/htqdbak_huawei/htqdbak/rlv3htqd10g265';
set newname for datafile 525 to '/htqdbak_huawei/htqdbak/rlv3htqd10g337';
restore database skip tablespace HTQD2_DAT,HTQD2_IDX,HTQD2_SB_DAT,HTQD2_SB_IDX,HTQD2_FP_DAT,HTQD2_CX_TMP,HTQD2_GLFW_DAT,HTQD2_FP_IDX,HTQD2_JK_IDX,HTQD2_GLFW_IDX,HTQD2_MAINT_DAT,SJCF_CS_DAT ;
switch datafile all;
recover database skip tablespace HTQD2_DAT,HTQD2_IDX,HTQD2_SB_DAT,HTQD2_SB_IDX,HTQD2_FP_DAT,HTQD2_CX_TMP,HTQD2_GLFW_DAT,HTQD2_FP_IDX,HTQD2_JK_IDX,HTQD2_GLFW_IDX,HTQD2_MAINT_DAT,SJCF_CS_DAT ;
release channel ch00;
}