Duplicate RAC Database With ASM And 2 Nodes To A Single Node?

Apr 30, 2010

i'm trying to duplicate my RAC database with ASM and 2 nodes to a single node, non ASM with rman duplicate database for standby with active database on windows. The problem is i dont know how to remove RAC configuration when duplicating the database.

Here is the procedure:

On standby i've:
- installed database software,
- configured listener and tnsnames,
- added instance service (oradim -new -sid STANDBY -intpwd PASSWORD -startmode M),
- configured initora (with only db_name = STANDBY)
- configured orapwd file
- startup nomount

on RAC node1:

rman target sys/PASSWORD@RAC
connected to target database
RMAN> connect auxiliary sys/password@STANDBY
connected to auxiliary database: STANDBY (not mounted)

now for the duplicate command:

RMAN> duplicate target database
2> for standby
3> from active database
4> spfile
5> parameter_value_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY'
6> set db_unique_name='STANDBY'
7> set log_file_name_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY'
8> set db_file_name_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY';

i have tried adding this parameter - set cluster_database='false' but no luck.

View 7 Replies


ADVERTISEMENT

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?

View 3 Replies View Related

RMAN :: Clone 2 Node RAC Database To Single Instance Non-RAC Database Using Existing Backup

Jul 25, 2012

I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:

rman auxiliary sys/******@dbracdup
RMAN> duplicate database to dbrac spfile backup location '/oracle/backup';
...
...
Finished recover at 25-JUL-12
Segmentation fault

And the database was in mount stage, and when i tried to open database it failed with below error:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database .

View 4 Replies View Related

SQL & PL/SQL :: Permissions On Given Leaf Node Then All Parent / Grand Nodes Should Return?

Feb 4, 2012

writing an SQL query for the following scenario : have table ACCOUNTS that stores results in parent child relationship.

ACCT_ID |ACCT_NAME |ACCT_PARENT |ACCT_TYPE
1 |Group1 | 0 | 1
2 |Group2 | 1 | 1
3 |Group3 | 2 | 1
4 |Account1 | 3 | 0
5 |Account2 | 3 | 0
6 |Account3 | 2 | 0

Here ACCT_TYPE=0 denotes leaf node.Another table USER_ACCOUNT stores user permissions on the leaf nodes from ACCOUNTS table.

USER_ID |ACCT_ID| PROPERTY
1 | 4| Yes
2 | 5 | No
3 | 6| Yes

This shows user=1 has permission on Account=4 , user=2 does not have access priviledge on Account_id=5.Now my requirement is to write a SQL query such that If user has permissions on a given leaf node then all the parent / grand parent nodes should also be returned.
Eg:
SELECT * FROM (.......) where USER_ID=2;

should give result something as below :

USER_ID | ACCT_ID |ACCT_NAME | PROPERTY
1 | 4 | Account1 |Yes
1 | 3 | Group3 |Yes
1 | 2 | Group2 |Yes
1 | 1 | Group1 |Yes

with this ASAP as this is quite an urgent issue that I need to fix.

View 15 Replies View Related

RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?

Sep 13, 2012

I would like get more details about single node RAC.. What is single Node RAC?..

1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...

is there any advantage using single node rac(other than online upgrade to full RAC).

View 3 Replies View Related

From Oracle 10g Single Instance To 11g R2 Two Nodes RAC

Aug 17, 2011

Initial situation: Oracle 10g database single instance on Windows 2008 (datafile within NTFS partition)
Final situation: same database upgraded to Oracle 11g r2 on a two nodes RAC on Windows 2008 (datafile within ASM)

In your opinion, is this the best way to achieve the job ?

1) on the two nodes install grid 11gr2, asm, rdbms 11g r2 (SE)
2) export full from 10g
3) create a new empty 11g r2 database in the RAC 11g r2 infrastructure with the same tablespace layout of 10g database
4) import full from 10g to 11g r2

View 1 Replies View Related

Real Application Clusters :: Removing 2 Nodes From A Cluster Of 4 Nodes?

Nov 6, 2012

[URL] I arrived at step 2 (Step 2: Delete Nodes from the Cluster) point 4 and 5.

I executed this correctly (on 2 nodes):

For a nonshared home:

To delete a node from a cluster:

./runInstaller -updateNodeList ORACLE_HOME=Oracle_home CLUSTER_NODES="" –local

Output:

[oracle@server03 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES="" -local
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 20127 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.then I executed:

To deinstall the Oracle home from the node you are deleting, run the following command from the Oracle_home/oui/bin directory:

./runInstaller -deinstall -silent "REMOVE_HOMES={Oracle_home}" -local

Output:
[oracle@server03 bin]$ ./runInstaller -deinstall -silent "REMOVE_HOMES=$ORACLE_HOME" -local
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 20127 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-11-06_12-05-36PM. Please wait ...[oracle@server03 bin]$ Oracle Universal Installer, Version 11.1.0.7.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.

[code]....

When I arrive to the point 5 I see one resource ora.DPCTTest.db ONLINE on one server (server02 or server03 that are the nodes I want to remove).
If I execute:

crs_relocate ora.db_name.db

I obtain:
[oracle@server03 bin]$ ./crs_relocate  ora.DPCTTest.db
Attempting to stop `ora.DPCTTest.db` on member `server02`
Stop of `ora.DPCTTest.db` on member `server02` succeeded.
Attempting to start `ora.DPCTTest.db` on member `server03`

[code]....

View 5 Replies View Related

JDeveloper, Java & XML :: Extracting Sub-nodes From XML With Multiple Nodes?

Oct 27, 2011

how to extract sub nodes from multi nodes in this file.

<?xml version="1.0" encoding="utf-8"?>
<Orders>
<LeasingCoNum>123456</LeasingCoNum>
<DateTime>10/05/2011 10:00:00 AM</DateTime>
<NewOrders>
<Order>

[code]....

View 9 Replies View Related

RAC & Failsafe :: Single Node - Online / Offline

Dec 5, 2012

I have implemented Rac One node with two machine(dbtest01,dbtest02) in 11.2.0.3 Redhat 5.3 one for online another one for offline. i have created TAF also.

dbtest01 is online and create one query
DECLARE
i number(36):=1;
begin
while(i<10000000)
loop
dbms_output.put_line(i);
i:=i+1;
end loop;
end;

i executed above query for test and i made relocate database using srvctl utility to dbtest02 machine.

session is relocated successfully with new session id...above query getting stop in 25000 itself. i want to make it continue that process..also i tried to find Omotion utility in all the path.. couldn't find it... where will it be.. i want to relocate all the session without losing work.

from application i am getting disconnect after relocation.. application server need to restart to get work again...

View 2 Replies View Related

Setup Oracle 11gR2 Single Node At Linux?

Jan 11, 2011

I need to setup Oracle 11gR2 single node @ Linux RHat 5 64-bit for long performance tests, huge loads, high speeds, a lot of transactions, having a good scalability, etc.

It's not a production server, but for strong system/volume tests.

CPU
Motherboard
Memory
HDD
Network

View 2 Replies View Related

SQL & PL/SQL :: Duplicate On A Single Column

Sep 23, 2010

I have a table with multiple columns and I need to retrieve the ones where column a stores duplications for records where column b is discrepant

this is the table

NAME_ID PHONE_NUMBER
12345 +41 22 595 5555
12345 +41 22 595 5555
12342 +41 22 595 5500
12340 +41 22 595 5555

the query should return

NAME_ID PHONE_NUMBER
12345 +41 22 595 5555
12340 +41 22 595 5555

The closest I got was with the below, but this also returns duplicates within the same NAME_ID.

select phone_number, name_id
from name_phone
where (phone_number) in
(select phone_number
from name_phone
group by phone_number
having count(*) > 1)
group by phone_number, name_id
order by phone_number

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Verification Of Steps To Convert Single Node To RAC

Jan 16, 2013

I have a single node Oracle E-Biz 12.1.3 Installation.We plan to convert this to a dual node RAC install and I wanted to run by the steps to perform this AND clone over the current production system to the new RAC system (note this will not be using ASM - but will be based on NetApp NFS)

1. Install GRID 11.2.0.3
- installed acorss two nodes, Binaries can be shared
- voting disks / cluster rigistry MUST be shared

2. Install Database Software for RAC
- Binaries cannot be shared and must be installed on each node independently

3. Configure the GRID for database (database / listeners)

4. Clone over the stand alone system (clone database as RAC)

I will be using SCAN - and therefore would expect all the web services / concurrent manager nodes to point to the SCAN hostname as opposed to individual host names.

View 1 Replies View Related

Real Application Clusters :: One Node Or Clusterware Single Instance Failover?

Aug 21, 2012

I am trying to design a database consolidation high-availability cluster for Oracle 11g R2 64-bit Enterprise Edition (X86-64) on Oracle Linux 6.x UEK, using Oracle 11.2.0.3 (the latest as of Aug 2012).

We don't need RAC Multi-Node now or in foreseeable future because none of the databases we run break the capacity of a single node. Likewise, we don't need to use Oracle VM to virtualise the database instances.

We plan to use SGA and PGA memory management to run multiple instances on same hardware operating on a single Linux 64-bit O/S image.Does it sound ok so far?

Two or three of 4-socket, 40-core Intel 64-bit servers with 512GB of RAM each (relatively cheap at today's HW commodity prices) will be sufficient to run all Oracle databases we have on Linux 64-bit.So the two HA options that I know of are:

(1) use Oracle Clusterware/Grid/ASM to provide for instance failover
(2) use Oracle RAC One Node on top of Clusterware/Grid/ASM

As I understand it RAC One Node is significantly more expensive than the "free" Oracle Clusterware/ASM/Grid (since we own Oracle 11.2.0.3 Enterprise Licences already). So why should my employer pay for RAC One Node licence given they already own Single Instance Fail-Over and Restart protection from Clusterware/Grid/ASM ?

I also read that Data Guard 11.2 may not be supported with RAC One Node on 11.2? True? Will same Data Guard 11.2 work with a Single-Instance Failover running on Clusterware/Grid/ASM ?

-Who is running RAC One Node? Why?
-Who is running Single Instance Failover with Clusterware? Why?
-Who is using Data Guard with either of the above?

View 4 Replies View Related

SQL & PL/SQL :: Get Single Row From Multiple Duplicate Values Of One Field?

Sep 10, 2012

CREATE TABLE prim_tbl
(id NUMBER,--- id is not primary key here
description VARCHAR2(30));

INSERT ALL
INTO prim_tbl VALUES (1,'aad')
INTO prim_tbl VALUES (1,'aads')
INTO prim_tbl VALUES (2,'bb')
INTO prim_tbl VALUES (2,'cc')
INTO prim_tbl VALUES (2,'dd')
SELECT * FROM dual;

I want to select the ids only one time, i.e my output will have only two rows: one row with id as 1 and other row with id 2 whatever be the description.

desired output sample:

Quote:1, aad
2, bb

I used:
select distinct(id),description from prim_tbl;

but it did not give the required result.How can I get it??

View 6 Replies View Related

Install Multiple Versions Of Oracle Databases 10GR2 And 11GR2 In A Single Node?

Oct 28, 2010

ORACLE DBA
EXPERTS

�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?

View 6 Replies View Related

RMAN Duplicate Target Database For Standby From Active Database

Aug 23, 2010

I have failed to duplicate target db for standby from active db using spfile with the following errors:

RMAN-03009: failure of backup command on prim1 channel at 08/11/2010 05:25:09
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist

[Code].....

The script has successfully created on standby db all controlfiles and also has copied 2 data files DATA01.DBF and DATA02.DBF into the correct location. Then the errors above kicked in and stopped the rman dup process.

View 4 Replies View Related

RAC/ASM Clusterware Installation :: Query On Adding New Node To Existing 2 Node Cluster

Jun 15, 2012

current environment

Oracle VM 2 Node RAC cluster
Oracle 11G 11.2.0.3.0
Oracle 11g rel 2 GI

on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2

we shutdown vmorarac1 to clone it to vmorarac5

on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211

mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5

152.144.199.171 vmorarac1.pbi.global.pvt vmorarac1
192.168.2.30 vmorarac1-priv.pbi.global.pvt vmorarac1-priv
152.144.199.184 vmorarac1-vip.pbi.global.pvt vmorarac1-vip

[Code]....

Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2

152.144.199.210 vmorarac2.pbi.global.pvt vmorarac2
192.168.2.32 vmorarac2-priv.pbi.global.pvt vmorarac2-priv
152.144.199.211 vmorarac2-vip.pbi.global.pvt vmorarac2-vip

hostname change in /etc/sysconfig/network

On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1

addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing

View 3 Replies View Related

Data Guard :: How To Find Apply Node In RAC Two Node Standby DB

Aug 16, 2013

I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?

I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: VIP Node Application Failing In Second Node

Jul 18, 2013

I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below

[root@Rhel52 bin]# ./crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy[root@Rhel52 bin]#[root@Rhel52 bin]# clear[root@Rhel52 bin]#[root@Rhel52 bin]# ./crs_stat -tName           Type           Target    State              Host------------------------------------------------------------------------------------ora.rhel5.gsd  application     ONLINE    ONLINE      rhel5ora.rhel5.ons  application     ONLINE    ONLINE      rhel5ora.rhel5.vip  application      ONLINE    ONLINE       rhel5ora.rhel52.gsd application    ONLINE    ONLINE     rhel52ora.rhel52.ons application    ONLINE    ONLINE     rhel52ora.rhel52.vip application     ONLINE     ONLINE      rhel52 [root@Rhel52 bin]#./runcluvfy.sh stage -post crsinst -n 

[code]....

View 0 Replies View Related

Two-node RAC Database Running On Solaris 5.8

Jun 1, 2013

We have an Oracle 9i (9.2.0.7) two-node RAC database running on Solaris 5.8. Recently we have switched our production database from no archive log mode to archive log. We changed the parameter CLUSTER_DATABASE=FALSE on one of the instances before converting and reverted back.why this parameter needs to be changed to false?

View 2 Replies View Related

10.2.0.4.0 Two Node RAC - Collection Cause Database Performance To Go Down In AWR?

Jul 16, 2012

we had an issue with our 10.2.0.4.0 two node RAC Database where when running stats collection caused the database performance to go down and in AWR I noticed the following:

Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
gc buffer busy 95,077 73,786 776 76.0 Cluster
cursor: pin S wait on X 3,524,808 54,467 15 56.1 Concurrency
library cache lock 30,223 13,660 452 14.1 Concurrency
gc cr request 2,876 3,594 1,250 3.7 Cluster
library cache pin 1,740 1,800 1,035 1.9 Concurrency

when looked under Library Cache Activity section in the AWR report, I see the following:

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 59 3.39 3,056 0.13 1 0
CLUSTER 70 0.00 73 0.00 0 0
INDEX 178 0.00 925 0.00 0 0
SQL AREA 423,064 50.25 2,465,209 2.37 182 119,671
TABLE/PROCEDURE 1,848 21.27 22,638 0.62 70 0
TRIGGER 14 0.00 1,801 0.06 1 0

does this mean, we are having memory crunch for this instance on node 1? we have sga_target=26gb and sga_max_size=32gb set for this instance.

View 2 Replies View Related

RAC & Failsafe :: Can Create Directory On Two Node Database

Feb 2, 2013

here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.

View 3 Replies View Related

RAC & Failsafe :: 5 Node Database - Services Management

Aug 17, 2012

We have 5 node RAC database. I want to user 2 node for OLTP and 3 for DSS system. Guide now to create service for the requirement.

View 10 Replies View Related

RAC & Failsafe :: ORA-01033 On One Node But Database Is Started

May 23, 2012

we encounter a problem with a 2-nodes RAC with 11gR2 SE : Database RAC is correctly running but we encounter problems using RAC TNS entry, obtaining the message ORA-01033.We can access to the DB using a TNS entry using each one of IP addresses but when we use the SCAN address, it fails. 2 weeks ago RAC2 node could connect perfectly with the SCAN address but RAC1 (used as a client) obtained error message almost 30% of tries.

We made a reboot of RAC1 node and now SCAN address works correctly from RAC1 and RAC2 (used as a client) fails systematically with SCAN address but works perfectly with direct access to the database.On both nodes, SCAN address is perfectly resolved by DNS server, cluster seems correct, listeners seems correct...We have opened an SR on Metalink 4 weeks ago but we don't progress.

View 4 Replies View Related

JDeveloper, Java & XML :: How To Select Node From Oracle Database

Jun 10, 2012

<RCA>
<SUB_PROBLEM_TYPE>
Bla bla bla...............
</SUB_PROBLEM_TYPE>

[Code]....

I wish to generate in my html form like..

PREVENTION: bla bla bla....

Is there any simple way to query out ?

I try

"SELECT T1.root_cause_analysis.query('/RCA/PREVENTION') as RCAXML from Submission_Record.............."

set rx=server.createobject("adodb.recordset")
rx.open sqlxmltest,con,1,3
while not rx.eof

<table>
<tr>
<td ><% response.write rx("RCAXML")%></td>
</tr>
</table>

BUT IT GIVE ME AN ERROR... [ORA-22806: not an object or REF]

View 3 Replies View Related

RAC & Failsafe :: Configure Oracle Dataguard For 2 Node Database

Oct 28, 2010

We have to configure Dataguard for our 24x7 critical banking 2 Node RAC database(10.2.0.4). Before proceeding with the configuration we have to make sure what steps we should follow to have minimum or no downtime.

1) Document covering DG setup in RAC environment.
2) We have to perform switchover as well so need its steps too. Either the normal switchover steps would be used or have to stop/start rac services as well.

View 7 Replies View Related

Duplicate Database Name

Apr 25, 2012

I have two questions:

can i have two databases with exact names - but in different oracle home? will oracle let me create two identical database name in same oracle home?

View 2 Replies View Related

Duplicate Database To Another Host

Mar 10, 2013

I will be duplicating my production database back to a few weeks ago on my test server, to retrieve certain data. I am running 11g standard edition, not using a recovery catalog.

Below are the basic steps I plan to take in a nutshell.

1. Copy the backup files to the test system

2. In the rman run block (on the test server)
A. Set newname for each of the datafiles and tempfiles (don't have many files)
B. Duplicate command to point in time, specifying backup location and no filename check.

3. Export the data

View 6 Replies View Related

Add Third Node To Existing Two Node Cluster

Feb 3, 2012

I'm trying to add the third node to my existing two node cluster. In fact i succeded adding the node but i have the following problem:

-when i start node 1 and 2, everything is ok, but on node 3 startup one of the other nodes fails
-this happens in any combination: start 1 and 3, everything is ok. when i start node 2, node 3 fails

The asm configuration (disks, permissions, etc) is the same on all three nodes.find below the asm and crsd log details from the failure time:

alert_ASM.log
NOTE: enlarging ACD for group 1/0x124851d1 (DATA)
WARNNING: cache read a corrupted block group=DATA dsk=4 blk=1 from disk 4
+NOTE: a corrupted block from group DATA was dumped to /u01/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_rbal_4109.trc+
WARNNING: cache read(retry) a corrupted block group=DATA dsk=4 blk=1 from disk 4
[code]...

View 3 Replies View Related

Backup & Recovery :: RMAN Duplicate Database

Feb 7, 2011

I want to duplicate a prod database in to a dev db.I am using catalog database to connect to target and auxiliary datbase.I copied all backupsets to the local disk on Dev env in the correct path.For RMAN duplicate ,does the backuppeices need to be present on PROD filesystem as well or just DEV filesystem or both.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved