ORACLE数据库RMAN备份恢复

机器A:
selectinstance_namefromv$instance;
selectnamefromv$database;
selectnamefromv$datafile;
查询日志模式：
archiveloglist;
shutdownimmediate;
startupmount;
把日志改为归档模式：
alterdatabasearchivelog;
alterdatabaseopen;
altersystemarchivelogcurrent;
selectnamefromv$archived_log;
打开控制文件跟踪：
alterdatabasebackupcontrolfiletotrace;
查看跟踪文件位置：
showparameteruser_dump_dest
cmd：
setoracle_sid=orcl
rmantargetsys/abc
host"mdc:\back";
run
{
backupdatabase;
format"c:\back\%d_%s_%T_full.bak";
}
selectfile#,namefromv$datafile;
传送以下文件到机器B:
c:\back
d:\oracle\product\10.2.0\admin\orcl
CREATECONTROLFILESETDATABASE"ORCL"RESETLOGSARCHIVELOG
MAXLOGFILES16
MAXLOGMEMBERS3
MAXDATAFILES100
MAXINSTANCES8
MAXLOGHISTORY292
LOGFILE
GROUP1"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG"SIZE50M,
GROUP2"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG"SIZE50M,
GROUP3"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG"SIZE50M
--STANDBYLOGFILE
DATAFILE
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF",
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF",
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF",
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF",
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\XM"
CHARACTERSETZHS16GBK

机器B:
创建要恢复oracle的目录
e:\oracle\product\10.2.0\oradata\orcl
e:\oracle\product\10.2.0\admin
e:\oracle\product\10.2.0\falsh_recovery_area
把收到的文件夹orcl放到e:\oracle\product\10.2.0\admin
拷贝
e:\oracle\product\10.2.0\admin\orcl\pfile中的参数文件到自己真实数据库db_1\database文件夹中，并改名为initorcl.ora
打开initorcl.ora
把里面的路径改为真实oracle数据库的位置
d:\替换为e:\
cmd1：
setoracle_sid=orcl
oracleorcl
等到提示ctrl+c
cmd2：
setoracle_sid=orcl
sqlplus/assysdba
startupnomount;
cmd3:
setoracle_sid=orcl
rmantargetsys/abc
restorecontrolfilefrom"C:\back\ORCL_2_20090414_FULL.BAK";
cmd2:
alterdatabasemount;
cmd3:
run{
setnewnamefordatafile1to"E:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF";
setnewnamefordatafile2to"E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF";
setnewnamefordatafile3to"E:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF";
setnewnamefordatafile4to"E:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF";
setnewnamefordatafile5to"E:\oracle\product\10.2.0\oradata\orcl\XM";
restoredatabase;
switchdatafileall;
}
cmd2:
selectnamefromv$database;
shutdownimmediate;
startupmount;
alterdatabasebackupcontrolfiletotrace;
找到跟踪文件：
重做控制文件：把里面的路径改为正确路径：
d:\改为e:\
shutdownimmediate;
startupnomount;
执行生成控制文件的语句;执行钱必须先删除.ctl的文件
alterdatabaseopenresetlogs;
selectnamefromv$database;
selectmemberfromv$logfile;