[실습1] 오라클 grid 관련 프로세서들이 정상인지 확인합니다.
💡
grid 소프트웨어 = ASM 소프트웨어 + cluster 소프트웨어
[orcl:~]$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[+ASM:~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE edydr1p0
ora.FRA.dg ora....up.type ONLINE ONLINE edydr1p0
ora....ER.lsnr ora....er.type ONLINE ONLINE edydr1p0
ora.asm ora.asm.type ONLINE ONLINE edydr1p0
ora.cssd ora.cssd.type ONLINE ONLINE edydr1p0
ora.diskmon ora....on.type ONLINE ONLINE edydr1p0
ora.orcl.db ora....se.type ONLINE ONLINE edydr1p0[실습2] 오라클의 모든 grid 서비스를 내렸다 올리시오
[+ASM:~]$ crs_stop -all
Attempting to stop `ora.LISTENER.lsnr` on member `edydr1p0`
Attempting to stop `ora.diskmon` on member `edydr1p0`
Attempting to stop `ora.DATA.dg` on member `edydr1p0`
Attempting to stop `ora.FRA.dg` on member `edydr1p0`
Attempting to stop `ora.orcl.db` on member `edydr1p0`
Stop of `ora.LISTENER.lsnr` on member `edydr1p0` succeeded.
Stop of `ora.diskmon` on member `edydr1p0` succeeded.
Stop of `ora.orcl.db` on member `edydr1p0` succeeded.
CRS-0216: Could not stop resource 'ora.cssd'.
[+ASM:~]$ crs_start -all
Attempting to start `ora.diskmon` on member `edydr1p0`
Attempting to start `ora.LISTENER.lsnr` on member `edydr1p0`
Start of `ora.diskmon` on member `edydr1p0` succeeded.
Start of `ora.LISTENER.lsnr` on member `edydr1p0` succeeded.
Attempting to start `ora.orcl.db` on member `edydr1p0`[실습3] ASM 쪽 ts01 테이블스페이스의 데이터 파일을 파일 시스템으로 이동하시오
SQL> select tablespace_name, status
2 from dba_tablespaces;
TABLESPACE STATUS
---------- ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
TS01 ONLINE
7 rows selected.
SQL> alter tablespace ts01 offline;
Tablespace altered.
SQL> select tablespace_name, status
from dba_tablespaces;
TABLESPACE STATUS
---------- ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
TS01 OFFLINE
7 rows selected.
SQL> @tablespace
TABLESPACE FILE_NAME
---------- -------------------------------------------------------
USERS +DATA/orcl/datafile/users.259.796857625
UNDOTBS1 +DATA/orcl/datafile/undotbs1.258.796857625
SYSAUX +DATA/orcl/datafile/sysaux.257.796857623
SYSTEM +DATA/orcl/datafile/system.256.796857621
EXAMPLE +DATA/orcl/datafile/example.265.796857803
TS01 +DATA/orcl/datafile/ts01.267.1212075751
6 rows selected.
SQL> exit;
[orcl:~]$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[+ASM:~]$ asmcmd
ASMCMD>
ASMCMD> cp +DATA/orcl/datafile/ts01.267.1212075751 /home/oracle/ts01.dbf
copying +DATA/orcl/datafile/ts01.267.1212075751 -> /home/oracle/ts01.dbf
ASMCMD>
ASMCMD>
[+ASM:~]$ . oraenv
ORACLE_SID = [+ASM] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[orcl:~]$ sys
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 15:45:51 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> alter database rename file '+DATA/orcl/datafile/ts01.267.1212075751'
2 to '/home/oracle/ts01.dbf';
Database altered.
SQL> alter tablespace ts01 online;
Tablespace altered.
SQL> @tablespace
TABLESPACE FILE_NAME
---------- -------------------------------------------------------
USERS +DATA/orcl/datafile/users.259.796857625
UNDOTBS1 +DATA/orcl/datafile/undotbs1.258.796857625
SYSAUX +DATA/orcl/datafile/sysaux.257.796857623
SYSTEM +DATA/orcl/datafile/system.256.796857621
EXAMPLE +DATA/orcl/datafile/example.265.796857803
TS01 /home/oracle/ts01.dbf
6 rows selected.
SQL>문제1. ASM 쪽 users 테이블 스페이스의 datafile 을 /home/oracle 로 이동하시오
SQL> alter tablespace users offline;
Tablespace altered.
SQL> select tablespace_name, status from dba_tablespaces;
TABLESPACE STATUS
---------- ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS OFFLINE
EXAMPLE ONLINE
TS01 ONLINE
TS02 ONLINE
8 rows selected.
SQL> @tablespace
TABLESPACE FILE_NAME
---------- -------------------------------------------------------
USERS +DATA/orcl/datafile/users.259.796857625
UNDOTBS1 +DATA/orcl/datafile/undotbs1.258.796857625
SYSAUX +DATA/orcl/datafile/sysaux.257.796857623
SYSTEM +DATA/orcl/datafile/system.256.796857621
EXAMPLE +DATA/orcl/datafile/example.265.796857803
TS01 /home/oracle/ts01.dbf
TS02 +DATA/orcl/datafile/ts02.268.1212062921
7 rows selected.
SQL> exit;
[orcl:~]$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[+ASM:~]$ asmcmd
ASMCMD> cp +DATA/orcl/datafile/users.259.796857625 /home/oracle/users.dbf
copying +DATA/orcl/datafile/users.259.796857625 -> /home/oracle/users.dbf
SQL> alter database rename file '+DATA/orcl/datafile/users.259.796857625'
2 to '/home/oracle/users.dbf';
Database altered.
SQL> alter tablespace users online;
Tablespace altered.
SQL> @tablespace
TABLESPACE FILE_NAME
---------- -------------------------------------------------------
USERS /home/oracle/users.dbf
UNDOTBS1 +DATA/orcl/datafile/undotbs1.258.796857625
SYSAUX +DATA/orcl/datafile/sysaux.257.796857623
SYSTEM +DATA/orcl/datafile/system.256.796857621
EXAMPLE +DATA/orcl/datafile/example.265.796857803
TS01 /home/oracle/ts01.dbf
TS02 +DATA/orcl/datafile/ts02.268.1212062921
7 rows selected.
SQL> select tablespace_name, status
from dba_tablespaces;
2
TABLESPACE STATUS
---------- ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
TS01 ONLINE
TS02 ONLINE
8 rows selected.
SQL>