Oracle Error 1041 When Pinging Standby
resume, the primary database still complained that it cannot connect to logical standby db. ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (1041) ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned PING[ARC1]: Error 1041 when pinging standby I can manually connect to standby db. I have came across this problem before and believe that primary ARCH keep a persistent connection to standby and wont notice a broken connection was assumed. Last time I was luck to get a chance to restart the primary db and fixed the problem. I digged around metalink and found that it is a bug (Bug No. 5344954) and there is a workaround SQL> alter system set log_archive_dest_state_n=defer; SQL> alter system set log_archive_dest_state_n=enable; It then strikes me that I had done the same thing at another occasion and just forgot it. Always good to take a note. Hongfeng Sun : 09 Nov 2006 18:09 |Tags:OracleOracle-Availability | Comments(1) |Reportaproblem One comment Mauriel Rosero Tnx this was great for me same problem happend and solved thanks alot 23 Jan 2007,02:42 Add a comment You are not allowed to comment on this entry as it has restricted commenting permissions. Search this blog Search Warwick Blogs Enter your search terms Web blogs.warwick.ac.uk Submit search form Tags Oracle (112) Life (37) Java (36) Oracle-Tune (41) Reflection (16) Oracle-Availability (31) Review (20) Spring-Hibernate-Jboss (15) Training (12) Unix (13) Oracle-Admin (9) Tech (8) Web (9) Most recent comments Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry "logical standby failed to re–start, I am also getting t
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing https://scn.sap.com/thread/1876345 and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and https://community.oracle.com/thread/2501925?start=15&tstart=0 AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive oracle error ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect oracle error 1041 ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterprise Manag
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. Please type your message and try again. More discussions in Data Guard All PlacesDatabasePerformance & AvailabilityData Guard This discussion is archived 1 2 Previous Next 24 Replies Latest reply on Feb 24, 2013 4:03 AM by Riaz Go to original post This content has been marked as final. Show 24 replies 15. Re: Errors in Standby Alert Log Riaz Feb 20, 2013 11:22 AM (in response to CKPT) Thanks for all the help. I dropped and re-created the affected logs and it seems to work fine now. Before i close this question, could you please guide me if, while rolling forward using RMAN incremental backup, we have different paths (in primary and standby) for Redo Logs, what steps we need to perform? The documents i have seen so far don't describe the situation for redo logs, only for data files. Best regards, Like Show 0 Likes(0) Actions 16. Re: Errors in Standby Alert Log Sunny kichloo Feb 20, 2013 2:14 PM (in response to Riaz) If log_file_name_convert is set you can easily restore the RMAN incremental backup in your standby database. Like Show 0 Likes(0) Actions 17. Re: Errors in Standby Alert Log Riaz Feb 21, 2013 5:22 AM (in response to CKPT) Post this changes (re-creating the log files), it seems the archive logs are not applied to standby automatically. However if i apply them manually, it is OK. What might went wrong? Standby Alert Log: Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 WARNING: db_recovery_file_dest is same as db_create_file_dest Autotune of undo retention is turned on. LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.4.0.