过期的归档日志文件已经删除,如何删除在DBA Stdio->存储->归档日志 对应的路径 关闭数据库,修改init.ora文件,把其中的有关归档的东东注释掉!然后修改为非归档。这样路径就没有了,也不能归档了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不行呀,已注释了:#log_archive_dest_1 = "LOCATION=D:\Oracle\oradata\HHTHTY\archive"#log_buffer = 65536#log_checkpoint_interval = 10000#log_checkpoint_timeout = 1800initMyHHTHTY.ora如下:background_dump_dest = D:\Oracle\admin\HHTHTY\bdumpcompatible = 8.1.0control_files = "D:\Oracle\oradata\HHTHTY\control01.ctl"control_files = "D:\Oracle\oradata\HHTHTY\control02.ctl"control_files = "D:\Oracle\oradata\HHTHTY\control03.ctl"db_block_buffers = 2048db_block_size = 8192db_file_multiblock_read_count = 8db_files = 1024db_name = HHTHTYdistributed_transactions = 10global_names = TRUEinstance_name = HHTHTYjava_pool_size = 20971520job_queue_interval = 60job_queue_processes = 4large_pool_size = 614400#log_archive_dest_1 = "LOCATION=D:\Oracle\oradata\HHTHTY\archive"#log_buffer = 65536#log_checkpoint_interval = 10000#log_checkpoint_timeout = 1800max_dump_file_size = 10240max_enabled_roles = 30mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"open_cursors = 100open_links = 4oracle_trace_collection_name = ""os_authent_prefix = ""parallel_max_servers = 5processes = 115remote_login_passwordfile = EXCLUSIVEservice_names = HHTHTYshared_pool_size = 52428800sort_area_retained_size = 65536sort_area_size = 65536timed_statistics = trueuser_dump_dest = D:\Oracle\admin\HHTHTY\udump 统计一个表的字段数量,有两个条件限制 关于orcle参数一点问题 对于一个记录数特别多的表如何加快查询速度 oracle中怎么实现从一张表插入另张表并比较表中的数据是否一致,一致就不导入 关于执行动态SQL问题?? Oracle错误信息存放的表? 菜鸟问题 如何在同一个表里保持数据的唯一性? 如何使用plsql实现多表的删除?! 哪有SQL语句语法书籍下载,谢了! 完全型备份后导入出现的错如何解决??????????? 关于字符集的一个问题
#log_archive_dest_1 = "LOCATION=D:\Oracle\oradata\HHTHTY\archive"
#log_buffer = 65536
#log_checkpoint_interval = 10000
#log_checkpoint_timeout = 1800initMyHHTHTY.ora如下:
background_dump_dest = D:\Oracle\admin\HHTHTY\bdump
compatible = 8.1.0
control_files = "D:\Oracle\oradata\HHTHTY\control01.ctl"
control_files = "D:\Oracle\oradata\HHTHTY\control02.ctl"
control_files = "D:\Oracle\oradata\HHTHTY\control03.ctl"
db_block_buffers = 2048
db_block_size = 8192
db_file_multiblock_read_count = 8
db_files = 1024
db_name = HHTHTY
distributed_transactions = 10
global_names = TRUE
instance_name = HHTHTY
java_pool_size = 20971520
job_queue_interval = 60
job_queue_processes = 4
large_pool_size = 614400
#log_archive_dest_1 = "LOCATION=D:\Oracle\oradata\HHTHTY\archive"
#log_buffer = 65536
#log_checkpoint_interval = 10000
#log_checkpoint_timeout = 1800
max_dump_file_size = 10240
max_enabled_roles = 30
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
open_cursors = 100
open_links = 4
oracle_trace_collection_name = ""
os_authent_prefix = ""
parallel_max_servers = 5
processes = 115
remote_login_passwordfile = EXCLUSIVE
service_names = HHTHTY
shared_pool_size = 52428800
sort_area_retained_size = 65536
sort_area_size = 65536
timed_statistics = true
user_dump_dest = D:\Oracle\admin\HHTHTY\udump