Ora-00600 Internal Error Code Arguments 2662
and ora 00600 internal error code arguments 2662 1 SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing ora-16433: the database must be opened in read/write mode. and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive 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 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
System table spaces are deleted, the recovery data files the way to recover the database to the start state, database no archive mode. Open in alter database open resetlog database ora-600 [2662] error when prompted. The following information: SQL> col member for a80 SQL> select group#,status,member from v$logfile; GROUP# STATUS MEMBER https://scn.sap.com/thread/1670493 ---------- ------- -------------------------------------------------------------------------------- 3 /u01/app/oracle/ORAC1/onlinelog/o1_mf_3_9r1wx0r7_.log 3 /u01/app/oracle/fast_recovery_area/ORAC1/onlinelog/o1_mf_3_9r1wx0tq_.log 2 /u01/app/oracle/ORAC1/onlinelog/o1_mf_2_9r1wwyrm_.log 2 /u01/app/oracle/fast_recovery_area/ORAC1/onlinelog/o1_mf_2_9r1wwyvm_.log 1 /u01/app/oracle/ORAC1/onlinelog/o1_mf_1_9r1www7g_.log 1 /u01/app/oracle/fast_recovery_area/ORAC1/onlinelog/o1_mf_1_9r1wwwdz_.log 6 rows selected. SQL> recover database until cancel using backup controlfile ; ORA-00279: change 1104149 generated at 06/06/2014 09:50:26 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/ORAC1/archivelog/2014_06_06/o1_mf_1_23_%u_.arc http://www.programering.com/a/MDMxYTNwATg.html ORA-00280: change 1104149 for thread 1 is in sequence #23 Specify log: {
Session and ProcessTracing Performance Faster Primary Key creation orenabling MyNotes 2014 Notes Dec-14 Jan-14 Mar-14 Apr-14 May-14 Aug-14 OCT-14 Nov-14 2013 Notes Apr-13 May-13 https://ora600tom.wordpress.com/2010/07/08/ora-00600-internal-error-code-arguments-2662/ Jun-13 July-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 2015 Notes Jun-15 Feb-15 Mar-15 Apr-15 May-15 Jul-15 Aug-15 Sep-15 Oct-15 Feedback About Profile Home > Oracle http://reneantunez.blogspot.com/2012/07/oracle-quick-tip-for-when-you-run-into.html > ORA-00600: internal error code, arguments: [2662], ORA-00600: internal error code, arguments: [2662], July 8, 2010 Ora600Tom Leave a comment Go to comments Wed Jul 7 03:59:44 2010 Errors in internal error file /opt/oracle/admin/xxx/bdump/xxx_smon_7875.trc: ORA-00600: internal error code, arguments: [2662], [1696], [1478225386], [1696], [1956780490], [8388610], [], [] replication_dependency_tracking turned off (no async multimaster replication found) Completed: alter database open Wed Jul 7 03:59:45 2010 Fatal internal error happened while SMON was doing active transaction recovery. Wed Jul 7 03:59:45 2010 Errors internal error code in file /opt/oracle/admin/xxx/bdump/xxx_smon_7875.trc: ORA-00600: internal error code, arguments: [2662], [1696], [1478225386], [1696], [1956780490], [8388610], [], [] That was an interesting problem. Infact database was UP in READONLY mode, what the DBA did, just brought it down. When he re-started (sql> startup;) the database started throwing ORA-00600 error and instance terminated by SMON. ORA-00600: internal error code, arguments: [2662], [1696], [1478225386], [1696], [1956780490], [8388610], [], [] That was very interesting why a re-start caused an ORA-00600 and SMON terminated the instance. We search through Metalink for this specific ORa-00600 error and found the first argument [2662] points a SCN mismatch, or block corruption etc. But, since the [b] and [d] are same, shows there is no SCN mismatch. we tried to open the database in READ ONLY mode, and failed with database need recovery. Wed Jul 7 01:21:30 2010 alter database open read only Wed