Re: 오늘의 마지막 문제_이수자 평가6번 문제

[22기_정민수]

--문제01) orcl쪽에 control file 을 다음과 같이 4개로 멀티플랙싱하시오
SHOW parameter control_files;
/*
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /u01/app/oracle/oradata/ORCL/control01.ctl
*/

SELECT name FROM v$controlfile;
/*
NAME
---------------------------------------------
/u01/app/oracle/oradata/ORCL/control01.ctl
*/

ALTER SYSTEM SET control_files  = 
'/u01/app/oracle/oradata/ORCL/control01.ctl',
'/u01/app/oracle/oradata/ORCL/control02.ctl',
'/u01/app/oracle/oradata/ORCL/control03.ctl',
'/u01/app/oracle/oradata/ORCL/control04.ctl' SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;


SH>
cp /u01/app/oracle/oradata/ORCL/control01.ctl /u01/app/oracle/oradata/ORCL/control02.ctl
cp /u01/app/oracle/oradata/ORCL/control01.ctl /u01/app/oracle/oradata/ORCL/control03.ctl
cp /u01/app/oracle/oradata/ORCL/control01.ctl /u01/app/oracle/oradata/ORCL/control04.ctl


sql>
startup
SELECT name FROM v$controlfile;

-- 문제02) orcltest 쪽에 controlfile 을 다음과 같이 3개로 멀티 플랙싱하시오 (testdb)
SHOW parameter control_files;
/*

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /u01/app/oracle/oradata/TESTDB/controlfile/control01.ctl
*/

SELECT name FROM v$controlfile;
/*
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/TESTDB/controlfile/control01.ctl
*/
SHOW parameter db_recovery
/*
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size           big integer 20G


/u01/app/oracle/fast_recovery_area/TESTDB/controlfile/control02.ctl
/u01/app/oracle/fast_recovery_area/TESTDB/controlfile/control03.ctl
*/

ALTER SYSTEM SET control_files  = 
'/u01/app/oracle/oradata/TESTDB/controlfile/control01.ctl',
'/u01/app/oracle/fast_recovery_area/TESTDB/controlfile/control02.ctl',
'/u01/app/oracle/fast_recovery_area/TESTDB/controlfile/control03.ctl' SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

SH>
cp /u01/app/oracle/oradata/TESTDB/controlfile/control01.ctl /u01/app/oracle/fast_recovery_area/TESTDB/controlfile/control02.ctl
cp /u01/app/oracle/oradata/TESTDB/controlfile/control01.ctl /u01/app/oracle/fast_recovery_area/TESTDB/controlfile/control03.ctl


sql>

startup

-- 검수

SELECT name FROM v$controlfile;