单实例数据库迁移到rac环境——RAMN
我的图书馆
单实例数据库迁移到rac环境——RAMN
在前两节中，分别介绍了使用expdp/impdp迁移单实例数据库到rac环境的方法，其中包括使用表空间传输的方式，但如果在用户数量多，或者表空间数量多，又或者函数，过程，包等代码对象多的条件下，使用前两种方式迁移未免麻烦且费时，因而在本节中将简要的介绍下使用rman备份的异机恢复来实现迁移单实例数据库到rac环境，这种方式美中不足的地方是数据库需要以open resetlogs方式打开，意味着对数据库做不完全恢复，可能会丢失少量的数据！
环境介绍：数据库的版本均为10.2.0.5，数据库字符集编码为utf8操作系统的版本单实例数据库(源库)为rhel5.4 64 bit 数据库名： 实例名：orclrac(目标数据库)为ceontos4.8 64bit
一：目标数据库准备工作，rman备份的异机恢复要求数据库名要一致，因而需要先删掉原有的racdb数据库和数据文件
[oracle@rac1 ~]$ srvctl stop database -d racdb -o immediate[oracle@rac1 ~]$ srvctl remove database -d racdb Remove the database racdb? (y/[n]) y
[oracle@rac1 ~]$ crs_stat -t -vName&&&&&&&&&& Type&&&&&&&&&& R/RA&& F/FT&& Target&&& State&&&& Host&&&&&&& ----------------------------------------------------------------------ora....SM1.asm application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& 0/3&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& 0/0&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& 0/3&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& 0/0&&& 0/0&&& ONLINE&&& ONLINE&&& rac2
节点2上同样需要修改/etc/oratab文件[root@rac1 ~]# tail -n 1 /etc/oratab +ASM1:/u01/app/oracle/product/10.2.0/db_1:N&&
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1[oracle@rac1 ~]$ asmcmdASMCMD& rm -rf +DATA/RACDBASMCMD& rm -rf +FRA/RACDB
[oracle@rac1 ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 3 12:43:13 2012Copyright (c) , Oracle.& All Rights Reserved.
SQL& conn /as sysdbaConnected.
SQL& col state format a10SQL& col name format a15SQL& col failgroup format a20& SQL& set line 200SQL& select& state,redundancy,total_mb,free_mb,name,failgroup from v$asm_
STATE&&&&& REDUNDANCY&&&&&&&&&&&&& TOTAL_MB&&& FREE_MB NAME&&&&&&&&&&& FAILGROUP---------- --------------------- ---------- ---------- --------------- --------------------NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&&& 286&&&&&&&&& 0NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&&& 286&&&&&&&&& 0NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&&& 286&&&&&&&&& 0NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&&& 286&&&&&&&&& 0NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&&& 286&&&&&&&&& 0NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&& 10208&&&&& 10114 FRA_0000&&&&&&& FRA_0000NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&& 9537&&&&&& 9443 DATA_0001&&&&&& DATA_0001NORMAL&&&& UNKNOWN&&&&&&&&&&&&&&&&&&&& 9537&&&&&& 9443 DATA_0000&&&&&& DATA_00008 rows selected.
备注：前5个磁盘分别为表决盘和ocr，data磁盘组做了normal冗余
SQL& select& group_number,name,state,type,total_mb,free_mb,unbalanced& from v$asm_
GROUP_NUMBER NAME&&&&&&&&&&& STATE&&&&& TYPE&&&&&&&&&&&&&&&& TOTAL_MB&&& FREE_MB UNB------------ --------------- ---------- ------------------ ---------- ---------- ---&&&&&&&&&& 1 DATA&&&&&&&&&&& MOUNTED&&& NORMAL&&&&&&&&&&&&&&&&& 19074&&&&& 18886 N&&&&&&&&&& 2 FRA&&&&&&&&&&&& MOUNTED&&& EXTERN&&&&&&&&&&&&&&&&& 10208&&&&& 10114 N
二：源库上建一个测试表，由spfile生成pfile
NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE------------------------------------ ----------- ------------------------------db_file_name_convert&&&&&&&&&&&&&&&& stringdb_name&&&&&&&&&&&&&&&&&&&&&&&&&&&&& string&&&&& orcldb_unique_name&&&&&&&&&&&&&&&&&&&&&& string&&&&& orclglobal_names&&&&&&&&&&&&&&&&&&&&&&&& boolean&&&& FALSEinstance_name&&&&&&&&&&&&&&&&&&&&&&& string&&&&& orcllock_name_space&&&&&&&&&&&&&&&&&&&&& stringlog_file_name_convert&&&&&&&&&&&&&&& stringservice_names&&&&&&&&&&&&&&&&&&&&&&& string&&&&&
SQL& create table test1.migrate(a varchar2(20));Table created.
SQL& insert into test1.migrate a values ('successful');1 row created.
SQL&Commit complete.
SQL& create pfile='/home/oracle/rman_bak/initorcl.ora'File created.
SQL& select file_id,file_name,tablespace_name from dba_data_files order by 1;
&& FILE_ID FILE_NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TABLESPACE_NAME---------- -------------------------------------------------- ---------------&&&&&&&& 1 /u01/app/oracle/oradata/orcl/system01.dbf&&&&&&&&& SYSTEM&&&&&&&& 2 /u01/app/oracle/oradata/orcl/undotbs01.dbf&&&&&&&& UNDOTBS1&&&&&&&& 3 /u01/app/oracle/oradata/orcl/sysaux01.dbf&&&&&&&&& SYSAUX&&&&&&&& 4 /u01/app/oracle/oradata/orcl/users01.dbf&&&&&&&&&& USERS&&&&&&&& 5 /u01/app/oracle/oradata/orcl/example01.dbf&&&&&&&& EXAMPLE&&&&&&&& 6 /u01/app/oracle/oradata/orcl/exp_rac01.dbf&&&&&&&& EXP_RAC&&&&&&&& 7 /u01/app/oracle/oradata/orcl/exp_rac_index01.dbf&& EXP_RAC_INDEX&&&&&&&& 8 /u01/app/oracle/oradata/orcl/exp_rac1_01.dbf&&&&&& EXP_RAC1&&&&&&&& 9 /u01/app/oracle/oradata/orcl/exp_rac1_index_01.dbf EXP_RAC1_INDEX9 rows selected.
SQL& select file_id,file_name,tablespace_name from dba_temp_files order by 1;
&& FILE_ID FILE_NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TABLESPACE_NAME---------- -------------------------------------------------- ---------------&&&&&&&& 1 /u01/app/oracle/oradata/orcl/temp01.dbf&&&&&&&&&&& TEMP
SQL& select file_name,tablespace_name from dba_temp_
FILE_NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TABLESPACE_NAME-------------------------------------------------- --------------------/u01/app/oracle/oradata/orcl/temp01.dbf&&&&&&&&&&& TEMP
三：在源库上使用rman进行全库备份，并将备份复制到目标数据库上
[oracle@server49 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jan 3 12:10:06 2012Copyright (c) , Oracle.& All rights reserved.connected to target database: ORCL (DBID=)
RMAN& backup incremental level 0 2& format '/home/oracle/rman_bak/orcl_%U'3& database plus archivelog4&
RMAN& backup current controlfile format '/home/oracle/rman_bak/migrate.ctl';
RMAN& list backup
List of Backups===============Key&&&& TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag------- -- -- - ----------- --------------- ------- ------- ---------- ---2&&&&&& B& 0& A DISK&&&&&&& 03-JAN-12&&&&&& 1&&&&&& 1&&&&&& NO&&&&&&&& TAG503
[oracle@server49 ~]$ scp -rp /home/oracle/rman_bak/ rac1:/home/oracle/
四：在目标数据库上执行恢复4.1 修改初始化参数文件如下
[oracle@rac1 ~]$ cat /home/oracle/rman_bak/initorcl.ora *.__db_cache_size=*.__java_pool_size=4194304*.__large_pool_size=4194304*.__shared_pool_size=*.__streams_pool_size=8388608orcl1.instance_name='orcl1'orcl2.instance_name='orcl2'orcl1.instance_number=1orcl2.instance_number=2*.cluster_database=true*.cluster_database_instances=2orcl1.thread=1*.compatible='10.2.0.5.0'*.control_files='+DATA/orcl/controlfile/control01.ctl','+FRA/orcl/controlfile/control02.ctl'*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'*.db_block_size=8192*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='orcl'*.db_recovery_file_dest='+FRA'*.db_recovery_file_dest_size=*.log_archive_dest_1='LOCATION=+FRA/orcl/archivelog'*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'*.job_queue_processes=10*.log_archive_format='%t_%s_%r.arc'*.open_cursors=300*.pga_aggregate_target=*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.sga_target=*.undo_management='AUTO'orcl1.undo_tablespace='UNDOTBS1'orcl2.undo_tablespace='UNDOTBS2'
备注：需要格外注意的是，这个时候不能加orcl2.thread=2参数，否则后面无法将数据库启动到mount状态
4.2 创建相关的目录，两个节点上都应该存在相应的目录和密码文件
[oracle@rac1 ~]$ mkdir -p& /u01/app/oracle/admin/orcl/{adump,bdump,cdump,udump}[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs[oracle@rac1 dbs]$ echo 'spfile=+DATA/ORCL/PARAMETERFILE/spfileorcl.ora' & initorcl1.ora[oracle@rac1 dbs]$ orapwd file=orapworcl1 password=123456[oracle@rac2 ~]$ cd $ORACLE_HOME/dbs[oracle@rac2 dbs]$ echo 'spfile=+DATA/ORCL/PARAMETERFILE/spfileorcl.ora' & initorcl2.ora[oracle@rac2 dbs]$ orapwd file=orapworcl1 password=123456
4.3 利用pfile生成spfile，并保存在ASM实例上，ASM磁盘组中需要存在相应的目录，否则将报错！
[oracle@rac1 ~]$ export ORACLE_SID=orcl1[oracle@rac1 ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 3 13:00:10 2012Copyright (c) , Oracle.& All Rights Reserved.
SQL& conn /as sysdbaConnected to an idle instance.
SQL& startup nomount pfile='/home/oracle/rman_bak/initorcl.ora';ORACLE instance started.
Total System Global Area&
bytesFixed Size&&&&&&&&&&&&&&&&& 2095152 bytesVariable Size&&&&&&&&&&&&
bytesDatabase Buffers&&&&&&&&&&
bytesRedo Buffers&&&&&&&&&&&&&&& 6291456 bytes
SQL& create spfile='+DATA/ORCL/PARAMETERFILE/spfileorcl.ora' from pfile='/home/oracle/rman_bak/initorcl.ora';File created.
ASMCMD& pwd+DATA/ORCL/PARAMETERFILEASMCMD& lsspfileorcl.ora
SQL&ORACLE instance shut down.
4.4 将节点1数据库启动到nomount状态，恢复控制文件，重新将数据库启动到mount状态
[oracle@rac1 ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 3 13:09:48 2012Copyright (c) , Oracle.& All Rights Reserved.
SQL& conn /as sysdbaConnected to an idle instance.SQL& startup nomountORACLE instance started.
Total System Global Area&
bytesFixed Size&&&&&&&&&&&&&&&&& 2095152 bytesVariable Size&&&&&&&&&&&&
bytesDatabase Buffers&&&&&&&&&&
bytesRedo Buffers&&&&&&&&&&&&&&& 6291456 bytes
[oracle@rac1 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jan 3 13:15:05 2012Copyright (c) , Oracle.& All rights reserved.connected to target database: orcl (not mounted)RMAN& restore controlfile from '/home/oracle/rman_bak/migrate.ctl';
Starting restore at
13:15:11using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=153 instance=orcl1 devtype=DISK
channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:08output filename=+DATA/orcl/controlfile/control01.ctloutput filename=+FRA/orcl/controlfile/control02.ctlFinished restore at
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1[oracle@rac1 ~]$ asmcmdASMCMD& pwd+data/orcl/controlfileASMCMD& lscontrol01.ctlcurrent.263.ASMCMD& cd +fra/orcl/controlfileASMCMD& lscontrol02.ctlcurrent.260.
SQL& shutdown abortORACLE instance shut down.SQL& startup mountORACLE instance started.
Total System Global Area&
bytesFixed Size&&&&&&&&&&&&&&&&& 2095152 bytesVariable Size&&&&&&&&&&&&
bytesDatabase Buffers&&&&&&&&&&
bytesRedo Buffers&&&&&&&&&&&&&&& 6291456 bytesDatabase mounted.
SQL& select host_name,status,thread# from gv$
HOST_NAME&&&&&&&&&&& STATUS&&&&&&&&&&&&&&&&& THREAD#-------------------- -------------------- ----------&&&&&&& MOUNTED&&&&&&&&&&&&&&&&&&&&&& 1
4.5 使用rman进行数据库恢复操作
[oracle@rac1 ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jan 3 17:29:22 2012Copyright (c) , Oracle.& All rights reserved.connected to target database: ORCL (DBID=, not open)
RMAN& run {2& set newname for datafile 1 to '+DATA/orcl/datafile/system01.dbf';3& set newname for datafile 2 to '+DATA/orcl/datafile/undotbs01.dbf';4& set newname for datafile 3 to '+DATA/orcl/datafile/sysaux01.dbf';5& set newname for datafile 4 to '+DATA/orcl/datafile/users01.dbf';6& set newname for datafile 5 to '+DATA/orcl/datafile/example01.dbf';7& set newname for datafile 6 to '+DATA/orcl/datafile/exp_rac01.dbf';8& set newname for datafile 7 to '+DATA/orcl/datafile/exp_rac_index01.dbf';9& set newname for datafile 8 to '+DATA/orcl/datafile/exp_rac1_01.dbf';10& set newname for datafile 9 to '+DATA/orcl/datafile/exp_rac1_index_01.dbf';11& set newname for tempfile 1 to '+DATA/orcl/tempfile/temp01.dbf';12&13&14&15& }
RMAN-06139: WARNING: control file is not current for REPORT SCHEMAReport of database schema
List of Permanent Datafiles===========================File Size(MB) Tablespace&&&&&&&&&& RB segs Datafile Name---- -------- -------------------- ------- ------------------------1&&& 440&&&&& SYSTEM&&&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/system01.dbf2&&& 30&&&&&& UNDOTBS1&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/undotbs01.dbf3&&& 250&&&&& SYSAUX&&&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/sysaux01.dbf4&&& 5&&&&&&& USERS&&&&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/users01.dbf5&&& 100&&&&& EXAMPLE&&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/example01.dbf6&&& 410&&&&& EXP_RAC&&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/exp_rac01.dbf7&&& 300&&&&& EXP_RAC_INDEX&&&&&&& ***&&&& +DATA/orcl/datafile/exp_rac_index01.dbf8&&& 300&&&&& EXP_RAC1&&&&&&&&&&&& ***&&&& +DATA/orcl/datafile/exp_rac1_01.dbf9&&& 300&&&&& EXP_RAC1_INDEX&&&&&& ***&&&& +DATA/orcl/datafile/exp_rac1_index_01.dbf
List of Temporary Files=======================File Size(MB) Tablespace&&&&&&&&&& Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1&&& 0&&&&&&& TEMP&&&&&&&&&&&&&&&& 32767&&&&&& +DATA/orcl/tempfile/temp01.dbf
ASMCMD& pwd+data/orcl/datafileASMCMD& lsEXAMPLE.268.EXP_RAC.260.EXP_RAC1.262.EXP_RAC1_INDEX.266.EXP_RAC_INDEX.261.SYSAUX.267.SYSTEM.297.UNDOTBS1.305.USERS.309.example01.dbfexp_rac01.dbfexp_rac1_01.dbfexp_rac1_index_01.dbfexp_rac_index01.dbfsysaux01.dbfsystem01.dbfundotbs01.dbfusers01.dbf
RMAN&Starting recover at
18:59:41using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destinationchannel ORA_DISK_1: restoring archive logarchive log thread=1 sequence=20channel ORA_DISK_1: reading from backup piece /home/oracle/rman_bak/orcl_09mvru2e_1_1channel ORA_DISK_1: restored backup piece 1piece handle=/home/oracle/rman_bak/orcl_09mvru2e_1_1 tag=TAG453channel ORA_DISK_1: restore complete, elapsed time: 00:00:02archive log filename=+FRA/orcl/archivelog/1_20_.arc thread=1 sequence=20unable to find archive logarchive log thread=1 sequence=21RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 01/03/:47RMAN-06054: media recovery requesting unknown log: thread 1 seq 21 lowscn 479325
4.6 对在线重做日志文件进行更名，添加thread 2日志组
SQL& select group#,member from v$
&&& GROUP# MEMBER---------- ----------------------------------------&&&&&&&& 3 /u01/app/oracle/oradata/orcl/redo03.log&&&&&&&& 2 /u01/app/oracle/oradata/orcl/redo02.log&&&&&&&& 1 /u01/app/oracle/oradata/orcl/redo01.log
SQL& alter database rename file '/u01/app/oracle/oradata/orcl/redo01.log' to '+DATA/orcl/onlinelog/redo01.dbf';Database altered.
SQL& alter database rename file '/u01/app/oracle/oradata/orcl/redo02.log' to '+DATA/orcl/onlinelog/redo02.dbf';Database altered.
SQL& alter database rename file '/u01/app/oracle/oradata/orcl/redo03.log' to '+DATA/orcl/onlinelog/redo03.dbf';Database altered.
SQL& alter database add logfile thread 2 group 4 '+DATA' size 50M;Database altered.
SQL& alter database add logfile thread 2 group 5 '+DATA' size 50M;Database altered.
SQL& alter database add logfile thread 2 group 6 '+DATA' size 50M;Database altered.
SQL& select thread#,bytes/(),status from v$
&& THREAD# BYTES/() STATUS---------- ----------------- ------------------------------------------------&&&&&&&& 1&&&&&&&&&&&&&&& 50 INACTIVE&&&&&&&& 1&&&&&&&&&&&&&&& 50 ACTIVE&&&&&&&& 1&&&&&&&&&&&&&&& 50 CURRENT&&&&&&&& 2&&&&&&&&&&&&&&& 50 UNUSED&&&&&&&& 2&&&&&&&&&&&&&&& 50 UNUSED&&&&&&&& 2&&&&&&&&&&&&&&& 50 UNUSED
<SPAN style="COLOR: # rows selected.
4.7 使用open resetlogs方式打开数据库
SQL& recover database using backup contORA-00279: change 479325 generated at 01/03/:52 needed for thread 1ORA-00289: suggestion : +FRA/orcl/archivelog/1_21_.arcORA-00280: change 479325 for thread 1 is in sequence #21
Specify log: {&RET&=suggested | filename | AUTO | CANCEL}cancelMedia recovery cancelled.
SQL& alter datDatabase altered.
SQL& select open_mode,name from gv$
OPEN_MODE&&&&&&&&&&&&&&&&&&&&& NAME------------------------------ ---------------------------READ WRITE&&&&&&&&&&&&&&&&&&&& ORCL
SQL& select comp_name,version,status from dba_
COMP_NAME&&&&&&&&&&&&&&&&&&&&& VERSION&&&&&&&&&&&&& STATUS------------------------------ -------------------- --------------------Oracle Database Catalog Views& 10.2.0.5.0&&&&&&&&&& VALIDOracle Database Packages and T 10.2.0.5.0&&&&&&&&&& VALIDypes
Oracle Workspace Manager&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDJServer JAVA Virtual Machine&& 10.2.0.5.0&&&&&&&&&& VALIDOracle XDK&&&&&&&&&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle Database Java Packages& 10.2.0.5.0&&&&&&&&&& VALIDOracle Expression Filter&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle Data Mining&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle Text&&&&&&&&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALID
COMP_NAME&&&&&&&&&&&&&&&&&&&&& VERSION&&&&&&&&&&&&& STATUS------------------------------ -------------------- --------------------Oracle XML Database&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle Rules Manager&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle interMedia&&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOLAP Analytic Workspace&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle OLAP API&&&&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOLAP Catalog&&&&&&&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDSpatial&&&&&&&&&&&&&&&&&&&&&&& 10.2.0.5.0&&&&&&&&&& VALIDOracle Enterprise Manager&&&&& 10.2.0.5.0&&&&&&&&&& VALID
4.8 修改相关的初始化参数，创建undotbs2表空间，启用thread 2日志组
SQL& alter system set thread=1 scope=spfile sid='orcl1';System altered.
SQL& alter system set thread=2 scope=spfile sid='orcl2';System altered.
SQL& select bytes/() MB from dba_data_files where tablespace_name='UNDOTBS1';
&&&&&&& MB----------&&&&&&& 30
SQL& create undo tablespace undotbs2 datafile '+DATA/ORCL/DATAFILE/undotbs02.dbf' size 30M;Tablespace created.
SQL& alter system set undo_tablespace=undotbs2 sid='orcl2';System altered.
SQL& alter database enable thread 2;Database altered.
4.9 重新启动节点1数据库实例后，再启动节点2数据库实例；并验证结果
SQL& shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.
SQL& startupORACLE instance started.
Total System Global Area&
bytesFixed Size&&&&&&&&&&&&&&&&& 2095152 bytesVariable Size&&&&&&&&&&&&
bytesDatabase Buffers&&&&&&&&&&
bytesRedo Buffers&&&&&&&&&&&&&&& 6291456 bytesDatabase mounted.Database opened.
SQL& select instance_number,instance_name,host_name ,status from gv$
INSTANCE_NUMBER INSTANCE_NAME&&&&&&& HOST_NAME&&&&&&&&&&& STATUS--------------- -------------------- -------------------- --------------------&&&&&&&&&&&&& 1 orcl1&&&&&&&&&&&&&&& &&&&&&& OPEN&&&&&&&&&&&&& 2 orcl2&&&&&&&&&&&&&&& &&&&&&& OPEN
SQL& select * from test1.
A------------------------------------------------------------successful
SQL& col file_name format a40SQL& col tablespace_name format a20SQL& select file_id,file_name,tablespace_name from dba_data_files order by 1;
&& FILE_ID FILE_NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TABLESPACE_NAME---------- ---------------------------------------- --------------------&&&&&&&& 1 +DATA/orcl/datafile/system01.dbf&&&&&&&& SYSTEM&&&&&&&& 2 +DATA/orcl/datafile/undotbs01.dbf&&&&&&& UNDOTBS1&&&&&&&& 3 +DATA/orcl/datafile/sysaux01.dbf&&&&&&&& SYSAUX&&&&&&&& 4 +DATA/orcl/datafile/users01.dbf&&&&&&&&& USERS&&&&&&&& 5 +DATA/orcl/datafile/example01.dbf&&&&&&& EXAMPLE&&&&&&&& 6 +DATA/orcl/datafile/exp_rac01.dbf&&&&&&& EXP_RAC&&&&&&&& 7 +DATA/orcl/datafile/exp_rac_index01.dbf& EXP_RAC_INDEX&&&&&&&& 8 +DATA/orcl/datafile/exp_rac1_01.dbf&&&&& EXP_RAC1&&&&&&&& 9 +DATA/orcl/datafile/exp_rac1_index_01.db EXP_RAC1_INDEX&&&&&&&&&& f
&& FILE_ID FILE_NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TABLESPACE_NAME---------- ---------------------------------------- --------------------&&&&&&& 10 +DATA/orcl/datafile/undotbs02.dbf&&&&&&& UNDOTBS2
五：收尾工作
SQL& @$ORACLE_HOME/rdbms/admin/catclust.[oracle@rac1 ~]$ crs_stat -t -vName&&&&&&&&&& Type&&&&&&&&&& R/RA&& F/FT&& Target&&& State&&&& Host&&&&&&& ----------------------------------------------------------------------ora....SM1.asm application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& 0/3&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& 0/0&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& 0/3&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& 0/0&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&
[oracle@rac1 ~]$ srvctl add database -d orcl -o $ORACLE_HOME [oracle@rac1 ~]$ srvctl add instance -d orcl -i orcl1 -n rac1[oracle@rac1 ~]$ srvctl add instance -d orcl -i orcl2 -n rac2
[oracle@rac1 ~]$ srvctl stop database -d orcl -o immediate[oracle@rac1 ~]$ srvctl start database -d orcl[oracle@rac1 ~]$ crs_stat -t -vName&&&&&&&&&& Type&&&&&&&&&& R/RA&& F/FT&& Target&&& State&&&& Host&&&&&&& ----------------------------------------------------------------------ora.orcl.db&&& application&&& 0/0&&& 0/1&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....l1.inst application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....l2.inst application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....SM1.asm application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....C1.lsnr application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.gsd&& application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.ons&& application&&& 0/3&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora.rac1.vip&& application&&& 0/0&&& 0/0&&& ONLINE&&& ONLINE&&& rac1&&&&&&& ora....SM2.asm application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora....C2.lsnr application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.gsd&& application&&& 0/5&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.ons&& application&&& 0/3&&& 0/0&&& ONLINE&&& ONLINE&&& rac2&&&&&&& ora.rac2.vip&& application&&& 0/0&&& 0/0&&& ONLINE&&& ONLINE&&& rac2
TA的最新馆藏[转]&[转]&
喜欢该文的人也喜欢