Fal Client User Error 1031 Connecting
Contents |
standby SQL> select * from v$archive_gap; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#---------- fal[client, user]: error 12154 connecting to for fetching gap sequence ------------- -------------- 1 2192 2212SQL>Stand by Alert log error:-FAL[client,
Fal[client, User]: Error 12170 Connecting To For Fetching Gap Sequence
USER]: Error 16191 connecting to PRODNY for fetching gap sequenceSat Dec 29 10:12:21 error 1017 received logging on to the standby 2012Fetching gap sequence in thread 1, gap sequence 2192-2212Error 1017 received logging on to the standby------------------------------------------------------------Check that the primary and standby are
Error 1031 Received Logging On To The Standby
using a password fileand remote_login_passwordfile is set to SHARED or EXCLUSIVE,and that the SYS password is same in the password files. returning error ORA-16191------------------------------------------------------------FAL[client, USER]: Error 16191 connecting to PRODNY for fetching gap sequenceSat Dec 29 10:12:31 2012Fetching gap sequence in thread 1, gap sequence fal[client]: failed to request gap sequence 2192-2212Error 1017 received logging on to the standbySolution :-We have to recover Archive log from catalog database.[orprod@muthu]$ rman target / catalog rman/muth123@RMANRecovery Manager: Release 11.2.0.2.0 - Production on Sat Dec 29 09:44:53 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: PROD (DBID=2808283451)connected to recovery catalog databaseRMAN> run {set archivelog destination to '/oracle/PROD/db/apps_st/archive';restore archivelog from logseq=2192 until logseq=2212 thread=1;}2> 3> 4>executing command: SET ARCHIVELOG DESTINATIONStarting restore at 29-DEC-12allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=512 device type=DISKarchived log for thread 1 with sequence 2211 is already on disk as file /oracle/PROD/db/apps_st/archive/1_2211_785817078.dbfarchived log for thread 1 with sequence 2212 is already on disk as file /oracle/PROD/db/apps_st/archive/1_2212_785817078.dbfchannel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/oracle/PROD/db/apps_st/archivechannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=2192channel ORA_DISK_1: reading from backup piece /backup_pip/Prod_EBS/rman/PROD_ARCH_20121228_31041channel ORA_DI
DBAAutovueBeehiveCRM & SiebelCloudE-Business SuiteIRMJD EdwardsJavaNetBeansOpenOfficeOracle FinancialsOracle RetailPeopleSoftSAPSupply Chain Management Warehouse ManagementServers & StorageHardwareLinuxOracle VDIOracle VMSolarisVirtualBoxVirtualizationOdds & SodsBest PracticesCertificationChannelsIndustry NewsMy Oracle SupportOracle OpenWorldSaaSSecurity Enter
Error 1033 Received Logging On To The Standby
your keywords View the results at Google, or
Error 12154 Received Logging On To The Standby
enable JavaScript to view them here. You are hereHome FAL[client, USER]: ora-16191 Error 1031….for fetching gap sequence Thanks to OracleBrains.Com DB for this story Mar 24, 2011 9:51pm Database Today one of http://muthuappsdba.blogspot.com/2012/12/falclient-user-error-16191-connecting.html my guys called me that log seq is not in sync with main db server. When I checked [...] Read the entire article at its source Feed: OracleBrains.Com DB Original article Featured Top Stories NEW: ROAD for Oracle VM Availability Protection, http://itnewscast.com/database/falclient-user-error-1031%E2%80%A6-fetching-gap-sequence Disaster Recovery and Operations Automation NEW: Oracle VM Private Cloud Reference Design Oracle Linux Yum Server Setup Guide Oracle VM Manager Installation Guide Oracle VM Server Installation Guide Hard and Soft Partitioning with Oracle VM The Unofficial Oracle Linux 6 Installation and Setup Guide weblogic.nodemanager. common.ConfigException Native version is enabled but node manager native library could not be loaded : NativeVersionEnabled E-T-L Architecture and Business Models Call For Participation is Open for the Xen Project User Summit in New York City MySQL & NoSQL – Best of Both Worlds. Upcoming webinar CRUD Operations in JDeveloper/ADF 11g R1 PS1 Table Component They're playing with my mind! Oracle VM Consulting|Oracle Support|Oracle News|Oracle Enterprise Manager|Oracle Cloud|Oracle LinuxContact|Privacy Statement|Company Info-© Copyright 2015
issue-archivelogs not getting applied If this is your first visit, be sure to check out the http://www.dbasupport.com/forums/showthread.php?55191-dataguard-issue-archivelogs-not-getting-applied FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: dataguard issue-archivelogs not getting applied Tweet received logging Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… 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 received logging on following issues database version 10g(hp-ux 11.2). Here are the output for the following queries. SQL> SELECT PROCESS, STATUS, 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 -----------------------