1. 查询logfile
select * from v$logfile;
select * from v$log;
2. 创建日志文件
alter database drop logfile group [group number] | filename | (filename, filename..)
e.g.
alter database drop logfile group 1;
select * from v$logfile;
select * from v$log;
2. 创建日志文件
- 增加日志组: alter database [db name] add logfile group [group number] filename|(filename,filename) size [intsize K|M] [reuse]; e.g. alter database add logfile group 4 ('c:\redo04a.log', 'c:\redo04b.log') size 10m;
- 添加日志文件到日志组: e.g. alter database add logfile member 'c:\redo04c.log' to group 4, 'c:\redo04d.log' to group 4;
alter database drop logfile group [group number] | filename | (filename, filename..)
e.g.
alter database drop logfile group 1;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10336955/viewspace-660213/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10336955/viewspace-660213/