标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,666)
- DB2 (22)
- MySQL (73)
- Oracle (1,528)
- Data Guard (51)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (559)
- Oracle安装升级 (90)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (77)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
- 数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
- 如何修改集群的公网信息(包括 VIP) (Doc ID 1674442.1)
- 如何在 oracle 集群环境下修改私网信息 (Doc ID 2103317.1)
- ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug
- ORA-600 krhpfh_03-1210故障处理
标签归档:ORA-600 kcm_headroom_warn_1
主机断电系统回到N年前数据库报ORA-600 kcm_headroom_warn_1错误
主机断电导致系统时间回退到14年前,数据库启动报ORA-600[kcm_headroom_warn_1]错误
Sat Jun 21 17:49:12 2014 ---正常系统时间 Instance shutdown complete Mon Aug 07 06:13:28 2000 ---重启后系统时间 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 64 Effective number of CPU for internal database sizing is 32 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 CELL communication is configured to use 0 interface(s): CELL IP affinity details: NUMA status: non-NUMA system cellaffinity.ora status: N/A CELL communication will use 1 IP group(s): Grp 0: Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =264 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. ORACLE_HOME = /ora1/prod/db/tech_st/11.2.0 System name: SunOS Node name: erpdb1-boot Release: 5.10 Version: Generic_147147-26 Machine: sun4v Using parameter settings in server-side spfile /ora1/prod/db/tech_st/11.2.0/dbs/spfileprod.ora System parameters with non-default values: processes = 1200 sessions = 2400 timed_statistics = TRUE event = "" shared_pool_size = 448M shared_pool_reserved_size= 322122547 nls_language = "american" nls_territory = "america" nls_sort = "binary" nls_date_format = "DD-MON-RR" nls_numeric_characters = ".," nls_comp = "binary" nls_length_semantics = "BYTE" sga_target = 10G control_files = "/data1/prod/db/apps_st/data/cntrl01.dbf" control_files = "/data1/prod/db/apps_st/data/cntrl02.dbf" control_files = "/data1/prod/db/apps_st/data/cntrl03.dbf" db_block_checksum = "TRUE" db_block_size = 8192 compatible = "11.1.0" log_archive_dest_1 = "location=/arch1/prod/arch" log_archive_format = "prod_%t_%s_%r.arc" log_buffer = 10485760 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = "AUTO" undo_tablespace = "APPS_UNDOTS1" db_block_checking = "FALSE" _disable_fast_validate = TRUE sec_case_sensitive_logon = FALSE session_cached_cursors = 500 utl_file_dir = "/usr/tmp" plsql_code_type = "INTERPRETED" plsql_optimize_level = 2 job_queue_processes = 10 _system_trig_enabled = TRUE cursor_sharing = "EXACT" parallel_min_servers = 0 parallel_max_servers = 8 audit_file_dest = "/ora1/prod/db/tech_st/admin/prod/adump" db_name = "prod" open_cursors = 3600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = "true" _like_with_bind_as_equality= TRUE pga_aggregate_target = 2G workarea_size_policy = "AUTO" _optimizer_autostats_job = FALSE optimizer_secure_view_merging= FALSE aq_tm_processes = 4 olap_page_pool_size = 4M diagnostic_dest = "/ora1/prod/db/tech_st/11.2.0/admin/prod_erpdb1" _trace_files_public = TRUE max_dump_file_size = "20480" Mon Aug 07 06:13:30 2000 PMON started with pid=2, OS id=3556 Mon Aug 07 06:13:30 2000 PSP0 started with pid=3, OS id=3557 Mon Aug 07 06:13:31 2000 VKTM started with pid=4, OS id=3558 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Mon Aug 07 06:13:31 2000 GEN0 started with pid=5, OS id=3562 Mon Aug 07 06:13:32 2000 DIAG started with pid=6, OS id=3564 Mon Aug 07 06:13:32 2000 DBRM started with pid=7, OS id=3565 Mon Aug 07 06:13:32 2000 DIA0 started with pid=8, OS id=3566 Mon Aug 07 06:13:32 2000 MMAN started with pid=9, OS id=3567 Mon Aug 07 06:13:32 2000 DBW0 started with pid=10, OS id=3568 Mon Aug 07 06:13:32 2000 DBW1 started with pid=11, OS id=3569 Mon Aug 07 06:13:32 2000 DBW2 started with pid=12, OS id=3570 Mon Aug 07 06:13:32 2000 DBW3 started with pid=13, OS id=3571 Mon Aug 07 06:13:32 2000 LGWR started with pid=14, OS id=3572 at elevated priority Mon Aug 07 06:13:32 2000 CKPT started with pid=15, OS id=3575 Mon Aug 07 06:13:32 2000 SMON started with pid=16, OS id=3576 Mon Aug 07 06:13:32 2000 RECO started with pid=17, OS id=3577 Mon Aug 07 06:13:32 2000 MMON started with pid=18, OS id=3578 Mon Aug 07 06:13:32 2000 MMNL started with pid=19, OS id=3579 ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /ora1/prod/db/tech_st Mon Aug 07 06:13:32 2000 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 4111810188 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Mon Aug 07 06:13:36 2000 ALTER DATABASE OPEN ************************************************************ Warning: The SCN headroom for this database is only -51464 hours! ************************************************************ Errors in file /ora1/prod/db/tech_st/11.2.0/admin/prod_erpdb1/diag/rdbms/prod/prod/trace/prod_ora_3583.trc (incident=441878): ORA-00600: internal error code, arguments: [kcm_headroom_warn_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /ora1/prod/db/tech_st/11.2.0/admin/prod_erpdb1/diag/rdbms/prod/prod/incident/incdir_441878/prod_ora_3583_i441878.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /ora1/prod/db/tech_st/11.2.0/admin/prod_erpdb1/diag/rdbms/prod/prod/trace/prod_ora_3583.trc: ORA-00600: internal error code, arguments: [kcm_headroom_warn_1], [], [], [], [], [], [], [], [], [], [], [] ORA-600 signalled during: ALTER DATABASE OPEN... Dumping diagnostic data in directory=[cdmp_20000807061339], requested by (instance=1, osid=3583), summary=[incident=441878]. Mon Aug 07 06:14:35 2000 Sweep [inc][441878]: completed Sweep [inc2][441878]: completed
在数据库出现莫名其妙问题不能启动之时,请注意主机时间,另外还有一例:记录一次ORA-00600[2252]故障解决