RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies


ADVERTISEMENT

RAC & Failsafe :: Database Instance Using Srvctl Command

Aug 13, 2013

Would there be any issue in application and database when i down RAC database instance using below srvctl command ?

srvctl stop instance -d DB -i DB1
srvctl start instance -d DB -i DB1

View 18 Replies View Related

RAC & Failsafe :: Query On Dependency Between Database Instance And Service?

Jul 8, 2013

suggest on the dependenecy between the database service and the database instance?

srvctl start instance -i db1
will this start service as well for which the above instance is either preferred or available instance?
will it start the listener as well?

srvctl stop instance -i db1
will this stop service as well for which the above instance is either preferred or available instance?
will it stop the listener as well?

srvctl start service -d db -s dbserve
will this start service as well for which the above instance is either preferred or available instance?

srvctl stop servive -d db -s dbserve
will this stop service as well for which the above instance is either preferred or available instance?

srvctl start database -d db
will it start instance, listener and service as well?

srvctl stop database -d db
will it stop instance, listener and service as well?

View 1 Replies View Related

Single Instance Non-Grid To Single Instance Grid Database

Aug 27, 2012

I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.

Here is what I've done:

1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:

RMAN> backup as copy database format '+ASM_DATA_DG';

Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:

===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:

[Code]....

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                22-AUG-2012 06:08:53
Uptime                    2 days 2 hr. 50 min. 48 sec
Trace Level               off

[Code]....

View 10 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

Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?

May 4, 2011

I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?

View 1 Replies View Related

Clusterware :: Can Use Grid Infrastructure 11.2 To Protect A Single Instance Database

Oct 12, 2012

I would like to use Oracle Grid Infrastructure to protect a single-instance database.

I found these docs:

[URL]

I was unable to find a similar document for GI 11.2 . Do you know if such a document exists?

At the moment I only know that the GI is free if used for an Oracle Product, but I am not shure whether it can be used to protext external applications or single-instance databases

View 4 Replies View Related

Data Guard :: Primary Database Is RAC And Physical Standby Is Single Instance

Mar 27, 2013

I am using Oracle RAC 11.2.0.3 as primary database, we are going to start using Oracle data guard. So I am designing my infrastructure and planing to use Oracle 11.2.0.3 Single instance as my physical stand by database.

My question is it feasible to have my standby database as single instance while the primary is RAC? is it feasible to build my Oracle single instance standby database from the RMAN backup of the RAC primary database? Is there any restrictions (or any points to be taken into consideration) since my primary database is RAC while the physical standby is Oracle single instance?

in the below link

[URL].......

it was mentioned that primary can be RAC or single and same for standby, but my question is it feasible to have primary as RAC while standby as single instance? or it should be like each others?

The primary database can be either a single-instance Oracle database or an Oracle Real Application Clusters (RAC) database. Similar to a primary database, a standby database can be either a single-instance Oracle database or an Oracle RAC database.

View 7 Replies View Related

Real Application Clusters :: Convert 10g Single Instance (uses ASM) Database To RAC - Reconfigure Fails?

Oct 5, 2012

I have 11gR2 GI installed on two nodes. I am trying to convert a 10g single instance (uses ASM) database to RAC and getting this error. I am trying using 12c as well as manually by using rconfig.

[main] [21:19:15:145] [ASMInstance.initialize:135] First record =[Ljava.lang.String;@958bb8
java.lang.NullPointerException
at oracle.sysman.assistants.rconfig.engine.ASMInstance.initialize(ASMInstance.java:153)
at oracle.sysman.assistants.rconfig.engine.Step.execute(Step.java:283)

[code]...

View 1 Replies View Related

Data Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?

Jul 1, 2010

Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?

View 1 Replies View Related

Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home

Sep 29, 2011

We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.

View 2 Replies View Related

DB Migration Into Schema Or Instance?

May 17, 2011

I have a large Sybase db that is using Documentum as the front end tool to create apps. Total DB size is around 12 GB.

I would like to migrate into Oracle 10 RAC. Should I add to our current RAC instance with a new Schema or ask our DBA for a new instance?

View 3 Replies View Related

RAC & Failsafe :: DB Migration To New SAN?

Apr 30, 2012

We have to perform migration for our RAC database to new SAN that is at new data centre. Since OS is IBM AIX, we can take backup from mksysb for VG and and storage will migrate data from OLD SAN to NEW SAN.

But even we restore VG and SAN data but since our old SAN is emc and new SAN is hitachi, so disk path for all the asm disk group will be changed.

So is there will be any way to rename this disk path for disk group..

View 1 Replies View Related

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

RAC & Failsafe :: Test Environment - SAN Migration?

Feb 15, 2012

We have a RAC in a test environment.It's 2 nodes connecting to an IBM DS3512. The DS3512 has one pool of 8 hard disks (RAID10) which has been then sliced into logical drives:

2 x 1GB
then
2 * 400GB

I have been tasked with changing the current configuration as follow:

2 pools of 4HDs in a RAID10 configuration

Then from the first pool:
2 * 1GB
1 * 398GB

from 2nd pool:
1 * 400GB

What I intend to do:
1) shutdown
SQL> shutdown immediate;
./srvctl crs stop
2) backup
dd if=votingdisk of=voting_disk_backup
I already got backups of OCR in $CRS_HOME/cdata/crs/
3) Perform changes on SAN
4) recreate ocfs2 partitions
5) mount the disks to their folder.
6) recovery
recover voting from backup
recover ocr from backup
7) Turn service on again
./srvctl crs start
SQL> startup;

Would this scenario work. There can be some glitches like the disk names changing after the reconfiguration but I only need to modify fstab for that.

View 3 Replies View Related

RAC & Failsafe :: ORA-29760 - Instance Number Parameter Not Specified?

May 7, 2012

I am getting above error when i ma starting my rac data guard on linux. i specify instance number but still its asking

this is my pfile

timsdr1.__db_cache_size=4345298944
timsdr2.__db_cache_size=4395630592
timsdr2.__java_pool_size=33554432
timsdr1.__java_pool_size=33554432

[code]...

View 3 Replies View Related

RAC & Failsafe :: ASM Instance Not Started On Node 2 In Clusterware

Jan 11, 2011

i am configuring asm on clusterware when i create instance on node1 and node 2 a message screen appear " Cant start asm instance on node 2)When i start asm instance manually on node 2 i found the below error in alert log file.

ORA-27508 IPC error sending a message
ORA-27300 OS system dependent operation:send msg failed with status: 101
ORA-27301 OS failure message: Network is unreachable
ORA-27302 failure occurred at: sskgxpsnd1

View 3 Replies View Related

RAC & Failsafe :: Rac.vip.lsnr Instance Shutdown And Restart Itself?

Jul 7, 2011

'm using oracle rac 10.2.0.4.0 with 3 node and os SLES 10 sp 3 in early days we get error vip and lsnr service on my rac shutdown n restart itself,what happen to my rac ?

View 1 Replies View Related

RAC & Failsafe :: Hierarchy To Stop And Start Oracle RAC Instance

Apr 20, 2013

What is the hierarchy to stop and start oracle RAC instance ?

View 10 Replies View Related

RAC & Failsafe :: ORA-15077 / Could Not Locate ASM Instance Serving Required Diskgroup

Oct 7, 2013

When I try to start the database or ASM instance its showing the following error.

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+FLASH_RECOVERY_AREA/XXXXX/spfileXXXXX.ora'
ORA-17503: ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA/XXXXX/spfileXXXXXX.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>

when am trying to view the data's by below Sql its show name as null for FLASH_RECOVERY_AREA. so I couldn't even set compatible ATTRIBUTE

SQL> select NAME , COMPATIBILITY, DATABASE_COMPATIBILITY from V$ASM_DISKGROUP;
NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------- ---------------------- -----------------------------------
RUBIKON_DATA 10.1.0.0.0 10.1.0.0.0

SQL> show parameter asm_disk
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string RUBIKON_DATA, FLASH_RECOVERY_A
REA
asm_diskstring string /dev/mapper/Rubikon_data1, /dev/mapper/Rubikon_data2, /dev/mapper/Rubikon_fb

because of name is null mount mode as CLOSED and HEADER_STATUS as INCOMPATIBLE.

SQL> select name, mount_status, header_status,mode_status,state, path from v$asm_disk ;
NAME MOUNT_S HEADER_STATU MODE_ST STATE PATH
-------------- ------- ------------ ------- -------- -------------------------
CLOSED INCOMPATIBLE ONLINE NORMAL /dev/mapper/Rubikon_fb
RUBIKON_DATA_0000 CACHED MEMBER ONLINE NORMAL /dev/mapper/Rubikon_data1
RUBIKON_DATA_0001 CACHED MEMBER ONLINE NORMAL /dev/mapper/Rubikon_data2

View 1 Replies View Related

RAC & Failsafe :: Can't START Instance After Apply Critical Patch And Reboot

Apr 21, 2011

This is 2 node RAC database. Usually every month my system admin was applying OS critical patch then reboot the server.

While doing this activity i have stop all CRS and DB services. As usual i have did same in both the nodes and applied the patch and reboot the server.

After tried to start the CRS service and database services was used the following command. Except node1 instances all services are started.

E:oraclecrsproduct11.1.0crsBIN>crs_Stat -t
Name Type Target State Host
------------------------------------------------------------
ora....main.db application ONLINE ONLINE inf-...b-03
ora....n1.inst application ONLINE OFFLINE
ora....n2.inst application ONLINE ONLINE inf-...b-04
ora....SM1.asm application ONLINE ONLINE inf-...b-03

[code].....

Then i have tried to applied to old ocr backup also, then also i am getting same error.

View 1 Replies View Related

Use ASM On VMDKs For Single Instance 11gR2 DB?

Jul 3, 2010

I am planning a single instance database using Oracle 11gR2 Enterprise. The instance will run on OEL 5.5 which is on VMWare ESX 3. All disk space will be provisioned as VMDKs. The physical disk comes from a NetApp 7 controlled SAN with multiple disk arrays (one fast disk array and one slower disk array) using NetApp's RAID-DP (RAID-6).

Is there any benefit to using ASM in this single instance configuration ? It seems the data is already being striped, balanced, deduped, and (somewhat) protected by ESX, NetApp, and RAID-DP. NetApp SnapShot provides additional back-up options.

I am thinking without ASM, I could have one 1 TB LUN, say /u01, for the binaries, data files, and management files on the fast disk array and one 1 TB LUN, say /r01, for the flashback recovery area and all other recovery related files on the slower disk array. With autosize capabilities, any of the files can expand as needed up to the 1 TB capacity. 1 TB per disk array is the resource allocation for this instance.

With ASM, on the fast disk array I would have one 32 GB LUN for binaries and other files which must be outside of Oracle's CFS under ASM and then four 248 GB LUNs to create the ASM disk group DATA. On the slower disk array I would have four 256 GB LUNs to create the ASM disk group FRA.

View 1 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

Implementation Of RAC To Non-RAC (Single Instance With Existing ASM-RAC As Storage)

Jan 13, 2013

We have an existing RAC on our Data Center and We have an IBM AIX that is designed to run a Synchronous Peer to Peer Remote copy(PPRC) that used to copy data to a remote site for Disaster Recovery Purposes.

Scenario will be,

Since that our Server from the DR site have a PPRC capability it used a remote copy of our ASM-RAC (from our Data center) as storage.
Is it possible that we install a Single Instance to our DR-Site and used the copy of our ASM-RAC as storage?

View 3 Replies View Related

Created Another Instance On Single Machine - Possible To Run Both Parallel

Feb 20, 2013

i have created an another instance on a single machine i got error when starting up a new one - error starting up database in exclusive mode so i shutdown older database instance , to start new one now is it possible to run both instance parallel?

View 11 Replies View Related

Possible Strategies For Restoring A Single Tablespace From Instance A To B

Jan 17, 2013

SO....: Win 7 64bits
DB....: Oracle 11.2.0.3 EE 64 bits

In my notebook, i have 2 instances (orateste and ora11). They are all for testing purpose. I don't know what happened but, a problem in a partition of my SO made the Oracle software unavailable. I cannot start instance orateste. Even the windows service related to the instance have disappeared from services.msc. What i want to do is to restore only one tablespace from instance orateste to ora11. I have a full rman database backup from D-1.

1) Restore the entire database (orateste - 11.2.0.1) to ora11(11.2.0.3)?

2) Is there a way to restore only one tablespace, between instances and versions?

View 3 Replies View Related

Upgrade :: 10gR2 Single Instance To 11gR2 RAC?

Aug 3, 2012

upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.

View 3 Replies View Related

Data Guard :: Upgrade Oracle 9i R2 Single Instance To 11G R2 RAC?

Feb 17, 2011

There is a Single Instance production server Oracle 9iR2 [9.2.0.8] OS HP-UX PARISC 11i v1 to RAC.

Now we want to migration this server with minimum downtime to Oracle 11gR2 [11.2.0.2] in RAC environment OS HP-UX 11i v3 Itanium DOwn time must be minimum. what will be the procedure ?

View 6 Replies View Related

Data Guard :: 11.1.0.7 RAC Primary To Single Instance Standby Using 11.1.0.6

Mar 2, 2011

Primary:

2 NODE RAC Cluster/Linux x86-64/11.1.0.7.4 RDBMS

Standby server:

Brand new box, and I installed 11.1.0.6 (software only)

I have a brand new box set-up for a single-instance standby database, and I have installed 11.1.0.6 software only.

Do I need to patch 11.1.0.6 to 11.1.0.7 before I send a copy of the primary over to be set-up as a standby? If so, how do I patch 11.1.0.6 without having a local database in place as this server will only be used for a standby? Can patching the oracle_home only be done?

View 2 Replies View Related

RAC & Failsafe :: Define DB Connection URL For Two Different SID Names In Single URL?

Apr 3, 2012

As you see in the following MY_DB_URL there are two hosts for one SID. This is works perfectly for oracle driver. When one of them is gone down, connection establishes with the other.

MY_DB_URL = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.104.18)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.104.19)(PORT= 1521))(FAILOVER=true)(LOAD_BALANCE=false)(CONNECT_DATA=(SERVER=DEDICATED)(SID=SIDNAME_1)))

But i have a problem. Our partner uses Golden Gate product, and they said that they must install two different oracle with two different SID names. (For Example one of them is SIDNAME_1 the other is SIDNAME_2) So i can't use this URL in my application.

Is there a way to define a DB connection URL for two different SID names in a single URL?

View 1 Replies View Related







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