数据库安全模式 日志文件多工 控制文件多工 归档模式

1、处于归档模式。

2、日志文件多工。

3、控制文件多工。（可以不做 但需备份）

RAC中日志文件，不用多工用ASM管理就不用多工了。

单实例下日志文件必须多工，没有ASM去管理。

日志多工

SELECT * FROM v$logfile ORDER BY group#;

SQL> ALTER DATABASE ADD LOGFILE MEMBER '/u01/oracle/oradata/qbjmes/redo1.log' TO GROUP 1;

Database altered.

SQL> ALTER DATABASE ADD LOGFILE MEMBER '/u01/oracle/oradata/qbjmes/redo2.log' TO GROUP 2;

Database altered.

 ALTER DATABASE ADD LOGFILE MEMBER '/u01/oracle/oradata/qbjmes/redo3.log' TO GROUP 3;

控制文件多工

SQL> alter system set control_files='/u01/oracle/oradata/qbjmes/control01.ctl,/u01/oracle/oradata/qbjmes/control1.ctl,/u01/oracle/fast_recovery_area/qbjmes/control02.ctl,/u01/oracle/fast_recovery_area/qbjmes/control2.ctl' scope=spfile;

s ~]$ cp /u01/oracle/oradata/qbjmes/control01.ctl /u01/oracle/oradata/qbjmes/control1.ctl

[oracle@qbjmes ~]$ cp /u01/oracle/fast_recovery_area/qbjmes/control02.ctl /u01/oracle/fast_recovery_area/qbjmes/contr

shutdown immediate

startup

1、处于归档模式。

2、日志文件多工。

3、控制文件多工。（可以不做 但需备份）

RAC中日志文件，不用多工用ASM管理就不用多工了。

单实例下日志文件必须多工，没有ASM去管理。

日志多工

SELECT * FROM v$logfile ORDER BY group#;

SQL> ALTER DATABASE ADD LOGFILE MEMBER '/u01/oracle/oradata/qbjmes/redo1.log' TO GROUP 1;

Database altered.

SQL> ALTER DATABASE ADD LOGFILE MEMBER '/u01/oracle/oradata/qbjmes/redo2.log' TO GROUP 2;

Database altered.

 ALTER DATABASE ADD LOGFILE MEMBER '/u01/oracle/oradata/qbjmes/redo3.log' TO GROUP 3;

控制文件多工

SQL> alter system set control_files='/u01/oracle/oradata/qbjmes/control01.ctl,/u01/oracle/oradata/qbjmes/control1.ctl,/u01/oracle/fast_recovery_area/qbjmes/control02.ctl,/u01/oracle/fast_recovery_area/qbjmes/control2.ctl' scope=spfile;

s ~]$ cp /u01/oracle/oradata/qbjmes/control01.ctl /u01/oracle/oradata/qbjmes/control1.ctl

[oracle@qbjmes ~]$ cp /u01/oracle/fast_recovery_area/qbjmes/control02.ctl /u01/oracle/fast_recovery_area/qbjmes/contr

shutdown immediate

startup