一恢复参数文件

方法：直接从源端create pfile='/tmp/pfileorcl.ora' from spfile;

启动数据库到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;

Database altered.

oracle 异机恢复