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


Data Guard :: Windows To Aix (logical)

Oct 18, 2010

I have a Windows 2003 server with Oracle 10.2.03 database residing in one datacentre, with Dataguard configured to a physical standby in a similar location (proven process that works great).

I now have a requirement to transfer and synchronize the same live database to a database in a different country (AIX box), purely for data purposes not failover etc. I can transfer an export of the Database and have this up and running as a logical database of the live on AIX, but is it then possible to configure dataguard on the Windows server to also send updates to this logical database on the AIX system? Thus keeping them in sync with each other?

View 1 Replies View Related

Data Guard :: Oracle 9i Logical Standby

Feb 28, 2012

There are two in HP-UNIX and another is solaris.

I would like to configure a logical standby using oracle 9i...Is it possible in 9i?

View 7 Replies View Related

Data Guard :: Convert Logical To Physical Standby?

Oct 9, 2012

Can we convert a logical standby to physical standby? Yes or No, if yes how ..

View 7 Replies View Related

Data Guard :: How To Skip Delete On Logical Standby

Oct 11, 2013

On next month i will have plan to delete history data on my Primary database, but i still want to keep them in logical standby as the data warehouse. So, how can i skip delete statement from primary database apply to logical standby.

Oracle SQL apply only support for Skip DML but not for keep delete statement

(on 10g and 11g)SQL>exec dbms_logstdby.skip(statement => 'DELETE',schema_name => 'SCOTT', object_name => 'DEPT');BEGIN dbms_logstdby.skip(statement => 'DELETE',schema_name => 'SCOTT', object_name => 'DEPT'); END;  *ERROR at line 1:ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'SKIP'ORA-06550: line 1, column 7:PL/SQL:

View 15 Replies View Related

Data Guard :: Logical Standby On Windows Server 2008

Sep 8, 2010

Can i create logical_stand_by for windows server 2008, the primary data base is HP UX , both operating systems are 64 bits and data bases are Oracle 10g

View 6 Replies View Related

Data Guard :: RAC To Single Instance Logical Standby Creation

Jul 24, 2012

I am not able to find any document that shows steps to create a SINGLE INSTANCE LOGICAL STANDBY database for a 2 NODE ORACLE RAC database. I have found documents for RAC to Single Instance Physical standby database. But not for Logical Standby.


OS: Redhat 5
DB: file system, not using ASM/Standby also file system)
Status: Single instance physical standby database created, need to convert it to Logical standby.

View 11 Replies View Related

Data Guard :: Can A Logical Database Be Applied From A Physical Standby

Jul 25, 2013

I have a setup where i have one physical and logical standby from a primary database. In case of switch over between primary and physical database my logical apply gets stopped. Can a logical database be applied from a physical standby ?

View 5 Replies View Related

Data Guard :: Implement Logical Standby Database For Reporting Purposes

Apr 14, 2010

I working on a Production Environment, where our Database is running on a IBM-AIX platform.I need to implement Logical standby database for reporting purposes, in order to improve the performance.Now the transaction and the reporting is done at the same site itself.I want to know that, operating system and platform architecture (RAM size, no. of CPUs, ORACLE_HOME etc..) on the primary and standby systems must be same or can be different. complete configuration for Dataguard. My os version is,

Oracle Database 10g Enterprise Edition Release - 64bit
PL/SQL Release - Production
CORE Production
TNS for IBM/AIX RISC System/6000: Version - Production
NLSRTL Version - Production

View 1 Replies View Related

Data Guard :: Restoring Logical Standby Rman Backup On Production

Oct 9, 2012

I have One Production and one logical standby database . Due to tape problem we are unable to take backups of primary . And due to business , we cannot take back up on disk in hot period(Bank database ) .

If i take logical standby database backup(level 0 ) using RMAN , then will i be able to restore it on production dtbs (In case Production down) ? . Logical standby is in sync with primary .

View 2 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

Data Guard :: Possible To Convert Logical Standby To Physical Standby

Aug 30, 2013

My steps for testing as below:

1.create a primary database
2.duplicate a physical standby database;
3.turn on flashback on both databases.
4.record SCN xxx on physical standby database.
5.convert physical standby to logical standby (using keep identity statement)
6.flashback to logical standby to xxx
7.convert logical standby to physical standby
8.using real time apply I got errors: Fast Parallel Media Recovery enabledManaged Standby Recovery starting Real Time ApplyMRP0:

Background Media Recovery waiting for new incarnation during transient logical upgrade procedure

Errors in file /home ora/ app/ oracle/ diag/ rdbms/ ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:ORA-19906: recovery target incarnation changed during recoveryManaged Standby Recovery not using Real Time ApplyErrors in file /home/ ora/app/ oracle/diag/ rdbms/ ora11gr1dg/ ora11gr1dg/ trace/ora11gr 1dg_mrp0_ 10120.trc:ORA-19906: recovery target incarnation changed during recovery  

Errors appears every 10 seconds. Seems MPR0 is waiting for new incarnation for a long time. So am I.Standby database incarnation:

List of Database IncarnationsDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time-------1 1 ORA11GR1 3853851354 CURRENT 1 08/09/2013 01:02:182 2 ORA11GR1 3853851354 ORPHAN 2127877 08/28/2013 19:22:01     BGV

View 2 Replies View Related

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

Logical Standby / Streams?

Feb 3, 2012

Source DB is logical standby
Destination DB is

Is it possible to set up streams on the logical DB to replicate some schemas to the 11gR2 DB?

View 10 Replies View Related

Buffer Gets And Logical Reads?

Jun 27, 2012

Does the counter of event buffer gets include the logical reads ? Does the mertic buffer gets include the event of reading from undo buffer ?

View 4 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;

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

Creating MV Logs In Logical Standby DB?

Dec 10, 2010

I am trying to create materialized views based on a few tables in a logical standby database.

The target database (11g R2) where the MVs will be created is a stand-alone database.

The DB where the base tables reside is a logical standby database (11g R2).

The requirement is to do a "FAST REFRESH" of the Materialized Views.

My questions are :

1. Can I create MV logs in the logical standby DB?

2. If the answer to question no. 1 is "Yes", do I need to do anything different or configure the logical standby DB in a specific manner in order to create MV logs. From what I understand, the objects in the logical standby database are in a locked state.

View 2 Replies View Related

SQL & PL/SQL :: Logical Difference Between Delete And Truncate?

May 7, 2012

when we try to truncate the parent table data although its child tables are empty, the oracle oracle throws an error--"ORA-02292: integrity constraint test_id_constr violated - child record found" , but when we delete this parent table data by "delete" statement then it gets deleted. what is the logic behind "truncate".

View 3 Replies View Related

Can Logical Database Be Applied From Physical Standby

Jul 24, 2013

I have a setup where i have one physical and logical standby from a primary database. In case of switch over between primary and physical database my logical apply gets stopped. Can a logical database be applied from a physical standby ?

View 2 Replies View Related

Real Time Apply For Logical Standby

Nov 15, 2012


I have a primary database orcl and logical standby database orcl_std.

Real time apply is enabled. I have standby redologs in both primary and standby sides and I`ve started recovery with below command:


When I create a new table in primary database, I am unable to see it on standby database (Although real time apply is enabled) However, when I switch log in primary, I can see the new table in standby database.

My question is, why realtime apply is not working in my scenerio ? I was expecting to see the new table immediately in standby database once it is created in primary database. Why am I supposed to wait for log switch in real time apply ?

View 5 Replies View Related

Logical Backup Of All Application Tables At Regular Intervals

May 18, 2010

I want to maintain the logical backup of all the application tables At regular intervals. Which option would i use?

View 1 Replies View Related

Recovery Manager (RMAN) :: Physical And Logical Standby?

Aug 29, 2013

,I have a test environment with Primary DB Server, Physical Standby and Logical Standby.The Logical Standby DB (cur_log_stdb) is backed up every evening by RMAN and I have a question:If I recover my Logical Standby DB from backup and switch replication to new Logical Standby DB (new_log_stdb) it will work or not?My steps e.g.:1. Make a new server for my new_log_stdb and repair structure of catalogs;2. Repair listener.ora and tnsnames.ora files from cur_log_stdb to new_log_stdb;3.

Restore DB with RMAN from backup to new_log_stdb;4. On cur_log_stdb execute "alter database stop logical standby apply";5. Change a DNS name from cur_log_stdb to new_log_stdb;6. On new_log_stdb execute "alter database start logical standby apply immediate";I'm not sure that archivelogs will apply to the new_log_stdb for period since rman backup was created.  Configuration:Oracle Linux 6.4Oracle Database and Physical with Data Guard

View 1 Replies View Related

Logical Corruption In Oracle Database - Invalid RowID Error

Jul 30, 2012

I observed logical corruption in one of the database, while running select on some tables observed ORA-01410: invalid ROWID error. These errors or errors related to this logical corruption are not reported in alert log file.

Since our database is in NOARCHIVELOG mode and regular backups are not happening through RMAN (weekly cold mount point backup to tape),
i was not able to use RMAN to investigate block corruption.

So used DBVERIFY on all datafiles of database to check the consistency of datafiles, and found DBV gives error for one of the datafile - 'Completely zero block found during dbv:' As i mentioned earlier, we are not taking regular backups using RMAN and database is in NOARCHIVE mode.

View 2 Replies View Related

Server Administration :: Split Existing Schema Into 3 Logical Divisions

Mar 2, 2011

Presently have one instance, one Schema on my DB Server. Want to split the existing schema into 3 logical divisions. Have created the 3 Schemas. Through Oracle Export from the old Schema am able to Export (using wild cards) the tables and indices for each grouping and am able to Import into the new specific schema. The problem i'm having is that i cannot seem to Export the specific sequences due for each of the new schemas. Is there an easy way to accomplish this?

View 6 Replies View Related