1 [Oracle@www.linuxidc.com ~]$ ps -ef | grep $ORACLE_SID | grep lgwr
2 oracle 5140 1 0 Nov09 ? 00:00:12 ora_lgwr_mydb
在一个终端中执行命令,大家比较关心LGWR对文件的打开操作:
1 [Oracle@www.linuxidc.com ~]$ strace -p 5140 2>&1 | grep -i open
在sqlplus中执行以下语句,用于添加一组新的online redo log:
1 ALTER DATABASE ADD LOGFILE (‘/u02/oradata/mydb/redolog/group04/redo05a.log’,
2 ‘/u02/oradata/mydb/redolog/group04/redo05b.log’)
3 SIZE 50m;