如何把Oracle 数据库从 RAC 集群迁移到单机环境_oracle_

db_name：hisdb SID：hisdb1、hisdb2 IP: 192.168.1.101、192.168.1.102 os：CentOS Linux release 7.3.1611 (Core)

IP: 192.168.1.15 os：CentOS Linux release 7.3.1611 (Core) 安装 Oracle 软件， 不创建实例

SQL> create pfile='/home/oracle/pfile0728.ora' from spfile; File created. 

[oracle@rac1 ~]$ pwd /home/oracle [oracle@rac1 ~]$ ll total 2487204 drwxr-xr-x 2 oracle oinstall 111 Jun 24 21:30 data-bak drwxr-xr-x 7 oracle oinstall 136 Aug 27 2013 database -rw-r--r--. 1 oracle oinstall 1395582860 Jan 7 2020 p13390677_112040_Linux-x86-64_1of7.zip -rw-r--r--. 1 oracle oinstall 1151304589 Jan 7 2020 p13390677_112040_Linux-x86-64_2of7.zip -rw-r--r-- 1 oracle asmadmin 1547 Jul 28 08:27 pfile0728.ora 

[oracle@rac1 ~]$ scp pfile0728.ora oracle@192.168.1.15:/home/oracle/ The authenticity of host '192.168.1.15 (192.168.1.15)' can't be established. ECDSA key fingerprint is 5c:31:ec:3c:ee:9c:6d:22:f3:60:dc:15:72:fd:67:91. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '192.168.1.15' (ECDSA) to the list of known hosts. oracle@192.168.1.15's password: pfile0728.ora 100% 1547 1.5KB/s 00:00 [oracle@rac1 ~]$ # 切换到目标主机 [oracle@mysql bin]$ cd ~ [oracle@mysql ~]$ ls db_install.rsp pfile0728.ora [oracle@mysql ~]$ cp pfile0728.ora $ORACLE_HOME/dbs/ [oracle@mysql ~]$ ls $ORACLE_HOME/dbs/p* /usr/local/oracle/product/11.2.0/db_1/dbs/pfile0728.ora 

[root@rac1 ~]# mkdir /arch/bk0729 -p [root@rac1 ~]# chown -R oracle:oinstall /arch/bk0729 [root@rac1 ~]# ll /arch/ 总用量 0 drwxr-xr-x 2 oracle oinstall 6 7月 30 18:58 bk0729 

#=设置备份参数：备份到磁盘，6 个通道 ====================================== configure device type disk parallelism 6 backup type to backupset; #=设置备份参数：设置备份文件的位置及文件名格式 ================================== configure channel device type disk format '/arch/bk0729/%d_%I_%s_%p_%T.bkp'; # 备份控制文件 ============================================ backup current controlfile format ='/arch/bk0729/control_bak_%s.bak'; # 备份数据库 ============================================ backup as compressed backupset database; # 下面的备份命令可以同时备份数据库和控制文件 backup incremental level 0 format '/rmanbackup/orcl_full_%U' database include current controlfile; #= 设置备份文件格式：=========================================== configure channel device type disk format '/arch/bk0729/ctl_%d_%I_%s_%p_%T.bkp'; #= 备份归档日志：=========================================== backup as compressed backupset archivelog all; #=设置备份参数：备份到磁盘，6 个通道 ====================================== RMAN> configure device type disk parallelism 6 backup type to backupset; old RMAN configuration parameters: CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 6; new RMAN configuration parameters: CONFIGURE DEVICE TYPE DISK PARALLELISM 6 BACKUP TYPE TO BACKUPSET; new RMAN configuration parameters are successfully stored #=设置备份参数：设置备份文件的位置及文件名格式 ================================== RMAN> configure channel device type disk format '/arch/bk0729/%d_%I_%s_%p_%T.bkp'; old RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/arch/bk0729/%d_%I_%s_%p_%T.bkp'; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/arch/bk0729/%d_%I_%s_%p_%T.bkp'; new RMAN configuration parameters are successfully stored # 备份控制文件 ============================================ RMAN> backup current controlfile format ='/arch/bk0729/control_bak_%s.bak'; Starting backup at 30-JUL-22 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=31 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=125 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=158 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=159 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_5 channel ORA_DISK_5: SID=162 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_6 channel ORA_DISK_6: SID=36 instance=hisdb1 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 30-JUL-22 channel ORA_DISK_1: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/control_bak_32.bak tag=TAG20220730T193424 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 30-JUL-22 # 备份数据库 ============================================ RMAN> backup as compressed backupset database; Starting backup at 30-JUL-22 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 using channel ORA_DISK_5 using channel ORA_DISK_6 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA/hisdb/datafile/system.278.1107994145 channel ORA_DISK_1: starting piece 1 at 30-JUL-22 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00002 name=+DATA/hisdb/datafile/sysaux.279.1107994147 input datafile file number=00004 name=+DATA/hisdb/datafile/users.270.1107994131 channel ORA_DISK_2: starting piece 1 at 30-JUL-22 channel ORA_DISK_3: starting compressed full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00003 name=+DATA/hisdb/datafile/undotbs1.271.1107994123 input datafile file number=00006 name=+DATA/hisdb/datafile/ts001.277.1107994139 channel ORA_DISK_3: starting piece 1 at 30-JUL-22 channel ORA_DISK_4: starting compressed full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00007 name=+DATA/hisdb/datafile/undotbs2.284.1108022905 input datafile file number=00005 name=+DATA/hisdb/datafile/ts001.276.1107994131 channel ORA_DISK_4: starting piece 1 at 30-JUL-22 channel ORA_DISK_5: starting compressed full datafile backup set channel ORA_DISK_5: specifying datafile(s) in backup set channel ORA_DISK_6: starting compressed full datafile backup set channel ORA_DISK_6: specifying datafile(s) in backup set including current SPFILE in backup set channel ORA_DISK_6: starting piece 1 at 30-JUL-22 channel ORA_DISK_3: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/HISDB_2002805648_35_1_20220730.bkp tag=TAG20220730T193500 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:54 channel ORA_DISK_6: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/HISDB_2002805648_38_1_20220730.bkp tag=TAG20220730T193500 comment=NONE channel ORA_DISK_6: backup set complete, elapsed time: 00:00:27 channel ORA_DISK_1: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/HISDB_2002805648_33_1_20220730.bkp tag=TAG20220730T193500 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:26 channel ORA_DISK_2: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/HISDB_2002805648_34_1_20220730.bkp tag=TAG20220730T193500 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:01:26 channel ORA_DISK_4: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/HISDB_2002805648_36_1_20220730.bkp tag=TAG20220730T193500 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:45 including current control file in backup set channel ORA_DISK_5: starting piece 1 at 30-JUL-22 channel ORA_DISK_5: finished piece 1 at 30-JUL-22 piece handle=/arch/bk0729/HISDB_2002805648_37_1_20220730.bkp tag=TAG20220730T193500 comment=NONE channel ORA_DISK_5: backup set complete, elapsed time: 00:00:01 Finished backup at 30-JUL-22 # 查看备份的文件 [root@rac1 bk0729]# pwd /arch/bk0729 [root@rac1 bk0729]# ll -h 总用量 325M -rw-r----- 1 oracle asmadmin 9.4M 7月 30 19:34 control_bak_32.bak -rw-r----- 1 oracle asmadmin 213M 7月 30 20:24 HISDB_2002805648_45_1_20220730.bkp -rw-r----- 1 oracle asmadmin 99M 7月 30 20:24 HISDB_2002805648_46_1_20220730.bkp -rw-r----- 1 oracle asmadmin 1.6M 7月 30 20:23 HISDB_2002805648_47_1_20220730.bkp -rw-r----- 1 oracle asmadmin 1.1M 7月 30 20:23 HISDB_2002805648_48_1_20220730.bkp -rw-r----- 1 oracle asmadmin 1.1M 7月 30 20:24 HISDB_2002805648_49_1_20220730.bkp -rw-r----- 1 oracle asmadmin 96K 7月 30 20:23 HISDB_2002805648_50_1_20220730.bkp #= 设置备份文件格式：=========================================== RMAN> configure channel device type disk format '/arch/bk0729/ctl_%d_%I_%s_%p_%T.bkp'; old RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/arch/bk0729/%d_%I_%s_%p_%T.bkp'; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/arch/bk0729/ctl_%d_%I_%s_%p_%T.bkp'; new RMAN configuration parameters are successfully stored released channel: ORA_DISK_1 released channel: ORA_DISK_2 released channel: ORA_DISK_3 released channel: ORA_DISK_4 released channel: ORA_DISK_5 released channel: ORA_DISK_6 #= 备份归档日志：=========================================== RMAN> backup as compressed backupset archivelog all; Starting backup at 30-JUL-22 current log archived usin
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：Oracle数据库对象的使用详解_oracle_
                                                                
下一篇：oracle表空间不足ORA-01653的问题: unable to extend table_oracle_