笔记：Oracle rman异地恢复小例

安装数据库软件（略）

修改参数文件

*.audit_file_dest='D:\app\Administrator\diag\adump'
*.audit_trail='DB'
*.compatible='11.2.0.0.0'
*.control_files='D:\oradata\orcl\CONTROL01.CTL'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='D:\flash_recovery_area'
*.db_recovery_file_dest_size=21474836480
*.diagnostic_dest='D:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='location=D:\arch'
*.memory_target=1728053248
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

windows添加服务（若需要）

1，设定环境变量
set ORACLE_SID=orcl
set ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1
2，创建windows服务
D:\app\Administrator\product\11.2.0\dbhome_1\BIN\oradim  -new -sid orcl 

现在就可以进入空闲实例了

根据参数文件启动nomount

SQL> startup nomount pfile='D:\bak\pfile.ora';
ORACLE 例程已经启动。

Total System Global Area 1720328192 bytes
Fixed Size                  2281952 bytes
Variable Size            1056968224 bytes
Database Buffers          654311424 bytes
Redo Buffers                6766592 bytes
SQL>

恢复控制文件并启动到mount

C:\Users\Administrator>rman target /

恢复管理器: Release 11.2.0.4.0 - Production on 星期四 6月 27 16:05:37 2024

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

已连接到目标数据库: ORCL (未装载)

RMAN> restore controlfile  from 'D:\bak\CTL_ORCL_20240627_15108_1';

启动 restore 于 27-6月 -24
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=63 设备类型=DISK

通道 ORA_DISK_1: 正在还原控制文件
通道 ORA_DISK_1: 还原完成, 用时: 00:00:01
输出文件名=D:\ORADATA\ORCL\CONTROL01.CTL
完成 restore 于 27-6月 -24

RMAN> alter database mount;

数据库已装载
释放的通道: ORA_DISK_1

RMAN>

恢复数据库

1，注册备份信息（若需要）

CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;

catalog start with 'D:\bak';

2，修改文件路径至新路径（若需要）

在rman恢复脚本中restore前添加：

set newname for datafile 23 to '+DATADG';

select 'set newname for datafile '||file_id||' to '''||file_name||''';' from dba_data_files;
select 'set newname for tempfile '||file_id||' to '''||file_name||''';' from dba_temp_files;

3，数据库恢复

rman target / <<EOF
run{ 
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;       
allocate channel c4 type disk;
restore database;
switch datafile all;
switch tempfile all;
recover database;
}
EOF

4，重建日志文件

alter database rename file 'D:\PROGRAMFILES\APP\ADMIN\ORADATA\ORCL\REDO03.LOG' to 'D:\oradata\orcl\REDO03.LOG';

select 'alter database rename file '''||member||'''to '''||member||''';' from v$logfile;

5，启动数据库

alter database open resetlogs;