Oracle ALTER DATABASE RECOVER MANAGE STANDBY DATABASE

During the creation of Logical Standby database (NOAA2), after issuing the statement:"ALTER DATABASE RECOVER MANAGE STANDBY DATABASE"the following error appears:FAL[server, ARC1]: Complete FAL noexpedite archive (thread 1 sequence 46 destination NOAA2)ARC1: Attempting destination LOG_ARCHIVE_DEST_2 ...

Oracle ORA-279 signalled during: ALTER DATABASE RECOVER automatic standby databas

oracle server:8.1.7.0.0os:solaris 5.9we created standby server by taking coldbackup of primary server and we are using rsync to syschronize the archive log files between production and standby servers but every over we recover the standby server by executing sql>recover automatic standby database ...

Oracle ALTER DATABASE START LOGICAL STANDBY APPLY INITIAL

I am using oracle 9.2.0.8 db version. I am trying to configure logical standby database. When I issue "ALTER DATABASE START LOGICAL STANDBY APPLY INITIAL" i get following error.ERROR at line 1:ORA-01427: single-row subquery returns more than one rowORA-06512: at line 1 ...

Oracle "ALTER DATABASE RECOVER TO LOGICAL STANDBY XXX" hangs.

I am in the process of configuring a Logical standby database and have successfully configured the Physical Standby database. Built the Logical Standby Dictionary using DBMS_LOGSTDBY.BUILD; Now, On the physical standby, when I issue the below command, the system hangs indefinitely.ALTER DATABASE REC ...

Oracle physical standby database to Logical standby

Can I convert a physical standby database to Logical standby, ...

Oracle diff btw "recover datafile file#" & "alter database recover datafile file#"

What is the difference between "recover datafile file#" & "alter database recover datafile file#" ...

Oracle ALTER DATABASE RECOVER AUTOMATIC

in 10 gR2 when applying :ALTER DATABASE RECOVER AUTOMATIC UNTIL TIME '2001-10-27:14:00:00'; what should be the state of Database ? Nomount ? Mount ? Open ? ...

Oracle Physical Standby database Vs. Logical Standby database

I have few questions regarding capability of Logical Standby Database against Physical Standby database.1. How efficient is Logical Standby database in terms of Physical Standby Database?? How both differ from each other and can I use Logical Standby Database for disaster Recovery?? Can It be use fo ...

Oracle Import into Primary database having **logical** standby

I opened an SR with Oracle for this reason too. but no reply since 2 days If I am doing a schema level export, should the tables be already created on the standby before the import?Since the drop table is also reflected on the standbyI have a 10.2.0.3 database on AIX 5.3Its a logical standby and not ...

Oracle Logical Standby Database with 10g+ASM on both sides??

is there a known way to establish a logical standby database on 10g, if both sides are running with an ASM setup?I've tried to create one out of a physical standby database (which is set up and running w/o any problems), like a book suggested me to do. The procedure was:1. switch on supplemental log ...

Oracle Logical StandBy database problem

I create a logical standby configuration but the redo logs aren being applied to the standby database. When I sent the command:ALTER DATABASE START LOGICAL STANDBY APPLY INITIAL 443582;In alert log arose the messages below.How can I resolve this problem ?Thank you,FariaCompleted: ALTER DATABASE STAR ...

Oracle 10gR2 Logical Standby database not applying logs

No errors are appearing in the logs and I've started the apply process :ALTER DATABASE START LOGICAL STANDBY APPLY but when I query dba_logstdby_log, none of the logs for the last 4 days shows as applied and the first SCN is still listed as current. Any thoughts on where I should start looking?the l ...

Oracle 9i RAC logical standby

I have a Oracle 9.2.0.1.0 RAC system that I'm trying to set up a logical standby for. All was working well until the standby archive log destination filled up. I add space and the archive logs began coming in again but I noticed the changes were not being applied to the standby database. Oracle told ...

Oracle Logical standby apply won't apply logs

RDBMS Version: Oracle 10.2.0.2Operating System and Version: Red Hat Enterprise Linux ES release 4Error Number (if applicable):Product (i.e. SQL*Loader, Import, etc.): Oracle Dataguard (Logical Standby)Product Version: Hi!!I have problem logical standby apply won't apply logs.SQL> SELECT TYPE, HIG ...

ORA-01332 while creating Logical standby server on oracle 9.2.0.7

I am trying to create a logical standby database. I followed the Oracle guidelines and did the following: Created a backup control file on primary. Built the logmnr dictionary on primary Copied the data files, backup control files and the archived logs (with logmnr dictionary) to the backup server S ...

Oracle Logical standby setup

i'm configuring logical standby database,after giving alter database start logical standby apply; database was altered. but select name, valuefrom v$logstdby_statswhere name = 'coordinator state' 2 3 ;is not showing the status applying .how much will it take to come to applying status.SQL> alter ...

Oracle Logical Standby - 9iR2

Hi, i have a litle problem with Logical Standby database a few second the start apply the redo the view V$LOGSTDBY_STATS is empty. SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;Database altered.SQL> ALTER DATABASE START LOGICAL STANDBY APPLY;Database altered.SQL> SELECT NAME, VALUE FROM V$ ...

Oracle Create logical standby.

I've created physical standby database on the same machine.Standby apply archivelogs.I strugle with convert physical standby into logical one.When I try create controlfile for logical get:SYS@stb>ALTER DATABASE CREATE LOGICAL STANDBY CONTROLFILE AS '/tmp/stbl.ctl';ALTER DATABASE CREATE LOGICAL ST ...

Oracle Logical Standby Scenario..!!

We are having dataguard setup with Primary, Physical standby and Logical Standby databases located on three different machines..Oracle Version : 10.2.0.1OS : RHEL 4 on (x86 32-Bit)Following are our initialization parameters for all the three instances.. Primary Database Parameters--*.db_unique_name= ...

Oracle Logical Standby Problem

My environment is Primary database is 11.1.0.7 64bit on Windows 2003 Enterprise 64bit. Logical is on the same platform and oracle version but a different server. I created a physical standby first and it applied the logs quickly without any issues. I received no errors when I changed it over to a Lo ...

Oracle Controlling "Log apply" on Logical standby.

We are going Live with logical standby ina day or two, and suddenly found what seems to be a potential problem in the near future. Despite issuing the commandALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE; Logs are not getting applied immediately. Each of the logfile is taking somewhere around ...

Oracle Unable to start logical standby

I'm having some problems trying to start my logical standby. I managed to successfullly create a physical standby and ensured that it was collecting and applying archive logs. Running Oracle 10g on 11g Grid ASMI then converted it to a logical and i'm getting this problem : -SYS@Logical > ALTER DA ...

Oracle logical standby db help

can anyone tell differnece between the two code ==================================================1)SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;Database altered.SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'SCHEMA_DDL',-schema_name => 'HR', -object_name => 'TESTEMP%');PL/SQL procedure s ...

Oracle skip the DELETE command on logical standby

I want to skip the DELETE command on logical standby. DB Version - 10.2OS - LinuxPrimary DB and logical standby DB .In our DB schema some transaction tables. We delete data from those tables by delete commands. Delete command, also delete data from logical standby DB. But we want to skip on logical ...

Oracle stop/start logical standby db

Version 10203 on AIXHave to stop/start logical standby db, new to data guard, Please confirm these are the steps to do thaton primary dbSQL > alter system switch logfile ;SQL > alter system archive log current ; ( to make sure current transactions come thru)check tail of alert log of standby t ...

Oracle How does one monitor "alter database recover automatic"

When recovering archive logs, is there a way to monitor progress?Is there a way I can find out which logfile is currently being recovered? ...

Oracle Error while Creating a Logical Standby Database

I setup physical standby db. Now trying to convert it to logical standby db by following this link:http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htm#i92346When i issue this statement:ALTER DATABASE RECOVER TO LOGICAL STANDBY orcl2;I am getting following error:ORA-0090 ...

Oracle problem building logical standby database

i am trying to build a logical standby database on platform Sun OS 10/Oracle 10gR2. I am following the Oracle document http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htm#BEIGHEIAI have created a physical standby database and converting it to a logical standby database. I en ...

Oracle creating logical standby database

10.2.0.1Following this linkhttp://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htmWhere do i need to issue these statements:SQL> EXECUTE DBMS_LOGSTDBY.BUILD;SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY db_name;on physical standby or primary database.I issued the first st ...

Oracle alter database ... keep identity hangs

Does anyone know what could cause the "alter database recover to logical standby keep identity" statement to hang waiting on "MRP wait on archivelog arrival"? I have executed this exact statement in the past on another physical standby and it went through fine. I ran "exec dbms_logstdby.build" on th ...

Oracle RMAN-11001: alter database mount standby database

I'm doing a duplicate for a standby database and I'm getting this error Oracle 8i Tru64RMAN-03002: failure during compilation of commandRMAN-03013: command type: Duplicate DbRMAN-03015: error occurred in stored script Memory ScriptRMAN-03006: non-retryable error occurred during execution of command: ...

Oracle Will logical standby database be replaced by physical standby database?

Will logical standby database be deprecated or replaced by physical standby database because of Real Time Query?As far as I know, because of the emergence of Real Time Query, physiacl standby database is easier to work than logical standby database. There are so many restrictions on using logical st ...

Slow SQL Apply on Logical Standby Database in Oracle10g

We are using Oracle 10g Logical Standby database in our production farm but whenever there is bulk data load (5-6 GB data) on the primary database, the logical standby seems to be hung. It takes days to apply the 5-6 GB data on the logical standby.Can anybody give me some pointers how can I make my ...

Oracle Prerequisite of Logical standby database ????

We have Oracle 10g database with two physical standby databases on windows 2003 server 64 bit. we was thinking of shifting physical standby database into logical standby database.We also look at the oracle documentation, as the link below. As we also found tables without unique logical identifier in ...

Oracle difference between alter database and recover database

if iam using controlfile-type=backup, then what is the diff between 1) recover automatic using backup controlfile and 2) alter database recover automatic using backup controlfile? ...

Oracle create logical standby from existing physical standby on 9i

I have physical standby database 9i running.I want to try to convert the physical standby to logical standby. i follow the step by step in metalink document no. 748595.1But I cannot do the 6th step:6. Issue command to switch physical standby to logical standby after changing db_name in pfile to logi ...

Oracle logical standby rolling upgrade issue

im experiencing some strange error during the setup of a logical standby environment.primary system running: 10.1.0.3.0 - 64bit Productionlog. standby system running: 10.1.0.5.0 - 64bit Productioncompatibility flags set to 10.1.0.3.0 on the standby side.now everything works fine till it comes to the ...

Oracle alter database create datafile as

HiT1-)shutdown immediate;T2-)Take full backupT3-)startup;T4-)move the objects in tablespace test1 to some other tablespaceT5-)drop tablespace test1;T6-)create tablespace test1datafile 'C:\oraclexe\oradata\XE\test1.dbf' reuse;T7-)alter system switch logfile;//......................................... ...

Oracle logical standby database issue?

Hi,I created a logical standby database on the same server as primary database.then I transited the old primary DB to standby DB,old standby DB to primary DB.and "alter system switch logfile" in new Primary DB.execute sql in new standby DB:SQL> SELECT APPLIED_SCN, NEWEST_SCN FROM DBA_LOGSTDBY_PRO ...

Oracle Logical standby database problem

I am trying to create logicalstandby database on the same machine of primary database.......i have created a control file for logical standby database by using the below query on the primary database.... sql>alter database create standby controlfile as 'D:\stand\control\stand_control.ctl';i have ...

Oracle Physical vs Logical standby database

In the Oracle HA guide, it is mentioned that we must take Logical backup "in addition" to Physical backup (not instead of Physical Backup)If I run have two systems i.e a Primary System and a Logical standby database system , is it not sufficient protection ? If the primary fails, can I not recover t ...

Oracle updating tables in logical standby database

Is it possible to update non replicated tables in the logical standby database, but have the same schema name?"Alter session disable guard" works only for the current session, in fact i want it for all connected users whithout stopping the standby apply ? ...

Oracle alter database open hangs on snapshot standby

I have a physical standby that has been converted to a snapshot standby on release 11.1.0.7 on a Linux RHEL5 server that I'm trying to open read/write and it hangs on "smon: enabling cache recovery" in the alert log and never gets past it. I've done this many times before on this particular database ...

Data guard: "selected database not configured as a physical or logical standby DB"

We are using Data guard gui to set up a standby database. On phase 3 of 4, when selecting the standby database, we keep receiving the following error message: "The selected database is not configured as a physical or logical standby database". I need help or advice. ...

Oracle Logical Standby Database and XMLDB

I couldn't find a proper group to post this message and thought I would try here.I want to set up a Logical Standby Database for our production database server 9.2.0.4.0 with XMLDB. I am having problem with some system tables that were created when I registered some XML schemas. These tables are in ...

Oracle Confusion regarding logical standby database

While designing the logical standby database, Oracle recommends to add the supplement information in the primary database, so that the changed columns are uniquely recorded in redo log file.In this case the amount of information in redo log files will increase,So, redo log files will be filled on a ...

Oracle Logical Standby Database

We use Oracle 9.2.01, w2k servers. I just presented to my supervisor the capability to setup 3 different instances on a server here that would pose as a logical standby databases in a dataguard scheme. The purpose is not as a failover or backup but a way for managers to almost instantaneously get da ...

Oracle how to import schema into logical standby database

i had created a new schema(A)in different database and exported the schema into a dmp file using export utilityfrom the exported dmp file i want to import that schema(A) into logical standby database using import utilityiam importing as system user .i am getting the following error IMP-00003: ORACLE ...

Oracle logical standby database problem

i have setup logical standby database on my pc . Everything was working fine . Logs were applied.But i tried testing few things on standby and issued few commands on that.After that the logs were not applied. i tried to restart that also dint work.what should i do so that things r back to normal or ...

Oracle Add Datafile in Logical Standby Database

I have add one datafile in our primary RAC DB. We had logical standby database with file management is equal to manual. Both the primary RAC and logical standby db have the different storage structure. When the archive applied on the logical standby database its throws the error " error in creating ...