oracle database单实例迁移到oracle rac
oracle database单实例迁移到oracle rac步骤：
--------------------------------------分割线 --------------------------------------
vmware+linux+oracle 10g rac全程详细图解
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
oracle 11gr2 在vmware虚拟机中安装步骤
--------------------------------------分割线 --------------------------------------
迁移前单实例环境介绍：
数据库版本：oracle database 10g enterprise edition release 10.2.0.5.0 - production
数据库物理结构：
rman> report schema;
using target database control file instead of recovery catalog
report of database schema
list of permanent datafiles
===========================
file size(mb) tablespace rb segs datafile name
---- -------- -------------------- ------- ------------------------
1 440 system *** /u01/app/oracle/oradata/orcl/system01.dbf
2 25 undotbs1 *** /u01/app/oracle/oradata/orcl/undotbs01.dbf
3 250 sysaux *** /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 5 users *** /u01/app/oracle/oradata/orcl/users01.dbf
list of temporary files
=======================
file size(mb) tablespace maxsize(mb) tempfile name
---- -------- -------------------- ----------- --------------------
1 20 temp 32767 /u01/app/oracle/oradata/orcl/temp01.dbf
rman>
主机环境
[oracle@rac1 admin]$ cat /etc/hosts
# do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.2.101 rac1.localdomain rac1
192.168.2.102 rac2.localdomain rac2
192.168.0.101 rac1-priv.localdomain rac1-priv
192.168.0.102 rac2-priv.localdomain rac2-priv
192.168.2.103 rac1-vip.localdomain rac1-vip
192.168.2.104 rac2-vip.localdomain rac2-vip
[oracle@rac1 admin]$
================================================================================
1. 单节点数据库备份
注：单节点数据库的备份已经传送到/u02目录下，，直接执行下面的解压即可。
[oracle@rac1 u02]$ cd /u02
[oracle@rac1 u02]$ tar zxvf backup_db.orcl.tar.gz
backup_db/
backup_db/orcl_24_798936483_1_full_arch.bus
backup_db/orcl_25_798936484_1_full_ctl.bus
backup_db/orcl_26_798936485_1_full_spfile.bus
backup_db/orcl_22_798936465_1_full_db.bus
backup_db/initorcl.ora
backup_db/orcl_20_798936465_1_full_db.bus
backup_db/orcl_21_798936465_1_full_db.bus
backup_db/orcl_23_798936466_1_full_db.bus
backup_db/orcl_19_798936465_1_full_arch.bus
[oracle@rac1 u02]$
-------------------------------------------------------------------------
mkdir -p /u02/backup_db/
chown oracle:dba /u02/backup_db/
chmod 770 /u02/backup_db/
rman target /
run{
allocate channel d1 type disk maxpiecesize=10g;
allocate channel d2 type disk maxpiecesize=10g;
allocate channel d3 type disk maxpiecesize=10g;
backup tag 'full_db_bk' filesperset 10
as compressed backupset database force noexclude
format '/u02/backup_db/%d_%s_%t_%p_full_db.bus'
plus archivelog delete all input
format '/u02/backup_db/%d_%s_%t_%p_full_arch.bus';
backup current controlfile tag 'full_db_cntl' format '/u02/backup_db/%d_%s_%t_%p_full_ctl.bus';
backup spfile tag 'full_db_spfile' format '/u02/backup_db/%d_%s_%t_%p_full_spfile.bus';
release channel d1;
release channel d2;
release channel d3;
}
sql> create pfile from spfile;
[oracle@ocm18 dbs]$ cat initorcl.ora
orcl.__db_cache_size=432013312
orcl.__java_pool_size=8388608
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=159383552
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(protocol=tcp) (service=orclxdb)'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=201326592
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=605028352
*.undo_management='auto'
*.undo_tablespace='undotbs1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
[oracle@ocm18 dbs]$
2. rac环境建立
在两个节点操作：
cd $oracle_base/admin
mkdir orcl
cd orcl/
mkdir -p adump bdump cdump dpdump hdump pfile scripts udump
在节点1 操作：
[oracle@rac1 ~]$ cd $oracle_home/dbs
[oracle@rac1 dbs]$ orapwd file=orapworcl1 password=oracle
[oracle@rac1 dbs]$
在节点2 操作：
[oracle@rac2 ~]$ cd $oracle_home/dbs
[oracle@rac2 dbs]$ orapwd file=orapworcl2 password=oracle
[oracle@rac2 dbs]$
3. 修改初始化参数文件
[oracle@rac1 ~]$ cp /u02/backup_db/initorcl.ora $oracle_home/dbs/initorcl1.ora
[oracle@rac1 dbs]$ vi $oracle_home/dbs/initorcl1.ora
添加: