Oracle 11g单实例RMAN恢复到Oracle 11g RAC(2)

日期：2020-06-02 栏目：程序人生浏览：次

GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB
------------ ---------- ---------- ------------ ---------- ----------
1 CRS MOUNTED NORMAL 30720 29794
2 DATA MOUNTED EXTERN 40960 39032
3 RECOVERY MOUNTED EXTERN 25952 24758

2. 检查备份集目录以及文件权限

[root@db1 u01]# chown -R oracle:oinstall /u01/orabak
[root@db1 u01]# ll -h /u01/orabak/
total 1.4G
-rw-r----- 1 oracle oinstall 16M Sep 16 14:48 arch_ORCL_20170916_5_1
-rw-r----- 1 oracle oinstall 3.5K Sep 16 14:48 arch_ORCL_20170916_6_1
-rw-r----- 1 oracle oinstall 2.5K Sep 16 14:48 arch_ORCL_20170916_7_1
-rw-r--r-- 1 oracle oinstall 4.8K Sep 16 14:48 backup_all_20170916.log
-rw-r----- 1 oracle oinstall 9.4M Sep 16 14:48 ctl_ORCL_20170916_8_1
-rw-r----- 1 oracle oinstall 707M Sep 16 14:48 full_ORCL_20170916_1_1
-rw-r----- 1 oracle oinstall 642M Sep 16 14:48 full_ORCL_20170916_2_1
-rw-r----- 1 oracle oinstall 9.4M Sep 16 14:48 full_ORCL_20170916_3_1
-rw-r----- 1 oracle oinstall 96K Sep 16 14:48 full_ORCL_20170916_4_1
-rw-r--r-- 1 oracle oinstall 1.1K Sep 16 14:48 pfile20170916.ora

3. 查看集群状态

[grid@db1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE db1
ONLINE ONLINE db2
ora.DATA.dg
ONLINE ONLINE db1
ONLINE ONLINE db2
ora.LISTENER.lsnr
ONLINE ONLINE db1
ONLINE ONLINE db2
ora.RECOVERY.dg
ONLINE ONLINE db1
ONLINE ONLINE db2
ora.asm
ONLINE ONLINE db1 Started
ONLINE ONLINE db2 Started
ora.gsd
OFFLINE OFFLINE db1
OFFLINE OFFLINE db2
ora.net1.network
ONLINE ONLINE db1
ONLINE ONLINE db2
ora.ons
ONLINE ONLINE db1
ONLINE ONLINE db2
ora.registry.acfs
ONLINE ONLINE db1
ONLINE ONLINE db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE db1
ora.cvu
1 ONLINE ONLINE db2
ora.db1.vip
1 ONLINE ONLINE db1
ora.db2.vip
1 ONLINE ONLINE db2
ora.oc4j
1 ONLINE ONLINE db2
ora.orcl.db
1 ONLINE ONLINE db1 Open
2 ONLINE ONLINE db2 Open
ora.scan1.vip
1 ONLINE ONLINE db1

4. 关闭集群参数并关闭数据库实例准备恢复

$ sqlplus / as sysdba;

SQL> alter system set cluster_database=true scope=spfile sid='*';

$ srvctl stop database -d orcl

四、目标服务器上恢复数据 1. 启动到nomount状态

[oracle@db1 ~]$ su - oracle
[oracle@db1 ~]$ sqlplus / as sysdba

转载注明出处：https://www.heiqu.com/aa77a59583b6c95f5802bacd557127d5.html

Oracle 11g单实例RMAN恢复到Oracle 11g RAC(2)

相关推荐