- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-12 18:08:59
|
查看: 2161 |
回复: 0
ALTER DATABASE OPEN MIGRATE
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Started redo scan
Completed redo scan
read 0 KB redo, 0 data blocks need recovery
Started redo application at
Thread 1: logseq 19108, block 2, scn 1321485890
Recovery of Online Redo Log: Thread 1 Group 6 Seq 19108 Reading mem 0
Mem# 0: E:\DATABASE\KKDB\REDO06.LOG
Completed redo application of 0.00MB
Completed crash recovery at
Thread 1: logseq 19108, block 3, scn 1321505892
0 data blocks read, 0 data blocks written, 0 redo k-bytes read
LGWR: STARTING ARCH PROCESSES
Tue May 31 23:58:14 2016
ARC0 started with pid=36, OS id=5952
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 advanced to log sequence 19109 (thread open)
Tue May 31 23:58:16 2016
ARC1 started with pid=37, OS id=704
Tue May 31 23:58:16 2016
ARC2 started with pid=38, OS id=812
Tue May 31 23:58:16 2016
ARC3 started with pid=39, OS id=5940
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
Tue May 31 23:58:17 2016
Thread 1 opened at log sequence 19109
ARC1: Becoming the heartbeat ARCH
Archived Log entry 29431 added for thread 1 sequence 19108 ID 0x6d7a43e8 dest 1:
Archived Log entry 29432 added for thread 1 sequence 19107 ID 0x6d7a43e8 dest 1:
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Current log# 1 seq# 19109 mem# 0: E:\DATABASE\KKDB\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 31 23:58:18 2016
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:11978505 end:11978895 diff:390 (3 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Updating 11.1.0.6.0 NLS parameters in sys.props$
-- adding 11.2.0.4.0 NLS parameters.
Errors in file F:\APP\ADMINISTRATOR\diag\rdbms\kkdb\kkdb\trace\kkdb_smon_3536.trc(incident=8513):
ORA-00600: internal error code, arguments: , [], [], [], [], [], [], [], [], [], [], []
Incident details in: F:\APP\ADMINISTRATOR\diag\rdbms\kkdb\kkdb\incident\incdir_8513\kkdb_smon_3536_i8513.trc
Stopping background process MMNL
Stopping background process MMON
Tue May 31 23:58:23 2016
Starting background process MMON
Tue May 31 23:58:23 2016
MMON started with pid=16, OS id=3572
Starting background process MMNL
ALTER SYSTEM enable restricted session;
ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY;
Autotune of undo retention is turned off.
ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY;
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=MEMORY;
Resource Manager disabled during database migration: plan '' not set
ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;
ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY;
Resource Manager disabled during database migration
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN MIGRATE
Tue May 31 23:58:25 2016
Starting background process CJQ0
Tue May 31 23:58:25 2016
CJQ0 started with pid=40, OS id=3912
Tue May 31 23:58:24 2016
MMNL started with pid=17, OS id=520
Tue May 31 23:58:30 2016
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ORACLE Instance kkdb (pid = 14) - Error 600 encountered while recovering transaction (12, 5).
alter system set "_allow_resetlogs_corruption"=truescope=spfile;
_corrupted_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,
_SYSSMU9$,_SYSSMU10$,_SYSSMU11$,_SYSSMU12$)
select name,ts#,status$ from undo$;
select file#,type# fromseg$ where ts#=6;
delete from seg$ where ts#=6;
commit;
_allow_read_only_corruption
_allow_resetlogs_corruption
_allow_terminal_recovery_corruption
_corrupted_rollback_segments
_log_buffers_corrupt
_allow_error_simulation
_allow_read_only_corruption
_allow_resetlogs_corruption
_allow_terminal_recovery_corruption
_gs_anti_semi_join_allowed
_tts_allow_nchar_mismatch
_discrete_transactions_enabled
_DISABLE_LOGGING
--查看参数的值
set linesize 132
column name format a42
column value format a12
select
x.ksppinmname,
y.ksppstvlvalue,
y.ksppstdfisdefault,
decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')ismod,
decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE')isadj
from
sys.x_$ksppi x,
sys.x$ksppcv y
where
x.inst_id = userenv('Instance') and
y.inst_id = userenv('Instance') and
x.indx = y.indx and x.ksppinm like '%transa%'
order by
translate(x.ksppinm, ' _', ' ')
/
OPEN下
alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1';
mount下
alter session set events '10015 trace name adjust_scn level 1';
如果SCN相差比较多,可以设置level 2,。。。level 10等
(level 1是每次打开时将将scn推进1百万) |
|