|
1 2 3 4 5 6 7 8 9 10 11 |
sys@ORALOCAL(10.1.19.11)> insert into hejianmin.kk values(222333); 已创建 1 行。 已用时间: 00: 00: 00.05 sys@ORALOCAL(10.1.19.11)> shutdown abort; ORACLE 例程已经关闭。 sys@ORALOCAL(10.1.19.11)> exit; 从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production中断开 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
C:\Documents and Settings\Administrator>d: D:\>cd D:\oracle\oradata\oralocal D:\oracle\oradata\oralocal>ls CONTROL01.CTL DRSYS01.DBF REDO0201.LOG REDO101.LOG REDO301.LOG TS_DATA_USER01.DBF TS_UNDO_02.DBF CONTROL02.CTL EXAMPLE01.DBF REDO0202.LOG REDO102.LOG REDO302.LOG TS_INDX_01.DBF XDB01.DBF CONTROL03.CTL ODM01.DBF REDO0301.LOG REDO201.LOG SYSTEM01.DBF TS_RMAN_01.DBF CWMLITE01.DBF PERFSTAT.DBF REDO0302.LOG REDO202.LOG TEMP.DBF TS_UNDO_01.DBF D:\oracle\oradata\oralocal>rm TS_UNDO_01.DBF D:\oracle\oradata\oralocal>set nls_lang=american D:\oracle\oradata\oralocal>sqlplus "/ as sysdba" |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 |
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jul 5 13:48:49 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to an idle instance. > startup ORACLE instance started. Total System Global Area 133765984 bytes Fixed Size 453472 bytes Variable Size 79691776 bytes Database Buffers 50331648 bytes Redo Buffers 3289088 bytes Database mounted. ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' > alter database datafile 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' offline drop; Database altered. Elapsed: 00:00:00.02 > alter database open; Database altered. Elapsed: 00:00:18.00 > create undo tablespace UNDOTBS03 datafile 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_03.dbf' size 100M; Tablespace created. Elapsed: 00:00:09.08 > alter system set undo_tablespace=UNDOTBS03 scope=spfile; System altered. Elapsed: 00:00:00.01 > shutdown immediate; ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' > select status from v$instance; select status from v$instance * ERROR at line 1: ORA-00600: internal error code, arguments: [1236], [], [], [], [], [], [], [] Elapsed: 00:00:02.00 > shutdown immediate; ORA-00600: internal error code, arguments: [1236], [], [], [], [], [], [], [] > startup; ORA-01081: cannot start already-running ORACLE - shut it down first > shutdown abort; ORACLE instance shut down. > startup ORACLE instance started. Total System Global Area 133765984 bytes Fixed Size 453472 bytes Variable Size 79691776 bytes Database Buffers 50331648 bytes Redo Buffers 3289088 bytes Database mounted. Database opened. > select SEGMENT_NAME,STATUS from dba_rollback_segs; SEGMENT_NAME STATUS ------------------------------ ---------------- SYSTEM ONLINE _SYSSMU1$ OFFLINE _SYSSMU2$ NEEDS RECOVERY _SYSSMU3$ NEEDS RECOVERY _SYSSMU4$ NEEDS RECOVERY _SYSSMU5$ NEEDS RECOVERY _SYSSMU6$ NEEDS RECOVERY _SYSSMU7$ NEEDS RECOVERY _SYSSMU8$ NEEDS RECOVERY _SYSSMU9$ NEEDS RECOVERY _SYSSMU10$ NEEDS RECOVERY _SYSSMU11$ OFFLINE _SYSSMU12$ OFFLINE _SYSSMU13$ OFFLINE _SYSSMU14$ OFFLINE _SYSSMU15$ OFFLINE _SYSSMU16$ OFFLINE _SYSSMU17$ OFFLINE _SYSSMU18$ OFFLINE _SYSSMU19$ OFFLINE _SYSSMU20$ NEEDS RECOVERY _SYSSMU21$ ONLINE _SYSSMU22$ ONLINE _SYSSMU23$ ONLINE _SYSSMU24$ ONLINE _SYSSMU25$ ONLINE _SYSSMU26$ ONLINE _SYSSMU27$ ONLINE _SYSSMU28$ ONLINE _SYSSMU29$ ONLINE _SYSSMU30$ ONLINE 31 rows selected. Elapsed: 00:00:02.00 > drop tablespace TS_UNDO_01 including contents and datafiles; drop tablespace TS_UNDO_01 including contents and datafiles * ERROR at line 1: ORA-01548: active rollback segment '_SYSSMU2$' found, terminate dropping tablespace Elapsed: 00:00:02.01 > shutdown immediate; ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' > shutdown abort; ORA-00600: internal error code, arguments: [1236], [], [], [], [], [], [], [] >exit |
vi INIToralocal.ORA
*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\admin\oralocal\bdump'
*.compatible='9.2.0.0.0'
*.control_file_record_keep_time=7
*.control_files='D:\ORACLE\ORADATA\ORALOCAL\CONTROL01.CTL','D:\ORACLE\ORADATA\ORALOCAL\CONTROL02.CTL','D:\ORACLE\ORADATA\ORALOCAL\CONTROL03.CTL'
*.core_dump_dest='D:\oracle\admin\oralocal\cdump'
*.db_block_size=8192
*.db_cache_size=50331648
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oralocal'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oralocalXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='oralocal'
*.java_pool_size=10485760
*.job_queue_processes=30
*.large_pool_size=16777216
*.log_archive_dest=''
*.log_archive_dest_1='LOCATION=D:\oracle\arch\oralocal mandatory reopen=120'
*.log_archive_dest_2=''
*.log_archive_dest_state_1='enable'
*.log_archive_max_processes=4
*.log_archive_start=TRUE
*.log_buffer=3145728
*.log_checkpoints_to_alert=FALSE
*.nls_date_format='DD-MON-YY'
*.open_cursors=300
*.pga_aggregate_target=33554432
*.processes=150
*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\admin\oralocal\bdump'
*.compatible='9.2.0.0.0'
*.control_file_record_keep_time=7
*.control_files='D:\ORACLE\ORADATA\ORALOCAL\CONTROL01.CTL','D:\ORACLE\ORADATA\ORALOCAL\CONTROL02.CTL','D:\ORACLE\ORADATA\ORALOCAL\CONTROL03.CTL'
*.core_dump_dest='D:\oracle\admin\oralocal\cdump'
*.db_block_size=8192
*.db_cache_size=50331648
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oralocal'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oralocalXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='oralocal'
*.java_pool_size=10485760
*.job_queue_processes=30
*.large_pool_size=16777216
*.log_archive_dest=''
*.log_archive_dest_1='LOCATION=D:\oracle\arch\oralocal mandatory reopen=120'
*.log_archive_dest_2=''
*.log_archive_dest_state_1='enable'
*.log_archive_max_processes=4
*.log_archive_start=TRUE
*.log_buffer=3145728
*.log_checkpoints_to_alert=FALSE
*.nls_date_format='DD-MON-YY'
*.open_cursors=300
*.pga_aggregate_target=33554432
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=FALSE
*.sga_max_size=115343360
*.shared_pool_size=33554432
*.sort_area_size=524288
*.sql_trace=FALSE
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS03'
*.user_dump_dest='D:\oracle\admin\oralocal\udump'
*.utl_file_dir='D:\oracle\ora92\logmnr'
_corrupted_rollback_segments=(_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$,_SYSSMU20$)
_offline_rollback_segments=true
~
~
~
:x
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
D:\oracle\ora92\database>sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jul 5 14:14:05 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to an idle instance. > startup pfile='?/database/INIToralocal.ORA' ORACLE instance started. Total System Global Area 133765984 bytes Fixed Size 453472 bytes Variable Size 79691776 bytes Database Buffers 50331648 bytes Redo Buffers 3289088 bytes Database mounted. Database opened. > > > drop tablespace TS_UNDO_01 including contents and datafiles; Tablespace dropped. Elapsed: 00:00:03.08 > |
一条评论
不知道这样的数据库敢放心使用吗？