- 查询Oracle的归档信息,如果不是归档模式则修改为归档模式
archive log list
- 设置两个归档路径,一个在D盘,一个在E盘
alter system set log_archive_dest_1='location=D:\Oracletest';
alter system set log_archive_dest_2='location=E:\';
- 创建一个重做日志文件组,文件存放:D:\Oracletest
查询已有日志组:
select group#,sequence#,members,status from v$log;
添加新的日志组:
alter database add logfile ('D:\Oracletest\redo04a.log') size 10m;
查询现有日志组:
select group#,sequence#,members,status from v$log;
- 为第二个重做日志文件组添加成员redo02b.log
alter database add logfile member 'D:\app\Snakewood\oradata\orcl\redo02b.log' to group 2;
- 将current状态的重做日志文件移动到D:\Oracletest
查询日志组状态:
select group#, sequence#, members, status from v$log;
alter database rename file'D:\app\Snakewood\oradata\orcl\redo01.log' to 'D:\Oracletest\redo01.log';
关闭并重启数据库
查询修改结果:
select * from v$logfile;