搜了下资料,不同版本日志初始化的时机不一样10.1/9.7 When allocated1、The database is created2、A log is moved to a different location (which occurs when the newlogpath parameter is updated)3、When the database is next started following an increase in th...
你的计算方法没有问题,而且你的 LOGSECOND 不算大,如果目前的参数还导致空间不够的话,如果在不能增加空间的情况下,只能把LOGPRIMARY 或者 LOGFILSIZ 设置小一些 。
你同事的情况是有indoubt transaction所以可以情况略有不同但本质是一样的
1.>> 归档日志和活动日志的区别?顾名思义:"archive log" means no long actively being used by db and therefore archived somewhere for future use"active log" means currently still actively being used by db>> 我的理解是 事物没提交的时候,是在活动日志。事物一旦...