In this article, we will see the conversion of the non-RAC database to RAC database using DBCA. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name dbtest testrac Node 1 testrac1 RAC1 Node 2 testrac2 RAC2 Part 1: Create a template from existing database. Step 1: Run DBCA […]
Articles Tagged: non rac
Converting RAC DB to Non-RAC on Normal File System
To convert RAC to Non-RAC DB on normal file system we need to first convert it into ASM storage Converting RAC db to Non-RAC db In this article we will see conversion database from ASM to Normal File System : Step 1 : Check details of ASM database and create pfile from spfile :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
[oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 23 22:52:52 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 23 22:52:52 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select name from v$database; NAME --------- TEST SQL> SQL> SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/test/datafile/system.311.970676549 +DATA/test/datafile/sysaux.310.970676581 +DATA/test/datafile/undotbs1.319.970676607 +DATA/test/datafile/users.320.970676613 SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string +DATA/spfiletest.ora SQL> create pfile from spfile; File created. SQL> SQL> SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> |
[…]
Converting RAC db to Non-RAC db
In previous Articles we have seen conversion from Single Instance DB to RAC db using various methods.In this Article we will see conversion of RAC to Normal DB[Single Instance]. Prerequisites : RAC Instance Node RAC Node Name RAC DB Name RAC Instance Name Single Instance DB name Node 1 RAC1 test db1 test Node 2 […]
Convert Single Instance Database to Oracle RAC
In this post, we can perform Convert Single Instance Database to Oracle RAC in Oracle 11gR2. Prerequisites: we already have single instance ASM database up and running. we have already have second node with ASM running. If you want to how to convert non asm database to asm database with duplicate command: Click Here RAC […]