ORA-00600: ORA-12012 ORA-08102解决
来源:互联网 发布:最新聊天软件 编辑:程序博客网 时间:2024/05/10 19:05
SQL> startup pfile=?/dbs/inittesttt.ora
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 184550656 bytes
Database Buffers 1946157056 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
启动不了数据库。实例会自动关闭。警告日志里显示:
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p002_5401.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p007_5411.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p003_5403.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/udump/testtt_ora_5395.trc:
ORA-00600: internal error code, arguments: [4193], [23533], [23595], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p001_5399.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Doing block recovery for file 2 block 131316
SQL> startup mount;
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_management=manual scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> create undo tablespace undotbs2 datafile '/db/oracle10g/oradata/testtt/undotbs02.dbf' size 2048m;
Tablespace created.
SQL> alter system set undo_tablespace="UNDOTBS2" scope=spfile;
System altered.
SQL> alter system set undo_management=auto scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SQL>
SQL>
到现在,库能起来了。
启动的时候报错:
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p005_10503.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Dec 17 09:15:09 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p007_10507.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=10509
Fri Dec 17 09:15:14 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_mmon_10483.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.11% used, and has 40616960 remaining bytes available.
Fri Dec 17 09:15:14 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Dec 17 09:15:15 2010
SMON: Restarting fast_start parallel rollback
Fri Dec 17 09:15:15 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p000_10493.trc:
ORA-00600: internal error code, arguments: [4198], [9], [], [], [], [], [], []
Fri Dec 17 09:15:16 2010
Completed: ALTER DATABASE OPEN
Fri Dec 17 09:15:17 2010
Doing block recovery for file 2 block 81
Block recovery from logseq 11, block 3 to scn 613750430
Fri Dec 17 09:15:17 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: /db/oracle10g/oradata/testtt/redo02.log
Block recovery completed at rba 11.3.16, scn 0.613750431
Doing block recovery for file 14 block 473
Block recovery from logseq 11, block 138 to scn 613750553
Fri Dec 17 09:15:17 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: /db/oracle10g/oradata/testtt/redo02.log
Block recovery completed at rba 11.138.16, scn 0.613750554
Fri Dec 17 09:15:17 2010
SMON: ignoring slave err,downgrading to serial rollback
Fri Dec 17 09:15:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_smon_10477.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance testtt (pid = 8) - Error 600 encountered while recovering transaction (15, 19).
Fri Dec 17 09:15:18 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_smon_10477.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
Fri Dec 17 09:15:24 2010
ORA-01555 caused by SQL statement below (SQL ID: 41kvabf2pspqq, Query Duration=5 sec, SCN: 0x0000.24951735):
Fri Dec 17 09:15:24 2010
UPDATE TYPE SET ARTICLENUM = ( SELECT COUNT(*) FROM MV_ARTICLE WHERE F_TYPE_ID = TYPE.ID),LASTERDAYNUM = ( SELECT COUNT(*) FROM MV_ARTICLE WHERE PUBDATE > SYSDATE-1 AND F_TYPE_ID = TYPE.ID )
Fri Dec 17 09:15:24 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j001_10513.trc:
ORA-12012: error on auto execute of job 5
ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15$" too small
ORA-06512: at "LIZARD.ARTSTAT_JOB", line 11
ORA-06512: at line 1
Fri Dec 17 09:15:25 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j003_10517.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Dec 17 09:15:28 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j003_10517.trc:
ORA-12012: error on auto execute of job 2
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Fri Dec 17 09:15:28 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
Fri Dec 17 09:15:31 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 09:15:31 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 09:15:33 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
先解决ORA-19815:
使用rman删除旧的过期的日志
c:\>rman
rman>connect target sys/oracle
rman>crosscheck archivelog all;
rman>delete noprompt expired copy;
..........
rman>
执行后,检查空间使用情况
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE .72 .36 2
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> SELECT substr(name, 1, 30) name, space_limit AS quota,space_used AS used,space_reclaimable AS reclaimable,number_of_files AS files FROM v$recovery_file_dest ;
NAME QUOTA USED RECLAIMABLE FILES
------------------------------------------------------------ ---------- ---------- ----------- ----------
/db/oracle10g/flash_recovery_a 2147483648 15368192 7684096 2
SQL> drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU15$' found, terminate dropping tablespace
SQL> SELECT SEGMENT_NAME,STATUS FROM DBA_ROLLBACK_SEGS where tablespace_name='UNDOTBS1'
2 ;
SEGMENT_NAME STATUS
------------------------------ ----------------
_SYSSMU15$ NEEDS RECOVERY
_SYSSMU16$ OFFLINE
_SYSSMU17$ OFFLINE
_SYSSMU18$ OFFLINE
_SYSSMU19$ OFFLINE
_SYSSMU20$ OFFLINE
_SYSSMU21$ OFFLINE
_SYSSMU22$ OFFLINE
_SYSSMU23$ OFFLINE
_SYSSMU24$ OFFLINE
_SYSSMU25$ OFFLINE
SEGMENT_NAME STATUS
------------------------------ ----------------
_SYSSMU26$ OFFLINE
_SYSSMU27$ OFFLINE
_SYSSMU28$ OFFLINE
_SYSSMU29$ OFFLINE
_SYSSMU30$ OFFLINE
drop不掉:
如果归档文件完整,可以作数据文件的恢复,然后将其offline drop掉。
但是归档文件已经被RMAN作业删除了一部分,怎么办呢 ? 最后一招就是
使用隐含参数_CORRUPTED_ROLLBACK_SEGMENTS.
(数据库是测试库)
修改init.ora 文件,加上:
_CORRUPTED_ROLLBACK_SEGMENTS=(_SYSSMU15$)
重新mount并且打开数据库,
删除已经不用的undotbs1:
drop tablespace undotbs1 including contents and datafiles;
关闭instance, 注释掉参数_CORRUPTED_ROLLBACK_SEGMENTS
重新启动实例, 生成新的spfile, 作备份.
但是还是报错:
Fri Dec 17 18:23:31 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
Fri Dec 17 18:23:32 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:23:32 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:23:34 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:25:16 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
Fri Dec 17 18:25:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:25:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:25:18 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
SQL>
SQL> select job,log_user,schema_user,what,LAST_DATE,LAST_SEC,THIS_DATE,THIS_SEC,NEXT_DATE,NEXT_SEC,INTERVAL from dba_jobs where job=1;
JOB LOG_USER SCHEMA_USER WHAT
---------- ------------------------------ ------------------------------- ------------------------------------------ ---------------- ------------ ---------------- ------------ ----------------
INTERVAL
------------------------------------------------------------------------------------------------------------------------------------------------------
1 SYSMAN SYSMAN
EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
16-DEC-10 15:16:13 17-DEC-10 18:23:31 16-DEC-10 15:17:13
sysdate + 1 / (24 * 60)
SQL> alter index I_JOB_NEXT rebuild;
Index altered.
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 201327872 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
SQL>
发现rebuild不能解决问题:看日志:
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=24169
Fri Dec 17 18:31:01 2010
db_recovery_file_dest_size of 2048 MB is 0.36% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Dec 17 18:31:01 2010
Completed: ALTER DATABASE OPEN
Fri Dec 17 18:31:01 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
Fri Dec 17 18:31:04 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:31:04 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:31:06 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:32:41 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
Fri Dec 17 18:32:43 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:32:43 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:32:44 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
drop掉,重新建:
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 201327872 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>
SQL> select obj#,name from obj$ where obj#=239
2 ;
OBJ# NAME
---------- ------------------------------
239 I_JOB_NEXT
SQL>
SQL>
SQL> select index_name,column_name from all_ind_columns where index_name='I_JOB_NEXT';
INDEX_NAME
------------------------------
COLUMN_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
I_JOB_NEXT
NEXT_DATE
SQL>
SQL> drop index I_JOB_NEXT;
Index dropped.
SQL> create index I_JOB_NEXT on job$(next_date);
Index created.
SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 201327872 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
Fri Dec 17 18:33:30 2010
Starting background process EMN0
EMN0 started with pid=20, OS id=24183
Fri Dec 17 18:33:31 2010
Shutting down instance: further logons disabled
Fri Dec 17 18:33:31 2010
Stopping background process QMNC
Fri Dec 17 18:33:31 2010
Stopping background process CJQ0
Fri Dec 17 18:33:33 2010
Stopping background process MMNL
Fri Dec 17 18:33:34 2010
Stopping background process MMON
Fri Dec 17 18:33:35 2010
Shutting down instance (immediate)
License high water mark = 2
Fri Dec 17 18:33:35 2010
Stopping Job queue slave processes
Fri Dec 17 18:33:40 2010
Process OS id : 24181 alive after kill
Errors in file
Fri Dec 17 18:33:40 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Dec 17 18:33:42 2010
ALTER DATABASE CLOSE NORMAL
Fri Dec 17 18:33:42 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 17 18:33:42 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 68
Successful close of redo thread 1
Fri Dec 17 18:33:42 2010
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 17 18:33:42 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Dec 17 18:33:49 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =36
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.1.0.
System parameters with non-default values:
processes = 300
sessions = 335
timed_statistics = FALSE
__shared_pool_size = 134217728
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 33554432
sga_target = 2147483648
control_files = /db/oracle10g/oradata/testtt/control01.ctl, /db/oracle10g/oradata/testtt/control02.ctl, /db/oracle10g/oradata/testtt/control03.ctl
db_block_size = 8192
__db_cache_size = 1929379840
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /db/oracle10g/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS2
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=testttXDB)
job_queue_processes = 10
background_dump_dest = /db/oracle10g/admin/testtt/bdump
user_dump_dest = /db/oracle10g/admin/testtt/udump
core_dump_dest = /db/oracle10g/admin/testtt/cdump
audit_file_dest = /db/oracle10g/admin/testtt/adump
db_name = testtt
open_cursors = 300
pga_aggregate_target = 825229312
PMON started with pid=2, OS id=24186
PSP0 started with pid=3, OS id=24188
MMAN started with pid=4, OS id=24190
DBW0 started with pid=5, OS id=24192
LGWR started with pid=6, OS id=24194
CKPT started with pid=7, OS id=24196
SMON started with pid=8, OS id=24198
RECO started with pid=9, OS id=24200
CJQ0 started with pid=10, OS id=24202
MMON started with pid=11, OS id=24204
Fri Dec 17 18:33:49 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=24206
Fri Dec 17 18:33:49 2010
starting up 1 shared server(s) ...
Fri Dec 17 18:33:49 2010
ALTER DATABASE MOUNT
Fri Dec 17 18:33:53 2010
Setting recovery target incarnation to 3
Fri Dec 17 18:33:53 2010
Successful mount of redo thread 1, with mount id 2739754061
Fri Dec 17 18:33:53 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 17 18:33:53 2010
ALTER DATABASE OPEN
Fri Dec 17 18:33:53 2010
Thread 1 opened at log sequence 68
Current log# 2 seq# 68 mem# 0: /db/oracle10g/oradata/testtt/redo02.log
Successful open of redo thread 1
Fri Dec 17 18:33:53 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 17 18:33:53 2010
SMON: enabling cache recovery
Fri Dec 17 18:33:53 2010
Successfully onlined Undo Tablespace 5.
Fri Dec 17 18:33:53 2010
SMON: enabling tx recovery
Fri Dec 17 18:33:53 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=24214
Fri Dec 17 18:33:54 2010
db_recovery_file_dest_size of 2048 MB is 0.36% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Dec 17 18:33:54 2010
catalog备份数据库
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 184550656 bytes
Database Buffers 1946157056 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
启动不了数据库。实例会自动关闭。警告日志里显示:
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p002_5401.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p007_5411.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p003_5403.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/udump/testtt_ora_5395.trc:
ORA-00600: internal error code, arguments: [4193], [23533], [23595], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p001_5399.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Doing block recovery for file 2 block 131316
SQL> startup mount;
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_management=manual scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> create undo tablespace undotbs2 datafile '/db/oracle10g/oradata/testtt/undotbs02.dbf' size 2048m;
Tablespace created.
SQL> alter system set undo_tablespace="UNDOTBS2" scope=spfile;
System altered.
SQL> alter system set undo_management=auto scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SQL>
SQL>
到现在,库能起来了。
启动的时候报错:
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p005_10503.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Dec 17 09:15:09 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p007_10507.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=10509
Fri Dec 17 09:15:14 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_mmon_10483.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.11% used, and has 40616960 remaining bytes available.
Fri Dec 17 09:15:14 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Dec 17 09:15:15 2010
SMON: Restarting fast_start parallel rollback
Fri Dec 17 09:15:15 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p000_10493.trc:
ORA-00600: internal error code, arguments: [4198], [9], [], [], [], [], [], []
Fri Dec 17 09:15:16 2010
Completed: ALTER DATABASE OPEN
Fri Dec 17 09:15:17 2010
Doing block recovery for file 2 block 81
Block recovery from logseq 11, block 3 to scn 613750430
Fri Dec 17 09:15:17 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: /db/oracle10g/oradata/testtt/redo02.log
Block recovery completed at rba 11.3.16, scn 0.613750431
Doing block recovery for file 14 block 473
Block recovery from logseq 11, block 138 to scn 613750553
Fri Dec 17 09:15:17 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: /db/oracle10g/oradata/testtt/redo02.log
Block recovery completed at rba 11.138.16, scn 0.613750554
Fri Dec 17 09:15:17 2010
SMON: ignoring slave err,downgrading to serial rollback
Fri Dec 17 09:15:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_smon_10477.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance testtt (pid = 8) - Error 600 encountered while recovering transaction (15, 19).
Fri Dec 17 09:15:18 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_smon_10477.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
Fri Dec 17 09:15:24 2010
ORA-01555 caused by SQL statement below (SQL ID: 41kvabf2pspqq, Query Duration=5 sec, SCN: 0x0000.24951735):
Fri Dec 17 09:15:24 2010
UPDATE TYPE SET ARTICLENUM = ( SELECT COUNT(*) FROM MV_ARTICLE WHERE F_TYPE_ID = TYPE.ID),LASTERDAYNUM = ( SELECT COUNT(*) FROM MV_ARTICLE WHERE PUBDATE > SYSDATE-1 AND F_TYPE_ID = TYPE.ID )
Fri Dec 17 09:15:24 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j001_10513.trc:
ORA-12012: error on auto execute of job 5
ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15$" too small
ORA-06512: at "LIZARD.ARTSTAT_JOB", line 11
ORA-06512: at line 1
Fri Dec 17 09:15:25 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j003_10517.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Dec 17 09:15:28 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j003_10517.trc:
ORA-12012: error on auto execute of job 2
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Fri Dec 17 09:15:28 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
Fri Dec 17 09:15:31 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 09:15:31 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 09:15:33 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_10511.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
先解决ORA-19815:
使用rman删除旧的过期的日志
c:\>rman
rman>connect target sys/oracle
rman>crosscheck archivelog all;
rman>delete noprompt expired copy;
..........
rman>
执行后,检查空间使用情况
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE .72 .36 2
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> SELECT substr(name, 1, 30) name, space_limit AS quota,space_used AS used,space_reclaimable AS reclaimable,number_of_files AS files FROM v$recovery_file_dest ;
NAME QUOTA USED RECLAIMABLE FILES
------------------------------------------------------------ ---------- ---------- ----------- ----------
/db/oracle10g/flash_recovery_a 2147483648 15368192 7684096 2
SQL> drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU15$' found, terminate dropping tablespace
SQL> SELECT SEGMENT_NAME,STATUS FROM DBA_ROLLBACK_SEGS where tablespace_name='UNDOTBS1'
2 ;
SEGMENT_NAME STATUS
------------------------------ ----------------
_SYSSMU15$ NEEDS RECOVERY
_SYSSMU16$ OFFLINE
_SYSSMU17$ OFFLINE
_SYSSMU18$ OFFLINE
_SYSSMU19$ OFFLINE
_SYSSMU20$ OFFLINE
_SYSSMU21$ OFFLINE
_SYSSMU22$ OFFLINE
_SYSSMU23$ OFFLINE
_SYSSMU24$ OFFLINE
_SYSSMU25$ OFFLINE
SEGMENT_NAME STATUS
------------------------------ ----------------
_SYSSMU26$ OFFLINE
_SYSSMU27$ OFFLINE
_SYSSMU28$ OFFLINE
_SYSSMU29$ OFFLINE
_SYSSMU30$ OFFLINE
drop不掉:
如果归档文件完整,可以作数据文件的恢复,然后将其offline drop掉。
但是归档文件已经被RMAN作业删除了一部分,怎么办呢 ? 最后一招就是
使用隐含参数_CORRUPTED_ROLLBACK_SEGMENTS.
(数据库是测试库)
修改init.ora 文件,加上:
_CORRUPTED_ROLLBACK_SEGMENTS=(_SYSSMU15$)
重新mount并且打开数据库,
删除已经不用的undotbs1:
drop tablespace undotbs1 including contents and datafiles;
关闭instance, 注释掉参数_CORRUPTED_ROLLBACK_SEGMENTS
重新启动实例, 生成新的spfile, 作备份.
但是还是报错:
Fri Dec 17 18:23:31 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
Fri Dec 17 18:23:32 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:23:32 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:23:34 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24125.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:25:16 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
Fri Dec 17 18:25:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:25:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
Fri Dec 17 18:25:18 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24129.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 1674 (2)
SQL>
SQL> select job,log_user,schema_user,what,LAST_DATE,LAST_SEC,THIS_DATE,THIS_SEC,NEXT_DATE,NEXT_SEC,INTERVAL from dba_jobs where job=1;
JOB LOG_USER SCHEMA_USER WHAT
---------- ------------------------------ ------------------------------- ------------------------------------------ ---------------- ------------ ---------------- ------------ ----------------
INTERVAL
------------------------------------------------------------------------------------------------------------------------------------------------------
1 SYSMAN SYSMAN
EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
16-DEC-10 15:16:13 17-DEC-10 18:23:31 16-DEC-10 15:17:13
sysdate + 1 / (24 * 60)
SQL> alter index I_JOB_NEXT rebuild;
Index altered.
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 201327872 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
SQL>
发现rebuild不能解决问题:看日志:
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=24169
Fri Dec 17 18:31:01 2010
db_recovery_file_dest_size of 2048 MB is 0.36% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Dec 17 18:31:01 2010
Completed: ALTER DATABASE OPEN
Fri Dec 17 18:31:01 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
Fri Dec 17 18:31:04 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:31:04 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:31:06 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24173.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:32:41 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
Fri Dec 17 18:32:43 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:32:43 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
Fri Dec 17 18:32:44 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_j000_24181.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
ORA-12012: error on auto execute of job 1
ORA-08102: index key not found, obj# 239, file 1, block 63282 (2)
drop掉,重新建:
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 201327872 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>
SQL> select obj#,name from obj$ where obj#=239
2 ;
OBJ# NAME
---------- ------------------------------
239 I_JOB_NEXT
SQL>
SQL>
SQL> select index_name,column_name from all_ind_columns where index_name='I_JOB_NEXT';
INDEX_NAME
------------------------------
COLUMN_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
I_JOB_NEXT
NEXT_DATE
SQL>
SQL> drop index I_JOB_NEXT;
Index dropped.
SQL> create index I_JOB_NEXT on job$(next_date);
Index created.
SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 201327872 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>
Fri Dec 17 18:33:30 2010
Starting background process EMN0
EMN0 started with pid=20, OS id=24183
Fri Dec 17 18:33:31 2010
Shutting down instance: further logons disabled
Fri Dec 17 18:33:31 2010
Stopping background process QMNC
Fri Dec 17 18:33:31 2010
Stopping background process CJQ0
Fri Dec 17 18:33:33 2010
Stopping background process MMNL
Fri Dec 17 18:33:34 2010
Stopping background process MMON
Fri Dec 17 18:33:35 2010
Shutting down instance (immediate)
License high water mark = 2
Fri Dec 17 18:33:35 2010
Stopping Job queue slave processes
Fri Dec 17 18:33:40 2010
Process OS id : 24181 alive after kill
Errors in file
Fri Dec 17 18:33:40 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Dec 17 18:33:42 2010
ALTER DATABASE CLOSE NORMAL
Fri Dec 17 18:33:42 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 17 18:33:42 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 68
Successful close of redo thread 1
Fri Dec 17 18:33:42 2010
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 17 18:33:42 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Dec 17 18:33:49 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =36
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.1.0.
System parameters with non-default values:
processes = 300
sessions = 335
timed_statistics = FALSE
__shared_pool_size = 134217728
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 33554432
sga_target = 2147483648
control_files = /db/oracle10g/oradata/testtt/control01.ctl, /db/oracle10g/oradata/testtt/control02.ctl, /db/oracle10g/oradata/testtt/control03.ctl
db_block_size = 8192
__db_cache_size = 1929379840
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /db/oracle10g/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS2
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=testttXDB)
job_queue_processes = 10
background_dump_dest = /db/oracle10g/admin/testtt/bdump
user_dump_dest = /db/oracle10g/admin/testtt/udump
core_dump_dest = /db/oracle10g/admin/testtt/cdump
audit_file_dest = /db/oracle10g/admin/testtt/adump
db_name = testtt
open_cursors = 300
pga_aggregate_target = 825229312
PMON started with pid=2, OS id=24186
PSP0 started with pid=3, OS id=24188
MMAN started with pid=4, OS id=24190
DBW0 started with pid=5, OS id=24192
LGWR started with pid=6, OS id=24194
CKPT started with pid=7, OS id=24196
SMON started with pid=8, OS id=24198
RECO started with pid=9, OS id=24200
CJQ0 started with pid=10, OS id=24202
MMON started with pid=11, OS id=24204
Fri Dec 17 18:33:49 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=24206
Fri Dec 17 18:33:49 2010
starting up 1 shared server(s) ...
Fri Dec 17 18:33:49 2010
ALTER DATABASE MOUNT
Fri Dec 17 18:33:53 2010
Setting recovery target incarnation to 3
Fri Dec 17 18:33:53 2010
Successful mount of redo thread 1, with mount id 2739754061
Fri Dec 17 18:33:53 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 17 18:33:53 2010
ALTER DATABASE OPEN
Fri Dec 17 18:33:53 2010
Thread 1 opened at log sequence 68
Current log# 2 seq# 68 mem# 0: /db/oracle10g/oradata/testtt/redo02.log
Successful open of redo thread 1
Fri Dec 17 18:33:53 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 17 18:33:53 2010
SMON: enabling cache recovery
Fri Dec 17 18:33:53 2010
Successfully onlined Undo Tablespace 5.
Fri Dec 17 18:33:53 2010
SMON: enabling tx recovery
Fri Dec 17 18:33:53 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=24214
Fri Dec 17 18:33:54 2010
db_recovery_file_dest_size of 2048 MB is 0.36% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Dec 17 18:33:54 2010
Completed: ALTER DATABASE OPEN
ORA-16038的解决
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
ORA-31613 Master process DM00 failed during startup
ORA-24324 ORA-01041 ORA-03113
ORA-27125: unable to create shared memory segment
ORA-00245: control file backup operation failed
ORA-00245: control file backup operation failed
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)
- ORA-00600: ORA-12012 ORA-08102解决
- ORA-12012 ORA-08102故障排查和错误解决
- ORA
- ora
- ORA-12012,ORA-12005
- ORA-00600 ORA-07445
- ora-00607 ora-00600
- ora-01555,ORA-22924解决
- 解决ORA-01034/ORA-27101
- 解决 ORA-00305, ORA-00312以及ORA-01194, ORA-01110
- ORA-12012 ORA-29280 ORA-06512
- ORA-12560、ORA-01033、ORA-00600
- Oracle ORA-01034,ORA-27101,ORA-00600
- ORA-00600 ORA-01565 ORA-27046
- ORA-00600的解决经历
- ora 00600 kcratr1_lostbwrt 错误解决
- ORA-00600[kcratr_nab_less_than_odr]故障解决
- ORACLE ORA-00600 错误解决
- android 混淆代码gson数据nullpointerexception
- JSChart:Input data in wrong format for selected chart type
- 我对linux理解之v4l2
- 正态分布的前世今生之三
- 正态分布的前世今生之四
- ORA-00600: ORA-12012 ORA-08102解决
- 【新闻】长沙一年投入15亿元保证项目建设 群众乐享文化大餐
- 包茂高速两辆法拉利跑车撞栏 1辆面目全非(图)-法拉利
- 设计网站大全
- 从 prototype.js 深入学习 javascript 的面向对象特性
- c++基础学习 - 命名空间
- Ubuntu12.04建立PHP服务器(apache+php+mysql)
- linux下完全删除oracle
- hdu 4293 Groups