ORACLE 數據庫RMAN備份恢復

還原不同位置的數據庫

機器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:oracleproduct10.2.0adminorcl
CREATE CONTROLFILE SET DATABASE “ORCL” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘E:ORACLEPRODUCT10.2.0ORADATAORCLREDO01.LOG’ SIZE 50M,
GROUP 2 ‘E:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG’ SIZE 50M,
GROUP 3 ‘E:ORACLEPRODUCT10.2.0ORADATAORCLREDO03.LOG’ SIZE 50M
— STANDBY LOGFILE
DATAFILE
‘E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF’,
‘E:ORACLEPRODUCT10.2.0ORADATAORCLUNDOTBS01.DBF’,
‘E:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBF’,
‘E:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBF’,
‘E:ORACLEPRODUCT10.2.0ORADATAORCLXM’
CHARACTER SET ZHS16GBK

機器B:
創建要恢復oracle的目錄
e:oracleproduct10.2.0oradataorcl
e:oracleproduct10.2.0admin
e:oracleproduct10.2.0falsh_recovery_area
把收到的文件夾orcl放到e:oracleproduct10.2.0admin
拷貝
e:oracleproduct10.2.0adminorclpfile中的參數文件到自己真實數據庫db_1database文件夾中，并改名為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:backORCL_2_20090414_FULL.BAK’;
cmd2:
alter database mount;
cmd3:
run{
set newname for datafile 1 to ‘E:oracleproduct10.2.0oradataorclSYSTEM01.DBF’;
set newname for datafile 2 to ‘E:oracleproduct10.2.0oradataorclUNDOTBS01.DBF’;
set newname for datafile 3 to ‘E:oracleproduct10.2.0oradataorclSYSAUX01.DBF’;
set newname for datafile 4 to ‘E:oracleproduct10.2.0oradataorclUSERS01.DBF’;
set newname for datafile 5 to ‘E:oracleproduct10.2.0oradataorclXM’;
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;