undo表空间丢失之恢复

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

相关文章

一条评论

发表评论

电子邮件地址不会被公开。 必填项已用*标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据