给当前 redo 增加一组新的 redo group

来源：互联网发布：3d播放软件编辑：程序博客网时间：2024/05/19 01:13

SQL> desc v$logfile;

名称是否为空? 类型

------------------------------------------------- ----------------------------

GROUP# NUMBER

STATUS VARCHAR2(7)

TYPE VARCHAR2(7)

MEMBER VARCHAR2(513)

IS_RECOVERY_DEST_FILE VARCHAR2(3)

SQL>col member for a50;

SQL> select group#,member from v$logfile;--查看重做文件序号及文件位置

GROUP# MEMBER

------------------------------------------------------------

3D:\APP\RACHEL\ORADATA\ORCL\REDO03.LOG

2D:\APP\RACHEL\ORADATA\ORCL\REDO02.LOG

1D:\APP\RACHEL\ORADATA\ORCL\REDO01.LOG

SQL> alter database add logfile group 4'D:\APP\RACHEL\ORADATA\ORCL\REDO04.LOG'

size 5m; --添加一组日志文件

数据库已更改。

SQL> select group#,member from v$logfile;

GROUP# MEMBER

------------------------------------------------------------

3D:\APP\RACHEL\ORADATA\ORCL\REDO03.LOG

2D:\APP\RACHEL\ORADATA\ORCL\REDO02.LOG

1 D:\APP\RACHEL\ORADATA\ORCL\REDO01.LOG

4D:\APP\RACHEL\ORADATA\ORCL\REDO04.LOG

SQL> alter database clear logfile group 4; --删除日志文件4

数据库已更改。

SQL> select group#,status from v$log; --查看redo日志状态

GROUP# STATUS

--------------------------

1 INACTIVE

2 INACTIVE

3 CURRENT

4 UNUSED

--EOF--

0 0