ORACLE RAC 异机RMAN恢复

1、源端数据库全备
export DBNAME=orcl
export ORACLE_SID=orcl1 
export ORACLE_BASE=/u01/app/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1 
export PATH=$ORACLE_HOME/bin:$HOME/bin:$PATH 
export BACPATH=/backup/
export LGNAME=rman_backup_`date "+%Y-%m-%d"`.log
rman target / > ${
   BACPATH}/${
   LGNAME} << EOF 
run{
   
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE CONTROLFILE AUTOBACKUP ON; 
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '${BACPATH}/${DBNAME}_ful_%U';  
ALLOCATE CHANNEL c1 DEVICE TYPE DISK; 
BACKUP FUll DATABASE format '${BACPATH}/${DBNAME}_ful_data_file_%d_%T_%s_%p_%u';
sql 'alter system archive log current';
backup archivelog all format '${BACPATH}/${DBNAME}_arc_%U';
backup current controlfile format '${BACPATH}/${DBNAME}_ctl_%U';
backup spfile format '${BACPATH}/${DBNAME}_spf_%U';
release channel c1;
}
quit
EOF
2、源端根据spfile创建pfile文件

sqlplus / as sysdba
SQL> create pfile='/home/oracle/init0703.ora' from spfile='+DATA/orcl/spfileorcl.ora';
File created.



cat pfile='/home/oracle/init0703.ora'

orcl2.__db_cache_size=507879882752
orcl1.__db_cache_size=498216206336
......
orcl2.undo_tablespace='UNDOTBS2'
orcl1.undo_tablespace='UNDOTBS1'



3. 目标创建必要的目录
-- 在 oracle 用户下创建(所有节点执行)
$ su - oracle
$ mkdir -p /u01/app/oracle/admin/orcl/adump

-- 在目标端 grid 用户下在共享设备创建必要的目录（单节点执行即可）
[grid@adg2 ~]$asmcmd
ASMCMD> ls
DATA/
FRA/
OCR/
ASMCMD> cd DATA
ASMCMD>ls
ASMCMD>mkdirorcl
ASMCMD> cd orcl
ASMCMD> ls
ASMCMD>mkdir CONTROLFILE
ASMCMD>mkdir DATAFILE
ASMCMD>mkdir ONLINELOG
ASMCMD>mkdir PARAMETERFILE

ASMCMD> cd FRA
ASMCMD> ls
ASMCMD>mkdirorcl
ASMCMD> cd orcl
ASMCMD> ls             
ASMCMD>mkdir ARCHIVELOG
ASMCMD



4. 参数文件修改
将源端参数文件传到在目标端并编辑 /home/oracle/init0703.ora (参数根据实际情况进行配置)
$ vi /home/oracle/init0703.ora
orcl2.__db_cache_size=507879882752
orcl1.__db_cache_size=498216206336
......
orcl2.undo_tablespace='UNDOTBS2'
orcl1.undo_tablespace='UNDOTBS1'
# 这里增加时间格式，按照时间点进行还原时会用到
*.nls_date_format='yyyymmddhh24:mi:ss'



5. 创建spfile
在目标端用上述编辑的 pfile.ora 在共享设备上创建spfile
$ sqlplus / as sysdba
SQL> create spfile='+DATA/orcl/spfileorcl.ora' from pfile='/home/oracle/pfile_0702.ora';

File created.

-- 在所有节点上创建 pfile 内容指向共享设备上的spfile文件
节点1：
$[oracle@adg1 ~]$ echo "SPFILE='+DATA/orcl/spfileorcl.ora' " > /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl1.ora
[oracle@adg1 ~]$ cat /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl1.ora 
SPFILE='+DATA/orcl/spfileorcl.ora' 

节点2：
$[oracle@adg1 ~]$ echo "SPFILE='+DATA/orcl/spfileorcl.ora' " > /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl2.ora
[oracle@adg2 ~]$ cat /u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl2.ora
SPFILE='+DATA/orcl/spfileorcl.ora'

6. 创建口令文件
节点1：
$ orapwd file=$ORACLE_HOME/dbs/orapworcl1 password=oracle
节点2
$ orapwd file=$ORACLE_HOME/dbs/orapworcl2 password=oracle

7. 还原控制文件
（在一个节点上执行）
-- 数据库启动到 nomount
$ sqlplus / as sysdba
SQL> startup nomount
ORACLE instance started.
Total System Global Area 6062931968 bytes
Fixed Size                  2264376 bytes
Variable Size            3305112264 bytes
Database Buffers         2734686208 bytes
Redo Buffers               20869120 bytes


8. 查看监听状态
[oracle@adg1 ~]$lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-JUL-2020 01:43:39

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                03-JUL-2020 08:21:08
Uptime                    0 days 17 hr. 22 min. 33 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.4/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/adg1/listener/alert/log.xml
Listening Endpoints Summary...
  (DE