Error 12154 Fetching Gap Sequence
Contents |
issue-archivelogs not getting applied If this is your first visit, be sure to check out the FAQ by clicking the link above. fetching gap sequence in thread 2 You may have to register before you can post: click the register
Fal Client Mrp0 Error 12154 Connecting
link above to proceed. To start viewing messages, select the forum that you want to visit from fal client user error 12154 connecting the selection below. Results 1 to 4 of 4 Thread: dataguard issue-archivelogs not getting applied Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread…
Fal[client]: Failed To Request Gap Sequence
Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-17-2007,12:14 PM #1 areeb View Profile View Forum Posts Junior Member Join Date Jul 2005 Posts 87 dataguard issue-archivelogs not getting applied Hi Guys, Trying to configure standby(phyiscal) having following issues database version 10g(hp-ux 11.2). Here are the output for the following queries. SQL> SELECT PROCESS, STATUS, how to resolve archive gap in standby database THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ---------- ARCH CONNECTED 0 0 0 0 ARCH CONNECTED 0 0 0 0 MRP0 WAIT_FOR_GAP 2 10902 0 0 SQL> select * from v$archive_gap; no rows selected SQL> SELECT max(sequence#) from v$archived_log where applied='YES'; MAX(SEQUENCE#) select message from v$dataguard_status; MESSAGE -------------------------------------------------------------------------------- ARC0: Archival started ARC1: Archival started ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH ARC1: Becoming the heartbeat ARCH Attempt to start background Managed Standby Recovery process MRP0: Background Managed Standby Recovery process started Managed Standby Recovery not using Real Time Apply Media Recovery Waiting for thread 1 sequence 12335 Fetching gap sequence in thread 1, gap sequence 12335-12431 FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence MESSAGE -------------------------------------------------------------------------------- FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence FAL[client, MRP0]: Error 12154 connecting to RUBIP1 for fetching gap sequence FAL[client, MRP0]: Error
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message.
Fal[client, User]: Error 1031 Connecting To
Please type your message and try again. More discussions in Data Guard All
Fal[client]: All Defined Fal Servers Have Been Attempted.
PlacesDatabasePerformance & AvailabilityData Guard This discussion is archived 1 2 Previous Next 16 Replies Latest reply on Mar 3, 2015 1:17 error 12154 received logging on to the standby PM by ElMasry Go to original post This content has been marked as final. Show 16 replies 15. Re: FAL[client, USER]: Error 12154 connecting to for fetching gap sequence ElMasry Mar 3, 2015 12:13 PM http://www.dbasupport.com/forums/showthread.php?55191-dataguard-issue-archivelogs-not-getting-applied (in response to rchem) Thanks Rchem,Thanks Brian,I just copy the password file again and change the name it working fine between both.But i facing another issue in next step can you please take a look hereThanks again Like Show 0 Likes(0) Actions 16. Re: FAL[client, USER]: Error 12154 connecting to for fetching gap sequence ElMasry Mar 3, 2015 1:17 PM (in response to ElMasry) Unfortunately when i restart the node https://community.oracle.com/thread/3680385?start=15&tstart=0 and try to start db with these commandsstartup nomount;alter database mount standby database;I get this error in alert logfile alter database mount standby databaseTue Mar 03 15:10:16 2015NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so NOTE: Loaded library: System Tue Mar 03 15:10:16 2015SUCCESS: diskgroup DATA was mountedTue Mar 03 15:10:16 2015ERROR: failed to establish dependency between database oracledrs and diskgroup resource ora.DATA.dgARCH: STARTING ARCH PROCESSESTue Mar 03 15:10:20 2015ARC0 started with pid=128, OS id=4022 ARC0: Archival startedARCH: STARTING ARCH PROCESSES COMPLETEARC0: STARTING ARCH PROCESSESTue Mar 03 15:10:21 2015Successful mount of redo thread 1, with mount id 1746452504Physical Standby Database mounted.Lost write protection disabledTue Mar 03 15:10:21 2015ARC1 started with pid=129, OS id=4024 Tue Mar 03 15:10:21 2015ARC2 started with pid=130, OS id=4026 Tue Mar 03 15:10:21 2015ARC3 started with pid=131, OS id=4028 Tue Mar 03 15:10:21 2015ARC4 started with pid=132, OS id=4030 Tue Mar 03 15:10:21 2015ARC5 started with pid=133, OS id=4032 Completed: alter database mount standby databaseTue Mar 03 15:10:21 2015ARC6 started with pid=134, OS id=4034 Tue Mar 03 15:10:21 2015ARC7 started with pid=135, OS id=4036 Tue Mar 03 15:10:22 2015ARC8 started with pid=136, OS id=4038 Tue Mar 03 15:10:22 2015ARC9 started with pid=137, OS id=4040 ARC1: Archival startedARC2: Archival startedARC3: Archival startedARC4: Archival startedARC5: Archival startedARC6: Archival start
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring http://dba.stackexchange.com/questions/130299/from-rac-to-standby-rac-with-active-dataguard developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ http://www.itpub.net/thread-1721487-1-1.html Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top From RAC to Standby RAC error 12154 With Active Dataguard up vote 0 down vote favorite I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 : ol6-112-rac1 and ol6-112-rac2 I want to create active data guard with RAC feature from this database , these active dataguard with rac option has 2 node : ol6-rac1-guard,ol6-rac2-guard I want to use this document for creation active data guard from rac database to rac database : http://www.oracledba.org/11gR2/dr/11gR2_dataguard_RAC_to_RAC.html#Create_Physical_Standby I do the steps in this document fetching gap sequence , all of things is ok but in step " Start the Managed Recovery Process " after i want to switch log in primary , switch log is not occurred on standby database . After " tail of alert log " on standby database and executing " Switch log " on primary , this error is occurred : tail -f /ora01/app/oracle/diag/rdbms/racguard/racguard1/trace/alert_racguard1.log Wed Feb 17 04:37:57 2016 Media Recovery Waiting for thread 1 sequence 76 Error 12154 received logging on to the standby FAL[client, USER]: Error 12154 connecting to rac for fetching gap sequence This is my mistake , can any one help me ? oracle oracle-11g-r2 linux rac dataguard share|improve this question edited Feb 24 at 15:12 Kris Johnston 4951316 asked Feb 24 at 11:36 saeed.sh 78212 Your TNS entry in tnsnames.ora contains an incorrect service name that the listener does not know of. Fix that, and try again. –Balazs Papp Feb 24 at 11:56 Can you explain more ? because in primary tnsnames.ora , i have entered the information for standby1 and standby2 (node of standby db ) , in tnsnames.ora of standby db , i have entered information about primary database . is it wrong ? –saeed.sh Feb 24 at 19:37 Post the contents of tnsnames.ora and lsnrctl status for your listeners and scan listeners. Somewhere in tnsnames.ora you specified a SERVICE_NAME that does not exist at the corresponding destination. &ndash
比特币 小额贷款 贷款 crm ORACLE 项目管理系统 thread android python java 本版文章帖子用户 ITPUB论坛－中国最专业的IT技术社区»论坛 › ≡ 大数据与数据库 ≡ › Oracle数据库管理 › FAL[client, USER]: Error 12154 connecting to pridb f ... 细数 “分布式计算系统”令你不爽的那些瞬间！ oracle技术交流群，欢迎大家加入！ 大数据时代，每家公司都要有大数据部门？ 12 / 2 页下一页 返回列表 查看: 7023|回复: 10 收藏 | [备份恢复] FAL[client, USER]: Error 12154 connecting to pridb for fetching gap sequence [复制链接] esou esou 当前离线 积分101 IP卡 狗仔卡 论坛徽章:5 电梯直达 1# 发表于 2012-9-24 14:37 | 只看该作者 |倒序浏览 |阅读模式 在新建的DR server里面无法应用从主库上copy过来的archive log, 根据如下错误显示是丢失log 43064,但我用select applied...语句查询该log状态显示是Applied状态。如果我重新注册一遍，再应用一遍，就会发现被应用了两次，如下所示。这个log是我从备份磁带恢复出来的，但目前数据库中显示已经applied状态的log是44869，如果都要恢复的话会有1800多个，而且还不知道重新应用一遍是否能解决此问题。 请问这个问题会是什么原因导致的，大家是否有什么好的解决办法？谢谢！ SQL> select sequence#,applied from v$archived_log where sequence#=43063; SEQUENCE# APPLIE ---------- ------ 43064 YES 43064 YES SQL> select message from v$dataguard_status; MESSAGE ------------------------------------------------------------------------------ ARC0: Archival started ARC1: Archival started ARC2: Archival started ARC3: Archival started ARC4: Archival started ARC5: Archival started ARC6: Archival started ARC7: Archival started ARC8: Archival started ARC9: Archival started ARC0: Becoming the 'no FAL' ARCH MESSAGE ------------------------------------------------------------------------------ ARC0: Becoming the 'no SRL' ARCH ARC1: Becoming the heartbeat ARCH Media Recovery Start: Managed Standby Recovery Managed Standby Recovery not using Real Time Apply Media Recovery Waiting for thread 1 sequence 43064 Fetching gap sequence in thread 1, gap sequence 43064-43064 FAL[client, USER]: Error 12154 connecting to pridb for fetching gap sequence FAL[client, USER]: Error 12154 connecting to pridb for fetching gap sequence FAL[client, USER]: Error 12154 connecting to pridb for fetching gap sequence FAL[client, USER]: Error 12154 connecting to pridb for fetching gap sequence FAL[client, USER]: Error 12154 connecting to pridb for fetching gap sequence MESSAGE ------------------------------------------------------------------------------ FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 43064-43064 DBID 1679175982 branch 748450978 FAL[cl