Two Database - How To Change Indexing Of Primary Key To Skip Some Numbers

May 3, 2011

I have two databases called

a) Old Retailer database
b) New Retailer Database

We cant delete old database but we are using and we want to use both of them.

Now problem

Both dbs have a table called retailer.

I want to prevent duplication in them.

I.e it there is a retailer 12 created in old one new one shldnt allowo us to create retailer

id---12

similarly if there is a retailer 13 in new one it shouldnt be created in old table

retailer ids are unique. its not the case that with retailer id for example 5 there is a

different retailer in these two tables of diffferent DBS. Its unique

Now I have to put this criteria

how can i do it?

Second questions===================

if a primary key is auto increment. how can i skip some numbers lets say it is 1,2,3,4

i want that when next record shld be inserted it shld be 6 not 5. i dont want to feed the value 6. i want to know how to change indexing of primary key to skip some numbers when its set to auto increments.

View 3 Replies


ADVERTISEMENT

Data Guard :: Change Some Parameters On Primary Database?

Sep 29, 2012

I am going to change some parameters on primary database (db cache, java pool etc.). I am not sure, if the changes are automaticallly propagated to standby or if I have to make the changes manually on stanby site too? I couldn't find clear answer in documentation. how parameter changes work in dg physical configuration?

View 2 Replies View Related

Data Guard :: Change Instance Parameter Of Primary Database And Standby

Nov 29, 2011

I have a requirement to change the instance parameter of the primary database and standby in the data guard. Any procedure to do the same. I have to do it directly on production and there is no test set up so I cannot experiment . The procedure I am thinking of is as below.

1. Stop the standby

2. backup the primary

3. Change the parameter and restart to make it effective

4. Start the primary

5. Go to stand by

6. Change the parameter and mount the database.

7. Check if both are in sync and apply logs if not.

View 6 Replies View Related

Data Guard :: Change Server B To Standby Database With A Running As Primary

Oct 4, 2010

I new to data guard concept.

I am using oracle 10g with data guard configured , I have primary ( A ) and standby database ( B ) .But because of some unavoidable conditions the primary database ( A ) got shutdown and was not starting , We shifted the standby database ( B ) at new location and changed it to primary with following command ,

startup mount;
alter database recover managed standby database finish;
alter database commit to switchover to physical primary;
shutdown;
startup;

This new primary ( B ) was open for end users for 2 days during which old primary ( A ) was shutdown .

I took the backup of ( B ) and restored it on A AND shutdown the B . Now A is acting as Primary database. Server B is shutdown . I want to change server B to standby database with A running as Primary .Is it possible ?

View 5 Replies View Related

Data Guard :: How To Change Logical Database Primary To Logical

Jun 9, 2011

We have 2 node (n1 nad n2 ) RAC and 3rd node (n3) with Dataguard logical database for reporting ..

1. logical database (n3) not syn with primary (n1,n2)
2. During repair above mentioned problem by mistake my logical(n3) also become primary
3. now how I will again change my n3 to logical
4. I got following error

RE: ORA-16009: remote archive log destination must be a STANDBY database

View 1 Replies View Related

Indexing Changes Most Of The Blocks Of Database On Storage

Jun 20, 2011

DB: Oracle 10g R2
OS: SUSE Linux SP 1 x864

We are maintaining a DR of our Database Server(oracle 10g R2 atop SUSE SP1 Linux) using Platespin(

[URL]......

Platespin is set to replicate(block based), incremental data(delta) every 1.5 hour from Production to DR site over a 30 Mbps dedicated fiber link.

Our maximum changes of data per day(during business hours) wont exceed 300 MB. During business hours Platespin replicates at least 1 GB at every replication cycle, while during off hours it replicates 300 to 500 MB per replication cycle. We are facing this strange issue with this box only(SLES 10 SP1 + Oracle 10g R2), we have protected MS Exchange 2007 Server based workloads without this strange issue, i.e in case of Exchange only delta replicates from Production server to DR site on Platespin.

Platespin support says us that Oracle re-indexes its database for better performance, so it is possible that re-indexing causes the blocks level changes on the storage, and since Platespin works on Block level, thats why it replicates so much(even though data is not changed that much)

here is actual words of Platespin support

<snip>

I think whenever Oracle database Indexing happens, it changes almost most of the Blocks of database and Platespin replicate all those Blocks.

As you know, Platespin checks the Date/Time attribute of every blocks before replication and if Date/Time attribute changes from last replication, it considers as changed block and replicate those blocks on Platespin Appliance. So, my suggestion is just look into the Oracle server behaviour before/after Data indexing process and do needful or do some workaround to overcome this issue.

</snip>

is there anything we can do at oracle level ?

View 1 Replies View Related

SQL & PL/SQL :: Extracting Numbers And Few Portion Of Text From A String Containing Dates / Characters And Numbers

Jul 13, 2011

I have a table test with column containing dates, characters and numbers. I have to extract the number part and the three characters before the number . My data looks like :

TEST
ID DATA
1 3/12/2007
2 0
3 3/8/2010 ABC 217
4 NONE
5 COLM XYZ 469 6/8/2011
6 LMN 209

My expected results should look like :

ID DATA
1
2
3 ABC 217
4
5 XYZ 469
6 LMN 209

View 7 Replies View Related

Data Guard :: Flashback Snapshot Standby Database Or New Primary Database After Failover?

Aug 30, 2013

If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM ,  Can I  flashback snapshot standby database to 6 AM and do some works on it (DML operations)  then   converting the snapshot standby database into physical standby database ?  

View 1 Replies View Related

Data Guard :: Switch (convert) Primary Database To Standby Database?

Jan 30, 2013

I have installed oracle 11g standard edition one and created both primary and standby database. now i want to know how to switch(convert) primary database to standby database.

View 8 Replies View Related

Data Guard :: Registering Primary Database To Catalog Database

Oct 9, 2012

Here we have a data guard environment with db1(db_unique_name) as primary and db2(db_unique_name) as physical standby database. Also we configured one schema on a third machine as catalog database using following steps. The steps executed in catalog database(appsdb):

SQL> create tablespace rmancatlog_tbs datafile '/u01/app/oracle/oradata/NEW/rman_catalog.dbf' size 500M autoextend off extent management local segment space management auto;

SQL> create user rman identified by oracle
2 default tablespace rmancatlog_tbs
3 quota unlimited on rmancatlog_tbs
4 ;SQL> GRANT connect, resource, recovery_catalog_owner TO rman;

RMAN> create catalog;
recovery catalog created

Added tns entries of catalog database in primary and standby. Then from primary database we tried to register to catalog database. It is showing that it is registering. But every query afterwards in rman is throwing the error. Below are the steps and error:

[oracle@db1 ~]$ rman target sys/oracle catalog rman/oracle@appsdb
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Aug 13 21:39:32 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: NIOS (DBID=1589015669)
connected to recovery catalog database
[code]....

View 4 Replies View Related

Parent Key Indexing

Jan 30, 2012

I have, for example, two tables: COMPANIES and EMPLOYEES. COMPANIES has a primary key on column COMP_ID. EMPLOYEES has a foreign key EMP_COMP_ID. I always do query COMPANIES with WHERE clause on COMP_ID and COMP_ADDRESS. What indexes on COMPANIES should I create in this case? First unique on COMP_ID, second composite on COMP_ID and COMP_ADDRESS? Or one unique index on COMP_ID and COMP_ADDRESS will be enough?

View 5 Replies View Related

SQL & PL/SQL :: Implement In Indexing?

Apr 12, 2013

what is the best practice to implement in Indexing,is it global indexing or local indexing, I would like implement one of them in object that has been partitioned horizontally.i dont know exactly what to make of it.

View 9 Replies View Related

Increase In Performance Through Re-Indexing

Feb 28, 2011

I'm Using Oracle DB, I have got performance issue in one of my portlet, Can Re-Indexing work for Increasing the performance.

View 3 Replies View Related

SQL & PL/SQL :: Indexing On Subset Of The Record?

Apr 28, 2013

Does Oracle supports an index that only contains a sub-set of the records in a table?

For eg - A table has 1 million records, can we have a index which contains suppose 100k records. We have used a similar logic in DMSII in Unisys. Not so sure if Oracle supports it.

View 5 Replies View Related

SQL & PL/SQL :: Indexing In Partition Table

Apr 16, 2013

i want to ask about indexing in partition table. i have table that indexed by local index. when i want to select all data. I execute this query

select * from Book_Issue_Part where status='Pinjam';

but it does not select all data, only partly data have selected. is it a wrong query to select all data in indexing partition table? so what query should i execute to get all data.

View 2 Replies View Related

Indexing Mapping And Junction Tables?

Aug 29, 2008

however im taking database size into account. i believe there has to be some sort of medium when it comes to infrastructure and performance.

this is specific to tables which map other tables. these tables that im creating usually consist of only 4 columns. 3 columns are mapped ids and the other a date in field. the 3 columns need to be indexed because they are used in joins within views. also those fields in the other tables are indexed as well.

View 2 Replies View Related

Primary / Standby Database Not Synced?

Jul 10, 2013

we are getting below error on alert log file in logical standby database from May 2013 how can find time of sequence creation and how can restore these sequence redo files and sysnc databases primary and standby

Snipped of alert log:
Wed Jun 10 15:29:40 2013
Fetching gap sequence in thread 1, gap sequence 62079-62178
Wed Jun 10 15:29:50 2013
Fetching gap sequence in thread 1, gap sequence 62079-62178
Wed Jun 10 15:30:01 2013
Fetching gap sequence in thread 1, gap sequence 62079-62178

View 8 Replies View Related

Export/Import/SQL Loader :: How To Skip Database JOBS During Export And Import

Aug 7, 2012

1) Is there a way to skip database jobs while exporting (EXPDP) ?

2) Is there a way to skip database jobs while importing (IMPDP) ?

View 3 Replies View Related

What Happen In Standby When Enable Flashback In Primary Database

Jan 11, 2013

what happen in standby when enable flashback in the primary database?

View 1 Replies View Related

Data Guard :: Refresh Primary Using Standby Database?

Feb 2, 2013

I was using physical standby but my primary database had had some HW issue.So I had activated standby database to handle production.During 3 months, standby database was our live database and our old primary was unavailable.Now HW issue on primary has been fixed.And I want to set again my old configuration : means set primary and standby db.

I'm trying this :

1) check the SCN on old primary

2) Rman incremantal backup from scn

3) on primary db : catalog

4) on primary db : recover database noredo

View 1 Replies View Related

Data Guard :: Changing Password On Primary Database?

Nov 10, 2011

I'm using 2 databases : Primary and Standby DB. It working fine. I've just one question : I want to change SYS password on primary DB. Can I change it without any action on Standby DB?

View 8 Replies View Related

Data Guard :: App Archive Logs Which Come From Primary Database?

Feb 16, 2012

If my standby database is read only mode,does it can app the archive logs which come from primary database?

View 2 Replies View Related

Data Guard :: Upgrade Primary And Standby Database?

Apr 30, 2012

I have a primary and standby DB using data guard 10.2.0.3.I want to upgrade oracle to 11G.I know that primary and standby should have same version even if data guard will not work again.I want to know what is the steps by steps action to properly upgrade both DB : primary and Standby.

View 1 Replies View Related

Data Guard :: Shutdown Down In Primary Database In Environment

Jun 29, 2010

I have configured data Guard on oracle 11gR2. It is working fine. The only issue i am facing is that when i am stopping the database on the primary server, it is taking a long long time to down the database.

Is it normal?

Furthermore, regarding backup i used veritas Netbackup to perform hotbackup. Can i still used the same principle.

View 3 Replies View Related

Restrict User To Login On Primary Database Using Discoverer

Dec 14, 2012

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and Oracle Discoverer 9i desktop & Administrator,We have configured a physical standby database. We have ask users to connect to standby thru discoverer thru a different tns entry, but user can also connect on primary db.

We want to restrict the specified users to connect on primary database thru discoverer.

View 5 Replies View Related

Does Cold Backup Of Primary Database Affect DR Sync

Dec 7, 2012

We are having 10gR2 DR setup,

We are planning for the cold backup of primary database on every sunday,

Does it going to affect DR sync if primary database is not availabe at the time of cold backup.

View 2 Replies View Related

Data Guard :: Changing Redo Log Folder On Primary Database

Mar 3, 2012

I want to replace one redo log on the primary database. actually this redo log is on G:oracleoradata; I want to move it on F:oracleoradata. How to do that cause the same redo log is also on standby database?

View 3 Replies View Related

Data Guard :: Check If Database Encrypted Or Not On Primary / Standby?

Jul 25, 2013

We have a primary and a standby (Physical Dataguard) site.

1. How do i check if the database is encrypted or not on primary as well as standby ?
2. If primary and standby are encrypted, does the data that gets replicated from primary to standby also in encrypted form ? If not, does it make sense to encrypt that ?

View 2 Replies View Related

Data Guard :: Take Clone Primary Database At Specific Time?

May 29, 2013

Can we make Data Guard to take clone Primary Database at Specific Time?

e.g. Clone Primary Database at 10 AM and at 6 PM?

View 10 Replies View Related

Data Guard :: Find Archive Log Gap From Primary Database Site?

Mar 23, 2013

I am new to Oracle and a beginner in Data Guard.

1) How to find archive log gap from Primary Database site?
2) Do I need the DB_UNIQUE_NAME when setting the LOG_ARCHIVE_DEST_2 ? What is the purpose of DB_UNIQUE_NAME in LOG_ARCHIVE_DEST parameter?
3) If archivelog gap happens standby db goes out of sync with the primary database. What does out of sync actually mean?
4) Primary DB knows where to transport redo data based on the location mentioned in LOG_ARCHIVE_DEST_n of Primary DB. Am I correct in my understanding?

View 3 Replies View Related







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