Oracle Dataguard the achivelog not transfort between primary & standby db

2012-04-10  Source: Original Site  Category:Oracle  Views:0 

Advertisement

all Dataguard gurus

i tried to install oracle 10g dataguard on 2 machines with Centos 4.6 for development

after finish the installation, i 've got some "STRANGE" ..when i do a query at dataguard1

dataguard1 is primary database
dataguard2 is standby database

[email protected]> select sequence#, first_time, next_time from v$archived_log;

SEQUENCE# FIRST_TIM NEXT_TIME


---------


16 24-JUL-09 24-JUL-09
17 24-JUL-09 24-JUL-09
18 24-JUL-09 24-JUL-09
19 24-JUL-09 24-JUL-09
20 24-JUL-09 24-JUL-09
21 24-JUL-09 24-JUL-09
22 24-JUL-09 11-AUG-09
23 11-AUG-09 12-AUG-09
24 12-AUG-09 12-AUG-09
25 12-AUG-09 12-AUG-09
26 12-AUG-09 12-AUG-09

[email protected]>select sequence#,applied
2 from v$archived_log
3 order by sequence#;

SEQUENCE# APP


---
16 NO
17 NO
18 NO
19 NO
20 NO
21 NO
22 NO
23 NO
24 NO
but if i do the same quey on standby database

[email protected]> select sequence#, first_time, next_time from v$archived_log;

nothing archive...and not applied

what could be the problem????

thanks for u'r attention & help

Edited by: kang dadang on Aug 12, 2009 7:22 PM

Related articles
  • Oracle Dataguard the achivelog not transfort between primary & standby db 2012-04-10

    all Dataguard gurus i tried to install oracle 10g dataguard on 2 machines with Centos 4.6 for development after finish the installation, i 've got some "STRANGE" ..when i do a query at dataguard1 dataguard1 is primary database dataguard2 is standby d

  • Oracle What is (meaning or difference) between primary key and index of a table? 2014-03-23

    I want to ask what is the meaning or difference between primary key and index of a table? If a table is having primary key, will it no need to add a index of it? what's the difference meaning of them? Thanks a lot. :> CREATE TABLE "CUSTOMERS" ( "T

  • Oracle Why the space not be released? 2012-06-06

    In oracle, Why the tablespace not be released after delete many rows in which include ORDSYS.ORDVIDEO column where many video files are stored in?? How can I decrease the tablespace possession after delete rows in table_video table?

  • Oracle Dataguard not synchronization between Primary Database and Standby Database 2013-12-25

    If the database is in a primary problem of corruption in a given segment, an index for example, the process of synchronization is still for the other node? I found a problem, because the primary database was corrupted and block synchronization was oc

  • Oracle Dataguard: MRP Process not applying 2013-07-17

    Windows 2003 Oracle 10g R2 Primary:tcjolts2 Standby: tcjolts3 Type: Physical Standby database I am having problems configuring dataguard, the logs are shipping to my stanby server but they are not being applied. This is the MRP error: MRP0: Backgroun

  • Oracle Secondary index corrupt: not consistent with primary 2012-02-04

    I run BDB 4.6.21 (no patch) on a production system. From time to time a experience a corrupt secondary index, error message: BDB: Secondary index corrupt: not consistent with primary I have about 5-10 secondary indexes per database, most of them with

  • Oracle Routing Exception: Route not found between source node and Highway network 2013-05-19

    Hai I am facing the problem like route not found between source node and highway network when i am giving the different edge_id's. My edge table consists of func_class as 1, 2, 3, 4, 5 when i am trying to give differnt edge_id' s in start_location an

  • Oracle Route Engine - Route not found between source node and highway 2014-01-05

    I'm testing Route Engine with my own data. I followed the steps in readme file, all things seem to be correct. When writing a request, if I set source address is the same as destination address, route engine runs correctly <route_request> ...

  • Oracle dataguard ,redo log not applied 2014-05-23

    i am using oracle dataguard 10g . everything was quit fine . but some days later a problem occured . after sequence 128 log is not applied . i am using realtime log appled. can anybody help me .

  • Oracle remove the datafile not belong to database 2015-04-02

    ASM disk +data filled with datafile and onlinelogs not belong to the database. I have created the standby datbase from primary using copy datafiles . first time it failed. but files were copied into disk. without removeing the old datafile gain creat

  • Oracle Archive log is not getting transferred to standby side from primary side 2013-12-28

    In my data guard setup some times one archive log is not getting transferred to standby side, but the archive logs which generated after that getting transferred to standby side but not applying as they miss the archive sequence. I have declared the

  • Oracle archive logs are not moving from primary to standby database 2014-05-22

    archives are not moving from primary to standby database.please help me what are all things I need to check. primary and standby are in same machine.

  • Oracle Validate the difference in days between tabular form dates 2014-08-29

    Greetings, I have a tabular form with a date on each row. When the user saves the form, I'd like to sort the rows by chronological order of those dates, then fetch the first and last date, calculate the difference between them and validate it. Does a

  • Oracle RMAN deletes archivelogs not yet applied to standby 2012-05-06

    I have a problem where my physical standby database becomes out of sync with primary. When there is a log gap and fal tries to get the missing archivelog from primary, it cannot because it has been deleted by RMAN. The Oracle version im using is 10.2

  • Oracle Function based Index not working in Logical standby DB 2012-10-19

    Hi I have oracle 9.2.0.6 on Solaris 9 box and created 1 logical standby database for the same. I am having problem with function based index on 1 table. If i drop the function based Index on column in Primary DB and then create Logical standby DB, an

  • Oracle Dataguard - The primary database is being moved from server1 to server2 2012-05-02

    I have a primary database and a physical standby database(10204,solaris 10). The host(server) that the primary is on will be moved to a different server with a different servername. Once the primary database has been moved to a different host with a

  • Oracle Why is explain Plan different between primary/backup servers 2012-05-07

    A query on our primary database has a different plan then on our secondary server and I'm trying to figure out issue. We are running oracle 10.2.0.4 on Solaris 64. The secondary server is a seperate database with exactly the same data loaded as the p

  • Oracle DataGuard / effect of open resetlogs on Primary 2012-10-18

    We've a primary RAC with corresponding dataguard physical standby database (running as 1 node when acting as disaster recover site). In the event of a major upgrade, we typically stop the apply of redo to the standby site and run the upgrade (say to

  • Oracle Dataguard RFS process not started up 2014-08-28

    Please, Using Oracle 10g release 2 on Windows. I set up physical Dataguard that was working perfectly, until I decided to: On the primary database 1. DEFER to Remotely send Archive log to standby database SQL.> ALTER SYSTEM SET LOG_ARCHIVE_DEST_ST

  • Oracle Dataguard 9iR2 using same SID for primary and physical standby issues 2015-02-17

    Hello, I have been following the Creating Physical Standby Database document from Oracle setting up a physical clone for a 9iR2 database on Solaris 9 environment between two identical workstations. I want to databases to have the same SID for relativ