oracle 异机恢复

一 恢复参数文件     方法：直接从源端create pfile='/tmp/pfileorcl.ora' from spfile;              scp之后，修改对应目录，创建目录       启动数据库到nomount状态 二 恢复控制文件  2.1 恢复control01.ctl RMAN> restore controlfile to '/oradata/orcl/control01.ctl'from '/home/oracleback/control_ORCL_20221109_10928'; Starting restore at 10-NOV-22 using channel ORA_DISK_1 channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 10-NOV-22 2.2 恢复control02.ctl RMAN>  restore controlfile to '/oradata/orcl/control02.ctl'from '/home/oracleback/control_ORCL_20221109_10928'; Starting restore at 10-NOV-22 using target database control file ins tead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2186 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 10-NOV-22 2.3 启动数据库到mount状态 RMAN> alter database mount; database mounted released channel: ORA_DISK_1 三    set newname 重新指定路径  3.1 源库查看datafiles路径 FILE# NAME---------- ----------------------------------------------------------------- 1 /oradata/orcl/system01.dbf 2 /oradata/orcl/sysaux01.dbf 3.2 执行run 命令 run {     allocate channel d1 type disk;     set newname for datafile 1 to '/home/oracle/oradata/orcl/system01.dbf';      set newname for datafile 2 to '/home/oracle/oradata/orcl/sysaux01.dbf';     set newname for datafile 3 to  '/home/oracle/oradata/orcl/KTS_kd_ump_kytz.dbf';     set newname for datafile 4 to  '/home/oracle/oradata/orcl/users01.dbf';     set newname for datafile 5 to  '/home/oracle/oradata/orcl/KTS_KD_COM_DX.DBF';     set newname for datafile 6 to '/home/oracle/oradata/orcl/KTS_KD_SALE_DX.DBF';      set newname for datafile 7 to '/home/oracle/oradata/orcl/KTS_KD_HIS_DX.DBF';     set newname for datafile 8 to '/home/oracle/oradata/orcl/KTS_KD_BANK_DX.DBF';     set newname for datafile 9 to  '/home/oracle/oradata/orcl/KFCS.DBF';     set newname for datafile 10  to  '/home/oracle/oradata/orcl/kfbs.dbf';     set newname for datafile 11 to  '/home/oracle/oradata/orcl/undotbs101.dbf';     set newname for datafile 12 to '/home/oracle/oradata/orcl/JR_KRDT_TBS.DBF';      set newname for datafile 13 to  '/home/oracle/oradata/orcl/JR_SMARTBI_TBS.DBF';     set newname for datafile 14 to  '/home/oracle/oradata/orcl/KTS_KD_UMP.dbf';     set newname for datafile 15 to  '/home/oracle/oradata/orcl/system02.dbf';    set newname for datafile 16  to  '/home/oracle/oradata/orcl/sysaux02.dbf';     set newname for datafile 17 to  '/home/oracle/oradata/orcl/KTS_kd_ump_kytz01.dbf';     set newname for datafile 18 to  '/home/oracle/oradata/orcl/KTS_KD_UMP_WSJY.dbf';restore database;release channel d1;switch datafile all;} 4 执行revovery命令 SQL> alter database open resetlogs; SQL> alter database open resetlogs; Database altered.