十万火急！非归档，当前在线日志损坏，救火！

显示全部楼层 · 2010-1-19 10:46:33

Wed Mar 22 21:32:45 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
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
= 150
__shared_pool_size = 385875968
__large_pool_size= 16777216
__java_pool_size = 16777216
__streams_pool_size= 33554432
nls_language
= SIMPLIFIED CHINESE
nls_territory
= CHINA
sga_target
= 2046820352
control_files
= /opt/oracle/oradata/history/control01.ctl, /opt/oracle/oradata1/history/control02.ctl, /opt/oracle/oradata2/history/control03.ctl
db_block_size
= 8192
__db_cache_size
= 1577058304
compatible
= 10.2.0.1.0
db_files
= 65534
db_file_multiblock_read_count= 16
db_recovery_file_dest= /opt/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_allow_resetlogs_corruption= TRUE
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
dispatchers
= (PROTOCOL=TCP) (SERVICE=historyXDB)
job_queue_processes= 10
background_dump_dest = /opt/oracle/admin/history/bdump
user_dump_dest = /opt/oracle/admin/history/udump
core_dump_dest = /opt/oracle/admin/history/cdump
audit_file_dest
= /opt/oracle/admin/history/adump
db_name
= history
open_cursors
= 300
pga_aggregate_target = 679477248
Wed Mar 22 21:32:45 2006
WARNING:Oracle instance running on a system with low open file descriptor
limit. Tune your system to increase this limit to avoid
severe performance degradation.
PMON started with pid=2, OS id=8645
PSP0 started with pid=3, OS id=8647
MMAN started with pid=4, OS id=8649
DBW0 started with pid=5, OS id=8651
LGWR started with pid=6, OS id=8653
CKPT started with pid=7, OS id=8655
SMON started with pid=8, OS id=8657
RECO started with pid=9, OS id=8659
CJQ0 started with pid=10, OS id=8661
MMON started with pid=11, OS id=8663
Wed Mar 22 21:32:46 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=8665
Wed Mar 22 21:32:46 2006
starting up 1 shared server(s) ...
Wed Mar 22 21:32:46 2006
ALTER DATABASE MOUNT
Wed Mar 22 21:32:50 2006
Setting recovery target incarnation to 6
Wed Mar 22 21:32:51 2006
Successful mount of redo thread 1, with mount id 214671166
Wed Mar 22 21:32:51 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Mar 22 21:32:51 2006
ALTER DATABASE OPEN
Wed Mar 22 21:32:52 2006
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Wed Mar 22 21:32:53 2006
Started redo scan
Wed Mar 22 21:32:53 2006
Completed redo scan
2712 redo blocks read, 243 data blocks need recovery
Wed Mar 22 21:32:53 2006
Started redo application at
Thread 1: logseq 1, block 3
Wed Mar 22 21:32:53 2006
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata2/history/redo03.log
Mem# 1 errs 0: /opt/oracle/oradata1/history/redo03b.rdo
Mem# 2 errs 0: /opt/oracle/oradata/history/redo03c.rdo
Wed Mar 22 21:32:53 2006
Completed redo application
Wed Mar 22 21:32:53 2006
Completed crash recovery at
Thread 1: logseq 1, block 2715, scn 130974662
243 data blocks read, 243 data blocks written, 2712 redo blocks read
Wed Mar 22 21:32:55 2006
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: /opt/oracle/oradata1/history/redo01.log
Current log# 1 seq# 2 mem# 1: /opt/oracle/oradata/history/redo01b.log
Current log# 1 seq# 2 mem# 2: /opt/oracle/oradata2/history/redo01c.rdo
Successful open of redo thread 1
Wed Mar 22 21:32:56 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Mar 22 21:32:56 2006
SMON: enabling cache recovery
Wed Mar 22 21:32:56 2006
Successfully onlined Undo Tablespace 1.
Wed Mar 22 21:32:56 2006
SMON: enabling tx recovery
Wed Mar 22 21:32:56 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Mar 22 21:32:57 2006
Errors in file /opt/oracle/admin/history/bdump/history_smon_8657.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4193] [1334] [1679]
Starting background process QMNC
QMNC started with pid=19, OS id=8683
Wed Mar 22 21:32:57 2006
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Wed Mar 22 21:32:57 2006
Completed: ALTER DATABASE OPEN
Wed Mar 22 21:32:57 2006
Doing block recovery for file 2 block 2142
Block recovery from logseq 2, block 58 to scn 130974737
Wed Mar 22 21:32:57 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo01.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo01b.log
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo01c.rdo
Block recovery completed at rba 2.71.16, scn 0.130974738
Doing block recovery for file 2 block 9
Block recovery from logseq 2, block 58 to scn 130974718
Wed Mar 22 21:32:58 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo01.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo01b.log
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo01c.rdo
Block recovery completed at rba 2.59.16, scn 0.130974720
Wed Mar 22 21:32:58 2006
Errors in file /opt/oracle/admin/history/bdump/history_smon_8657.trc:
ORA-01595: Message 1595 not found; No message file for product=RDBMS, facility=ORA; arguments: [14] [1]
ORA-00607: Message 607 not found; No message file for product=RDBMS, facility=ORA
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4193] [1334] [1679]
Wed Mar 22 21:34:51 2006
Errors in file /opt/oracle/admin/history/bdump/history_mmon_8663.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
Wed Mar 22 21:34:52 2006
Flush retried for xcb 0x9ed02a20, pmd 0x9ff03978
Doing block recovery for file 2 block 1792
No block recovery was needed
Wed Mar 22 21:34:52 2006
Errors in file /opt/oracle/admin/history/bdump/history_mmon_8663.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
Wed Mar 22 21:35:07 2006
Errors in file /opt/oracle/admin/history/bdump/history_j000_8750.trc:
ORA-00600: internal error code, arguments: [4193], [1334], [1679], [], [], [], [], []
Wed Mar 22 21:35:08 2006
DEBUG: Replaying xcb 0x9ecf6f60, pmd 0x9fef2d64 for failed op 8
Doing block recovery for file 2 block 2142
Block recovery from logseq 2, block 58 to scn 130974737
Wed Mar 22 21:35:08 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo01.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo01b.log
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo01c.rdo
Block recovery completed at rba 2.71.16, scn 0.130974739
Wed Mar 22 21:35:08 2006
Errors in file /opt/oracle/admin/history/bdump/history_j000_8750.trc:
ORA-00600: internal error code, arguments: [4193], [1334], [1679], [], [], [], [], []
ORA-00600: internal error code, arguments: [4193], [1334], [1679], [], [], [], [], []
Wed Mar 22 21:35:09 2006
Errors in file /opt/oracle/admin/history/bdump/history_j000_8750.trc:
ORA-00600: internal error code, arguments: [4193], [1334], [1679], [], [], [], [], []
ORA-00600: internal error code, arguments: [4193], [1334], [1679], [], [], [], [], []
Wed Mar 22 21:35:09 2006
Flush retried for xcb 0x9ed02a20, pmd 0x9ff03978
Doing block recovery for file 2 block 1792
No block recovery was needed
Wed Mar 22 21:35:09 2006
Errors in file /opt/oracle/admin/history/bdump/history_pmon_8645.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
Wed Mar 22 21:35:10 2006
Errors in file /opt/oracle/admin/history/bdump/history_pmon_8645.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
PMON: terminating instance due to error 472
Instance terminated by PMON, pid = 8645
Wed Mar 22 21:36:08 2006
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:
LD_LIBRARY_PATH = /internetspy/occilib:
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
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
= 150
__shared_pool_size = 385875968
__large_pool_size= 16777216
__java_pool_size = 16777216
__streams_pool_size= 33554432
nls_language
= SIMPLIFIED CHINESE
nls_territory
= CHINA
sga_target
= 2046820352
control_files
= /opt/oracle/oradata/history/control01.ctl, /opt/oracle/oradata1/history/control02.ctl, /opt/oracle/oradata2/history/control03.ctl
db_block_size
= 8192
__db_cache_size
= 1577058304
compatible
= 10.2.0.1.0
db_files
= 65534
db_file_multiblock_read_count= 16
db_recovery_file_dest= /opt/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_allow_resetlogs_corruption= TRUE
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
dispatchers
= (PROTOCOL=TCP) (SERVICE=historyXDB)
job_queue_processes= 10
background_dump_dest = /opt/oracle/admin/history/bdump
user_dump_dest = /opt/oracle/admin/history/udump
core_dump_dest = /opt/oracle/admin/history/cdump
audit_file_dest
= /opt/oracle/admin/history/adump
db_name
= history
open_cursors
= 300
pga_aggregate_target = 679477248
Wed Mar 22 21:36:09 2006
WARNING:Oracle instance running on a system with low open file descriptor
limit. Tune your system to increase this limit to avoid
severe performance degradation.
PMON started with pid=2, OS id=8763
PSP0 started with pid=3, OS id=8765
MMAN started with pid=4, OS id=8767
DBW0 started with pid=5, OS id=8769
LGWR started with pid=6, OS id=8771
CKPT started with pid=7, OS id=8773
SMON started with pid=8, OS id=8775
RECO started with pid=9, OS id=8777
CJQ0 started with pid=10, OS id=8779
MMON started with pid=11, OS id=8781
Wed Mar 22 21:36:10 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=8783
Wed Mar 22 21:36:10 2006
starting up 1 shared server(s) ...
Wed Mar 22 21:36:10 2006
ALTER DATABASE MOUNT
Wed Mar 22 21:36:14 2006
Setting recovery target incarnation to 6
Wed Mar 22 21:36:14 2006
Successful mount of redo thread 1, with mount id 214713610
Wed Mar 22 21:36:14 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Mar 22 21:36:14 2006
ALTER DATABASE OPEN
Wed Mar 22 21:36:16 2006
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Wed Mar 22 21:36:16 2006
Started redo scan
Wed Mar 22 21:36:17 2006
Completed redo scan
167 redo blocks read, 71 data blocks need recovery
Wed Mar 22 21:36:17 2006
Started redo application at
Thread 1: logseq 2, block 3
Wed Mar 22 21:36:17 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo01.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo01b.log
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo01c.rdo
Wed Mar 22 21:36:17 2006
Completed redo application
Wed Mar 22 21:36:17 2006
Completed crash recovery at
Thread 1: logseq 2, block 170, scn 130994825
71 data blocks read, 71 data blocks written, 167 redo blocks read
Wed Mar 22 21:36:18 2006
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
Current log# 2 seq# 3 mem# 0: /opt/oracle/oradata1/history/redo02.log
Current log# 2 seq# 3 mem# 1: /opt/oracle/oradata/history/redo02b.rdo
Current log# 2 seq# 3 mem# 2: /opt/oracle/oradata2/history/redo02c.rdo
Successful open of redo thread 1
Wed Mar 22 21:36:20 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Mar 22 21:36:20 2006
SMON: enabling cache recovery
Wed Mar 22 21:36:20 2006
Successfully onlined Undo Tablespace 1.
Wed Mar 22 21:36:20 2006
SMON: enabling tx recovery
Wed Mar 22 21:36:20 2006
Database Characterset is ZHS16GBK
Wed Mar 22 21:36:20 2006
Errors in file /opt/oracle/admin/history/bdump/history_smon_8775.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4193] [1334] [1679]
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=8797
Wed Mar 22 21:36:21 2006
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Wed Mar 22 21:36:21 2006
Completed: ALTER DATABASE OPEN
Wed Mar 22 21:36:21 2006
Doing block recovery for file 2 block 2142
Block recovery from logseq 3, block 55 to scn 130994895
Wed Mar 22 21:36:21 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo02.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo02b.rdo
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo02c.rdo
Block recovery stopped at EOT rba 3.68.16
Block recovery completed at rba 3.68.16, scn 0.130994895
Doing block recovery for file 2 block 9
Block recovery from logseq 3, block 55 to scn 130994873
Wed Mar 22 21:36:21 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo02.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo02b.rdo
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo02c.rdo
Block recovery completed at rba 3.56.16, scn 0.130994874
Wed Mar 22 21:36:21 2006
Errors in file /opt/oracle/admin/history/bdump/history_smon_8775.trc:
ORA-01595: Message 1595 not found; No message file for product=RDBMS, facility=ORA; arguments: [14] [1]
ORA-00607: Message 607 not found; No message file for product=RDBMS, facility=ORA
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4193] [1334] [1679]
Wed Mar 22 21:36:21 2006
Errors in file /opt/oracle/admin/history/bdump/history_j000_8799.trc:
ORA-00600: internal error code, arguments: [4194], [25], [18], [], [], [], [], []
Wed Mar 22 21:36:22 2006
DEBUG: Replaying xcb 0x9ed08780, pmd 0x9fef2d64 for failed op 8
Doing block recovery for file 2 block 1792
No block recovery was needed
Wed Mar 22 21:36:22 2006
Errors in file /opt/oracle/admin/history/bdump/history_j000_8799.trc:
ORA-00600: internal error code, arguments: [4194], [25], [18], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [25], [18], [], [], [], [], []
Wed Mar 22 21:36:22 2006
Errors in file /opt/oracle/admin/history/bdump/history_j000_8799.trc:
ORA-00600: internal error code, arguments: [4194], [25], [18], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [25], [18], [], [], [], [], []
Wed Mar 22 21:36:23 2006
DEBUG: Replaying xcb 0x9ed08780, pmd 0x9fef2d64 for failed op 8
Doing block recovery for file 2 block 1792
No block recovery was needed
Wed Mar 22 21:36:23 2006
Errors in file /opt/oracle/admin/history/bdump/history_mmon_8781.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
Wed Mar 22 21:37:25 2006
DEBUG: Replaying xcb 0x9ed08780, pmd 0x9fef2d64 for failed op 8
Doing block recovery for file 2 block 1792　　
No block recovery was needed
Wed Mar 22 21:37:25 2006
Errors in file /opt/oracle/admin/history/bdump/history_pmon_8763.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
Wed Mar 22 21:37:26 2006
Errors in file /opt/oracle/admin/history/bdump/history_pmon_8763.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4194] [25] [18]
PMON: terminating instance due to error 472
Instance terminated by PMON, pid = 8763
　//参照网上一些说法使用*._allow_resetlogs_corruption=true ,
alter database open resetlogs;
能打开，但是实例马上又被终结了．　十万火急，数据库有５００Ｇ左右数据
繁请高手赐招！

千问 · 2010-1-19 10:46:33

能直接open resetlogs吗？那个参数什么用处

千问 · 2010-1-19 10:46:33

之前你的数据库是什么问题？
为什么要加隐含参数？之前就起不来么？

千问 · 2010-1-19 10:46:33

Starting background process QMNC
QMNC started with pid=19, OS id=8683
Wed Mar 22 21:32:57 2006
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Wed Mar 22 21:32:57 2006
Completed: ALTER DATABASE OPEN
Wed Mar 22 21:32:57 2006
Doing block recovery for file 2 block 2142
Block recovery from logseq 2, block 58 to scn 130974737
Wed Mar 22 21:32:57 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata1/history/redo01.log
Mem# 1 errs 0: /opt/oracle/oradata/history/redo01b.log
Mem# 2 errs 0: /opt/oracle/oradata2/history/redo01c.rdo
Block recovery completed at rba 2.71.16, scn 0.130974738

数据库起来后怎么要执行恢复redo log的操作呢，在启动之前做什么恢复工作了？

千问 · 2010-1-19 10:46:33

在这里还是要强调一下:各位兄弟在进行任何恢复操作前先复制现场...党...

千问 · 2010-1-19 10:46:33

非归档模式，应该不至于救火， google 一下，慢慢测

千问 · 2010-1-19 10:46:33

修改init文件增加隐含参数
*._allow_read_only_corruption=true
*._allow_resetlogs_corruption=true
*.db_block_checksum=false
*.db_block_checking=false
*._corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$'
event = "10210 trace name context forever, level 10"
event = "10211 trace name context forever, level 10"
解决启动数据库时报ora-600 [2662]错误
SQL> alter session set events '10015 trace name adjust_scn level 1';
会话已更改。
SQL> recover database using backup controlfile until cancel;
ORA-00279: 更改 41711706 (在 03/22/2006 17:52:14 生成) 对于线程 1 是必需的
ORA-00289: 建议: D:\ORACLE\ORA92\RDBMS\ARC00001.001
ORA-00280: 更改 41711706 对于线程 1 是按序列 # 1 进行的

指定日志: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误
ORA-01194: 文件1需要更多的恢复来保持一致性
ORA-01110: 数据文件 1: 'D:\ORACLE\ORADATA\PS\SYSTEM01.DBF'

ORA-01112: 未启动介质恢复

SQL> alter database open resetlogs;
报错,一个文件验正错误,文件大小不符合,删除之
alter database data file 'xxx' offline drop;
SQL> alter database open resetlogs;

导出数据时报临时表空间为空,重建临时表空间后导出成功
CREATETEMPORARY TABLESPACE temp2 TEMPFILE 'd:\oracle\oradata\ps\TEMP02.dbf' SIZE 50M REUSEAUTOEXTEND ON NEXT10M MAXSIZE2000M EXTENT MANAGEMENT LOCAL UNIFORMSIZE 1M;
alter database default temporary tablespace TEMP2;
drop tablespace temp including contents and datafiles;

千问 · 2010-1-19 10:46:33

'10015 trace name adjust_scn level 1'
是啥意思?

千问 · 2010-1-19 10:46:33

也是网上找到的

千问 · 2010-1-19 10:46:33

要充分的利用goole,baidu和pub搜索。哈
http://epub.itpub.net/5/1.htm
案例一大堆啊