Rename RAC Database&lt…

于 2013-01-28 22:10:00 发布
阅读量133 收藏
点赞数
文章标签： 数据库 网络
本文详细介绍了如何通过修改参数文件、创建新的控制文件等步骤来完成 Oracle RAC 数据库的重命名过程。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

from :http://oracleinstance.blogspot.com/2012/01/rename-rac-database.html
<wbr></wbr>
Here is the document to rename RAC database and next post we can see how to rename rac instance.

here is an example.

renamed RAC database proddb to racdb in servers dc1 and dc2.
  1. SQL><wbr>select<wbr>instance_name,host_name<wbr>from<wbr>gv$instance;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  2. <wbr><wbr></wbr></wbr>
  3. INSTANCE_NAME<wbr><wbr><wbr><wbr>HOST_NAME<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  4. ----------------<wbr>-------------------------<wbr><wbr></wbr></wbr></wbr>
  5. proddb1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>dc1.localdomain<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  6. proddb2<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>dc2.localdomain<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  7. <wbr><wbr></wbr></wbr>
  8. SQL><wbr>select<wbr>name<wbr>from<wbr>v$database;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  9. <wbr><wbr></wbr></wbr>
  10. NAME<wbr><wbr></wbr></wbr>
  11. ---------<wbr><wbr></wbr></wbr>
  12. PRODDB<wbr><wbr></wbr></wbr>

taken backup of pfile initproddb1.ora and initproddb2.ora on both nodes.
  1. [oracle@dc1<wbr>dbs]$<wbr>cat<wbr>initproddb1.ora<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  2. SPFILE='+DATA/proddb/spfileproddb.ora'<wbr><wbr></wbr></wbr>
  3. [oracle@dc1<wbr>dbs]$<wbr>cp<wbr>initproddb1.ora<wbr>initproddb1.ora_orig<wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  4. [oracle@dc1<wbr>dbs]$<wbr><wbr><wbr></wbr></wbr></wbr></wbr>
  5. <wbr><wbr></wbr></wbr>
  6. [oracle@dc2<wbr>~]$<wbr>cd<wbr>$ORACLE_HOME/dbs<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  7. [oracle@dc2<wbr>dbs]$<wbr>cat<wbr>initproddb2.ora<wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  8. SPFILE='+DATA/proddb/spfileproddb.ora'<wbr><wbr></wbr></wbr>
  9. [oracle@dc2<wbr>dbs]$<wbr>cp<wbr>initproddb2.ora<wbr>initproddb2.ora_bkp<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  10. [oracle@dc2<wbr>dbs]$<wbr><wbr><wbr></wbr></wbr></wbr></wbr>
create pfile from spfile.
taken controlfile backup to rename rac database.
  1. SQL><wbr>create<wbr>pfile=</wbr></wbr>'/tmp/initproddb1.ora'<wbr>from<wbr>spfile;<wbr><wbr></wbr></wbr></wbr></wbr>
  2. <wbr><wbr></wbr></wbr>
  3. File<wbr>created.<wbr><wbr></wbr></wbr></wbr>
  4. <wbr><wbr></wbr></wbr>
  5. SQL><wbr>alter<wbr>database<wbr>backup<wbr>controlfile<wbr>to<wbr>trace;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  6. <wbr><wbr></wbr></wbr>
  7. Database<wbr>altered.<wbr><wbr></wbr></wbr></wbr>
  8. <wbr><wbr></wbr></wbr>
  9. SQL><wbr>---<wbr>or<wbr>----<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  10. SQL><wbr><wbr><wbr></wbr></wbr></wbr>
  11. SQL><wbr>alter<wbr>database<wbr>backup<wbr>controlfile<wbr>to<wbr>trace<wbr><span>as</span><span><wbr></wbr></span><span>'/tmp/ctl_trc_bkp.txt'</span><span>;<wbr><wbr></wbr></wbr></span></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  12. <wbr><wbr></wbr></wbr>
  13. Database<wbr>altered.<wbr><wbr></wbr></wbr></wbr>

stop the RAC database using srvctl command.
  1. [oracle@dc1<wbr>~]$<wbr>srvctl<wbr>status<wbr>database<wbr>-d<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  2. Instance<wbr>proddb1<wbr><span>is</span><span><wbr>running<wbr>on<wbr>node<wbr>dc1<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  3. Instance<wbr>proddb2<wbr><span>is</span><span><wbr>running<wbr>on<wbr>node<wbr>dc2<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  4. [oracle@dc1<wbr>~]$<wbr>srvctl<wbr>config<wbr>database<wbr>-d<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  5. Database<wbr>unique<wbr>name:<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  6. Database<wbr>name:<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr>
  7. Oracle<wbr>home:<wbr>/u01/app/oracle/product/11.2.0/db_1<wbr><wbr></wbr></wbr></wbr></wbr>
  8. Oracle<wbr>user:<wbr>oracle<wbr><wbr></wbr></wbr></wbr></wbr>
  9. Spfile:<wbr>+DATA/proddb/spfileproddb.ora<wbr><wbr></wbr></wbr></wbr>
  10. Domain:<wbr><wbr><wbr></wbr></wbr></wbr>
  11. Start<wbr>options:<wbr>open<wbr><wbr></wbr></wbr></wbr></wbr>
  12. Stop<wbr>options:<wbr>immediate<wbr><wbr></wbr></wbr></wbr></wbr>
  13. Database<wbr>role:<wbr>PRIMARY<wbr><wbr></wbr></wbr></wbr></wbr>
  14. Management<wbr>policy:<wbr>AUTOMATIC<wbr><wbr></wbr></wbr></wbr></wbr>
  15. Server<wbr>pools:<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr>
  16. Database<wbr>instances:<wbr>proddb1,proddb2<wbr><wbr></wbr></wbr></wbr></wbr>
  17. Disk<wbr>Groups:<wbr>DATA<wbr><wbr></wbr></wbr></wbr></wbr>
  18. Services:<wbr><wbr><wbr></wbr></wbr></wbr>
  19. Database<wbr><span>is</span><span><wbr>administrator<wbr>managed<wbr><wbr></wbr></wbr></wbr></wbr></span></wbr>
  20. [oracle@dc1<wbr>~]$<wbr><wbr><wbr></wbr></wbr></wbr></wbr>
  21. <wbr><wbr></wbr></wbr>
  22. [oracle@dc1<wbr>~]$<wbr>srvctl<wbr>stop<wbr>database<wbr>-d<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  23. [oracle@dc1<wbr>~]$<wbr>srvctl<wbr>status<wbr>database<wbr>-d<wbr>proddb<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  24. Instance<wbr>proddb1<wbr><span>is</span><span><wbr>not<wbr>running<wbr>on<wbr>node<wbr>dc1<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  25. Instance<wbr>proddb2<wbr><span>is</span><span><wbr>not<wbr>running<wbr>on<wbr>node<wbr>dc2<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  26. [oracle@dc1<wbr>~]$<wbr><wbr><wbr></wbr></wbr></wbr></wbr>
edit/replace proddb to racdb in the newly created pfile
and also the controlfile name.
change the value of the parameter cluster_database to false.
  1. racdb2.__db_cache_size=708837376<wbr><wbr></wbr></wbr>
  2. racdb1.__db_cache_size=708837376<wbr><wbr></wbr></wbr>
  3. racdb2.__java_pool_size=4194304<wbr><wbr></wbr></wbr>
  4. racdb1.__java_pool_size=4194304<wbr><wbr></wbr></wbr>
  5. racdb2.__large_pool_size=4194304<wbr><wbr></wbr></wbr>
  6. racdb1.__large_pool_size=4194304<wbr><wbr></wbr></wbr>
  7. racdb2.__pga_aggregate_target=394264576<wbr><wbr></wbr></wbr>
  8. racdb1.__pga_aggregate_target=394264576<wbr><wbr></wbr></wbr>
  9. racdb2.__sga_target=1056964608<wbr><wbr></wbr></wbr>
  10. racdb1.__sga_target=1056964608<wbr><wbr></wbr></wbr>
  11. racdb2.__shared_io_pool_size=0<wbr><wbr></wbr></wbr>
  12. racdb1.__shared_io_pool_size=0<wbr><wbr></wbr></wbr>
  13. racdb2.__shared_pool_size=331350016<wbr><wbr></wbr></wbr>
  14. racdb1.__shared_pool_size=331350016<wbr><wbr></wbr></wbr>
  15. racdb2.__streams_pool_size=0<wbr><wbr></wbr></wbr>
  16. racdb1.__streams_pool_size=0<wbr><wbr></wbr></wbr>
  17. *.audit_file_dest='/u01/app/oracle/admin/proddb/adump'<wbr><wbr></wbr></wbr>
  18. *.audit_trail='db'<wbr><wbr></wbr></wbr>
  19. #*.cluster_database=true<wbr><wbr></wbr></wbr>
  20. *.compatible='11.2.0.0.0'<wbr><wbr></wbr></wbr>
  21. *.control_files='+DATA/proddb/controlfile/control01.ctl'<wbr><wbr></wbr></wbr>
  22. *.db_block_size=8192<wbr><wbr></wbr></wbr>
  23. *.db_create_file_dest='+DATA'<wbr><wbr></wbr></wbr>
  24. *.db_domain=''<wbr><wbr></wbr></wbr>
  25. *.db_name='racdb'<wbr><wbr></wbr></wbr>
  26. *.diagnostic_dest='/u01/app/oracle'<wbr><wbr></wbr></wbr>
  27. *.dispatchers='(PROTOCOL=TCP)<wbr>(SERVICE=racdbXDB)'</wbr><wbr><wbr></wbr></wbr>
  28. racdb2.instance_number=2<wbr><wbr></wbr></wbr>
  29. racdb1.instance_number=1<wbr><wbr></wbr></wbr>
  30. *.open_cursors=300<wbr><wbr></wbr></wbr>
  31. *.pga_aggregate_target=394264576<wbr><wbr></wbr></wbr>
  32. *.processes=150<wbr><wbr></wbr></wbr>
  33. *.remote_listener='dc-scan:1521'<wbr><wbr></wbr></wbr>
  34. *.remote_login_passwordfile='exclusive'<wbr><wbr></wbr></wbr>
  35. *.sga_target=1053818880<wbr><wbr></wbr></wbr>
  36. racdb2.thread=2<wbr><wbr></wbr></wbr>
  37. racdb1.thread=1<wbr><wbr></wbr></wbr>
  38. racdb2.undo_tablespace='UNDOTBS2'<wbr><wbr></wbr></wbr>
  39. racdb1.undo_tablespace='UNDOTBS1'<wbr><wbr></wbr></wbr>
startup the database in nomount mode with newly created pfile.
  1. [oracle@dc1<wbr>~]$<wbr>sqlplus<wbr>/<wbr></wbr></wbr></wbr></wbr>as<wbr>sysdba<wbr><wbr></wbr></wbr></wbr>
  2. <wbr><wbr></wbr></wbr>
  3. SQL*Plus:<wbr>Release<wbr>11.2.0.1.0<wbr>Production<wbr>on<wbr>Sat<wbr>Jan<wbr>7<wbr>17:35:55<wbr>2012<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  4. <wbr><wbr></wbr></wbr>
  5. Copyright<wbr>(c)<wbr>1982,<wbr>2009,<wbr>Oracle.<wbr><wbr>All<wbr>rights<wbr>reserved.<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  6. <wbr><wbr></wbr></wbr>
  7. Connected<wbr>to<wbr>an<wbr>idle<wbr>instance.<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  8. <wbr><wbr></wbr></wbr>
  9. SQL><wbr>startup<wbr>nomount<wbr>pfile=<span>'/tmp/initproddb1.ora'</span><span>;<wbr><wbr></wbr></wbr></span></wbr></wbr></wbr>
  10. ORACLE<wbr>instance<wbr>started.<wbr><wbr></wbr></wbr></wbr></wbr>
  11. <wbr><wbr></wbr></wbr>
  12. Total<wbr>System<wbr>Global<wbr>Area<wbr>1054593024<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  13. Fixed<wbr>Size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>1341196<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  14. Variable<wbr>Size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>276826356<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  15. Database<wbr>Buffers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>771751936<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  16. Redo<wbr>Buffers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>4673536<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  17. SQL><wbr><wbr><wbr></wbr></wbr></wbr>
  18. <wbr><wbr></wbr></wbr>
  19. create<wbr>a<wbr>script<wbr><span>using</span><span><wbr>backup<wbr>of<wbr>controlfile<wbr>trace<wbr>to<wbr>re-create<wbr>controlfile(to<wbr>rename<wbr>database)<wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr></wbr>
  20. CREATE<wbr>CONTROLFILE<wbr>SET<wbr>DATABASE<wbr><span>"RACDB"</span><span><wbr>RESETLOGS<wbr><wbr>NOARCHIVELOG<wbr><wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr></wbr></wbr>
  21. MAXLOGFILES<wbr>192<wbr><wbr></wbr></wbr></wbr>
  22. MAXLOGMEMBERS<wbr>3<wbr><wbr></wbr></wbr></wbr>
  23. MAXDATAFILES<wbr>1024<wbr><wbr></wbr></wbr></wbr>
  24. MAXINSTANCES<wbr>32<wbr><wbr></wbr></wbr></wbr>
  25. MAXLOGHISTORY<wbr>292<wbr><wbr></wbr></wbr></wbr>
  26. LOGFILE<wbr><wbr></wbr></wbr>
  27. GROUP<wbr>1<wbr><span>'+DATA/proddb/onlinelog/group_1.346.771671611'</span><span><wbr><wbr>SIZE<wbr>50M<wbr>BLOCKSIZE<wbr>512,<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  28. GROUP<wbr>2<wbr><span>'+DATA/proddb/onlinelog/group_2.341.771671615'</span><span><wbr><wbr>SIZE<wbr>50M<wbr>BLOCKSIZE<wbr>512<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  29. DATAFILE<wbr><wbr></wbr></wbr>
  30. '+DATA/proddb/datafile/system.256.771671395',<wbr><wbr></wbr></wbr>
  31. '+DATA/proddb/datafile/sysaux.282.771671401',<wbr><wbr></wbr></wbr>
  32. '+DATA/proddb/datafile/undotbs1.344.771671403',<wbr><wbr></wbr></wbr>
  33. '+DATA/proddb/datafile/users.343.771671403',<wbr><wbr></wbr></wbr>
  34. '+DATA/proddb/datafile/undotbs2.339.771671757'<wbr><wbr></wbr></wbr>
  35. CHARACTER<wbr>SET<wbr>WE8MSWIN1252<wbr><wbr></wbr></wbr></wbr></wbr>
  36. ;<wbr><wbr></wbr></wbr>
  37. <wbr><wbr></wbr></wbr>
  38. SQL><wbr>@<span>'/tmp/create_ctl.sql'</span><span>;<wbr><wbr></wbr></wbr></span></wbr>
  39. <wbr><wbr></wbr></wbr>
  40. Control<wbr>file<wbr>created.<wbr><wbr></wbr></wbr></wbr></wbr>
  41. <wbr><wbr></wbr></wbr>
  42. SQL><wbr>sho<wbr>parameter<wbr>cluster_<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  43. <wbr><wbr></wbr></wbr>
  44. NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TYPE<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>VALUE<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  45. ------------------------------------<wbr>-----------<wbr>------------------------------<wbr><wbr></wbr></wbr></wbr></wbr>
  46. cluster_database<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>boolean<wbr><wbr><wbr><wbr><wbr>FALSE<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  47. cluster_database_instances<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>integer<wbr><wbr><wbr><wbr><wbr>1<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  48. cluster_interconnects<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><span>string</span><span><wbr><wbr></wbr></wbr></span></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  49. SQL><wbr>shu<wbr>immediate<wbr><wbr></wbr></wbr></wbr></wbr>
  50. Database<wbr>closed.<wbr><wbr></wbr></wbr></wbr>
  51. Database<wbr>dismounted.<wbr><wbr></wbr></wbr></wbr>
  52. ORACLE<wbr>instance<wbr>shut<wbr>down.<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
change the value of the parameter cluster_database to true and startup the database.
  1. SQL><wbr>startup<wbr>pfile=</wbr></wbr>'/tmp/initproddb1.ora';<wbr><wbr></wbr></wbr>
  2. ORACLE<wbr>instance<wbr>started.<wbr><wbr></wbr></wbr></wbr></wbr>
  3. <wbr><wbr></wbr></wbr>
  4. Total<wbr>System<wbr>Global<wbr>Area<wbr>1054593024<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  5. Fixed<wbr>Size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>1341196<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  6. Variable<wbr>Size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>339740916<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  7. Database<wbr>Buffers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>708837376<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  8. Redo<wbr>Buffers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>4673536<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  9. Database<wbr>mounted.<wbr><wbr></wbr></wbr></wbr>
  10. Database<wbr>opened.<wbr><wbr></wbr></wbr></wbr>

create new spfile using current pfile.
  1. SQL><wbr>create<wbr>SPFILE=</wbr></wbr>'+DATA/proddb/spfileracdb.ora'<wbr>from<wbr>pfile=</wbr></wbr>'/tmp/initproddb1.ora';<wbr><wbr></wbr></wbr>
  2. <wbr><wbr></wbr></wbr>
  3. File<wbr>created.<wbr><wbr></wbr></wbr></wbr>
  4. <wbr><wbr></wbr></wbr>
  5. SQL><wbr>sho<wbr>parameter<wbr>cluster<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  6. <wbr><wbr></wbr></wbr>
  7. NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>TYPE<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>VALUE<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  8. ------------------------------------<wbr>-----------<wbr>------------------------------<wbr><wbr></wbr></wbr></wbr></wbr>
  9. cluster_database<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>boolean<wbr><wbr><wbr><wbr><wbr>TRUE<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  10. cluster_database_instances<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>integer<wbr><wbr><wbr><wbr><wbr>2<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  11. cluster_interconnects<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><span>string</span><span><wbr><wbr></wbr></wbr></span></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  12. SQL><wbr><wbr><wbr></wbr></wbr></wbr>
  13. SQL>ALTER<wbr>DATABASE<wbr>ADD<wbr>LOGFILE<wbr>THREAD<wbr>2<wbr>GROUP<wbr>3,GROUP<wbr>4;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  14. <wbr><wbr></wbr></wbr>
  15. SQL><wbr>ALTER<wbr>DATABASE<wbr>OPEN<wbr>RESETLOGS;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>

create a new init pfile in the dbs directory and copy and paste the spfile location.
  1. [oracle@dc1<wbr>dbs]$<wbr>vi<wbr>initracdb1.ora<wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  2. SPFILE='+DATA/proddb/spfileracdb.ora'<wbr><wbr></wbr></wbr>
  3. [oracle@dc1<wbr>dbs]$<wbr>scp<wbr>initracdb1.ora<wbr>dc2:$ORACLE_HOME/dbs/initracdb2.ora<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  4. initracdb1.ora<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>100%<wbr><wbr><wbr>38<wbr><wbr><wbr><wbr><wbr>0.0KB/s<wbr><wbr><wbr>00:00<wbr><wbr><wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  5. <wbr><wbr></wbr></wbr>
  6. create<wbr>a<wbr><span>new</span><span><wbr>password<wbr>file<wbr>on<wbr>both<wbr>servers<wbr></wbr></wbr></wbr></wbr></wbr></wbr></span><span>for</span><span><wbr>database<wbr>racdb.<wbr><wbr></wbr></wbr></wbr></wbr></span></wbr></wbr>
  7. <wbr><wbr></wbr></wbr>
  8. [oracle@dc1<wbr>dbs]$<wbr>orapwd<wbr>file=$ORACLE_HOME/dbs/orapwracdb1<wbr>password=oracle<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  9. [oracle@dc1<wbr>dbs]$<wbr><wbr><wbr></wbr></wbr></wbr></wbr>
  10. <wbr><wbr></wbr></wbr>
  11. [oracle@dc2<wbr>~]$<wbr>cd<wbr>/u01/app/oracle/product/11.2.0/db_1/dbs<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  12. [oracle@dc2<wbr>dbs]$<wbr>orapwd<wbr>file=$ORACLE_HOME/dbs/orapwracdb2.ora<wbr>password=oracle<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  13. [oracle@dc2<wbr>dbs]$<wbr><wbr><wbr></wbr></wbr></wbr></wbr>
  14. <wbr><wbr></wbr></wbr>
  15. add<wbr>an<wbr>entry<wbr><span>in</span><span><wbr>the<wbr>/etc/oratab<wbr>file<wbr>on<wbr>both<wbr>servers<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></span></wbr></wbr></wbr>
  16. [oracle@dc2<wbr>~]$vi<wbr>/etc/oratab<wbr><wbr></wbr></wbr></wbr></wbr>
  17. racdb2:/u01/app/oracle/product/11.2.0/db_1:N<wbr><wbr></wbr></wbr>
  18. <wbr><wbr></wbr></wbr>
  19. [oracle@dc1<wbr>~]$vi<wbr>/etc/oratab<wbr><wbr></wbr></wbr></wbr></wbr>
  20. racdb1:/u01/app/oracle/product/11.2.0/db_1:N<wbr><wbr></wbr></wbr>
  21. [oracle@dc2<wbr>~]$<wbr>.<wbr>oraenv<wbr><wbr></wbr></wbr></wbr></wbr></wbr>
  22. ORACLE_SID<wbr>=<wbr>[oracle]<wbr>?<wbr>racdb2<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  23. The<wbr>Oracle<wbr><span>base</span><span><wbr></wbr></span><span>for</span><span><wbr>ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1<wbr></wbr></wbr></span><span>is</span><span><wbr>/u01/app/oracle<wbr><wbr></wbr></wbr></wbr></span></wbr></wbr>
  24. [oracle@dc2<wbr>~]$<wbr>sqlplus<wbr>/<wbr><span>as</span><span><wbr>sysdba<wbr><wbr></wbr></wbr></wbr></span></wbr></wbr></wbr></wbr>
  25. <wbr><wbr></wbr></wbr>
  26. SQL*Plus:<wbr>Release<wbr>11.2.0.1.0<wbr>Production<wbr>on<wbr>Sun<wbr>Jan<wbr>8<wbr>23:36:03<wbr>2012<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  27. <wbr><wbr></wbr></wbr>
  28. Copyright<wbr>(c)<wbr>1982,<wbr>2009,<wbr>Oracle.<wbr><wbr>All<wbr>rights<wbr>reserved.<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  29. <wbr><wbr></wbr></wbr>
  30. Connected<wbr>to<wbr>an<wbr>idle<wbr>instance.<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  31. <wbr><wbr></wbr></wbr>
  32. SQL><wbr>startup<wbr><wbr></wbr></wbr></wbr>
  33. ORACLE<wbr>instance<wbr>started.<wbr><wbr></wbr></wbr></wbr></wbr>
  34. <wbr><wbr></wbr></wbr>
  35. Total<wbr>System<wbr>Global<wbr>Area<wbr>1054593024<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  36. Fixed<wbr>Size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>1341196<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  37. Variable<wbr>Size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>339740916<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  38. Database<wbr>Buffers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>708837376<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  39. Redo<wbr>Buffers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>4673536<wbr>bytes<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  40. Database<wbr>mounted.<wbr><wbr></wbr></wbr></wbr>
  41. Database<wbr>opened.<wbr><wbr></wbr></wbr></wbr>
  42. SQL><wbr><wbr><wbr></wbr></wbr></wbr>
  43. <wbr><wbr></wbr></wbr>
  44. SQL><wbr>select<wbr>name<wbr>from<wbr>v$database;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  45. <wbr><wbr></wbr></wbr>
  46. NAME<wbr><wbr></wbr></wbr>
  47. ---------<wbr><wbr></wbr></wbr>
  48. RACDB<wbr><wbr></wbr></wbr>
  49. <wbr><wbr></wbr></wbr>
  50. SQL><wbr>select<wbr>instance_name,status<wbr>from<wbr>gv$Instance;<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  51. <wbr><wbr></wbr></wbr>
  52. INSTANCE_NAME<wbr><wbr><wbr><wbr>STATUS<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  53. ----------------<wbr>------------<wbr><wbr></wbr></wbr></wbr>
  54. racdb1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>OPEN<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
  55. racdb2<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>OPEN<wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
register the database with grid.

[oracle@dc1 dbs]$ srvctl status database -d racdb
PRCD-1120 : The resource for database racdb could not be found.
PRCR-1001 : Resource ora.racdb.db does not exist

[oracle@dc1 dbs]$ srvctl remove database -d proddb
Remove the database proddb? (y/[n]) y
[oracle@dc1 dbs]$ srvctl add database -d racdb -o $ORACLE_HOME
[oracle@dc1 dbs]$ srvctl add instance -d racdb -i racdb1 -n dc1
[oracle@dc1 dbs]$ srvctl add instance -d racdb -i racdb2 -n dc2

[oracle@dc1 dbs]$ srvctl status database -d racdb
Instance racdb1 is not running on node dc1
Instance racdb2 is not running on node dc2

[oracle@dc1 dbs]$ srvctl start database -d racdb
[oracle@dc1 dbs]$ srvctl status database -d racdb
Instance racdb1 is running on node dc1
Instance racdb2 is running on node dc2

finally, Change the instance names in the tnsnames.ora and listener.ora files.

regards,
Rajesh Kumar Govindarajan.
iteye_4537
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值