Re: 오늘의 마지막 문제. 오라클 리두 로그 그룹의 멤버를 4개로 만들어주세요.

[21기_이풍혁]

1. create control file.sql 생성

alter database backup controlfile to trace as '/u01/app/oracle/fast_recovery_area/ORCL19/controlbak/controlfile_2509241646.sql' reuse;

2. vim으로 create control sql 파일 일부 별도 파일로 저장

3. db 인스턴스 shutdown

SYS@orcl19> shutdown immediate;

4. 편집 저장한 sql 파일 실행

SYS@orcl19> @init_controlfile_2509241648

5. 로그파일 그룹 멤버추가

alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo01_2.log' to group 1;
alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo01_1.log' to group 1;

alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo02_2.log' to group 2;
alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo02_1.log' to group 2;

alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo03_2.log' to group 3;
alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo03_1.log' to group 3;

alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo04_2.log' to group 4;
alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo04_1.log' to group 4;

alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo05_2.log' to group 5;
alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL19/redo05_1.log' to group 5;

6. 확인

select * from v$logfile order by group#, member;