機器A: select instance_name from v$instance; select name from v$database; select name from v$datafile; 查詢日志模式： archive log list; shutdown immediate; startup mount; 把日志改為歸檔模式： alter database archivelog; alter database open; alter system archive log current; select name from v$archived_log; 打開控制文件跟蹤： alter database backup controlfile to trace; 查看跟蹤文件位置： show parameter user_dump_dest cmd： set oracle_sid=orcl rman target sys/abc host "md c:\back"; run { backup database; format 'c:\back\%d_%s_%T_full.bak'; } select file#,name from v$datafile; 傳送以下文件到機器B: c:\back d:\oracle\product\10.2.0\admin\orcl CREATE CONTROLFILE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG' SIZE 50M, GROUP 2 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG' SIZE 50M, GROUP 3 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG' SIZE 50M -- STANDBY LOGFILE 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' CHARACTER SET ZHS16GBK
機器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： set oracle_sid=orcl oracle orcl 等到提示ctrl+c cmd2： set oracle_sid=orcl sqlplus / as sysdba startup nomount; cmd3: set oracle_sid=orcl rman target sys/abc restore controlfile from 'C:\back\ORCL_2_20090414_FULL.BAK'; cmd2: alter database mount; cmd3: run{ set newname for datafile 1 to 'E:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF'; set newname for datafile 2 to 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF'; set newname for datafile 3 to 'E:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF'; set newname for datafile 4 to 'E:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'; set newname for datafile 5 to 'E:\oracle\product\10.2.0\oradata\orcl\XM'; restore database; switch datafile all; } cmd2: select name from v$database; shutdown immediate; startup mount; alter database backup controlfile to trace; 找到跟蹤文件： 重做控制文件：把里面的路徑改為正確路徑： d:\改為 e:\ shutdown immediate; startup nomount; 執行生成控制文件的語句;執行錢必須先刪除.ctl的文件 alter database open resetlogs; select name from v$database; select member from v$logfile;
