Re: 오늘의 마지막 문제2. data file 중에서 asm 에 남아있던 파일들 전부 /home/oracle밑으로 이동시키오

[21_장호철]

SQL> @tablespace

TABLESPACE FILE_NAME
---------- -------------------------------------------------------
USERS      /home/oracle/users01.dbf
UNDOTBS1   /home/oracle/undotbs01.dbf
SYSAUX     +DATA/orcl/datafile/sysaux.257.796857623
SYSTEM     /home/oracle/system01.dbf
EXAMPLE    +DATA/orcl/datafile/example.265.796857803
TS01       /home/oracle/ts01.dbf
TS02       +DATA/orcl/datafile/ts02.268.1212062945

7 rows selected.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[orcl:~]$
[orcl:~]$
[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/controlfile/current.260.796857737 /home/oracle/control01.ctl
copying +DATA/orcl/controlfile/current.260.796857737 -> /home/oracle/control01.ctl
ASMCMD> cp +FRA/orcl/controlfile/current.256.796857739 /home/oracle/control02.ctl
copying +FRA/orcl/controlfile/current.256.796857739 -> /home/oracle/control02.ctl
ASMCMD> exit
[+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 17:36:21 2025

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.


SQL> startup mount
ORACLE instance started.

Total System Global Area  481259520 bytes
Fixed Size                  1337352 bytes
Variable Size             310380536 bytes
Database Buffers          163577856 bytes
Redo Buffers                5963776 bytes
Database mounted.

SQL> alter database rename file '+DATA/orcl/datafile/sysaux.257.796857623' to
    '/home/oracle/sysaux01.dbf';

Database altered.

SQL> alter database rename file '+DATA/orcl/datafile/example.265.796857803' to
    '/home/oracle/example01.dbf';

Database altered.

SQL> alter database rename file '+DATA/orcl/datafile/ts02.268.1212062945' TO
    '/home/oracle/ts02.dbf';

Database altered.

SQL> alter database open;

Database altered.

SQL> @tablespace

TABLESPACE FILE_NAME
---------- -------------------------------------------------------
USERS      /home/oracle/users01.dbf
UNDOTBS1   /home/oracle/undotbs01.dbf
SYSAUX     /home/oracle/sysaux01.dbf
SYSTEM     /home/oracle/system01.dbf
EXAMPLE    /home/oracle/example01.dbf
TS01       /home/oracle/ts01.dbf
TS02       /home/oracle/ts02.dbf

7 rows selected.

SQL>