[Oracle] Redo Log File 미러링

 

Redo Log File 미러링

 

1. Member 추가

  SYS> Select group#, members, bytes/1024/1024 M From v$log;

  SYS> Select member From v$logfile;

  SQL> Alter Database Add logfile member '/u01/app/oracle/oradata/orcl/redo01b.log' to group 1;

  SQL> Alter Database Add logfile member '/u01/app/oracle/oradata/orcl/redo02b.log' to group 2;

  SQL> Select member From v$logfile;

 

2. Group 추가

  SQL> Alter Database add logfile group 3

          ('/u01/app/oracle/oradata/orcl/redo03a.log', '/u01/app/oracle/oradata/orcl/redo03b.log')

          size 10M;

  SQL> Select group#, members, bytes/1024/1024 M From v$log;