※ 필수 파일 
1. 닫힌 백업한 데이터 파일 전체
2. redo 로그 파일
3. control 파일
4. 열린 백업 파일 사용 불가
=======================================================================================


SQL> select file_name, file_id, tablespace_name, online_status from dba_data_files;

FILE_NAME                                        FILE_ID TABLESPACE_NAME      ONLINE_
--------------------------------------------- ---------- -------------------- -------
/oracle/oradata/ora10g/users01.dbf                     4 USERS                ONLINE
/oracle/oradata/ora10g/sysaux01.dbf                    3 SYSAUX               ONLINE
/oracle/oradata/ora10g/undotbs01.dbf                   2 UNDOTBS1             ONLINE
/oracle/oradata/ora10g/system01.dbf                    1 SYSTEM               SYSTEM
/oracle/oradata/ora10g/example01.dbf                   5 EXAMPLE              ONLINE

SQL> !rm -rf /oracle/oradata/ora10g

SQL> shutdown abort
ORACLE instance shut down.
SQL> !cp /backup/close/ora10g/* /oracle/oradata/imsy                          

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              83888372 bytes
Database Buffers           79691776 bytes
Redo Buffers                2973696 bytes
SQL> alter system set control_files
  2  ='/oracle/oradata/imsy/control01.ctl'
  3  ,'/oracle/oradata/imsy/control02.ctl'
  4  ,'/oracle/oradata/imsy/control03.ctl'
  5  scope = spfile;

System altered.

SQL> shutdown
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              83888372 bytes
Database Buffers           79691776 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> alter database rename file
  2  '/oracle/oradata/ora10g/users01.dbf' to
  3  '/oracle/oradata/imsy/users01.dbf';

Database altered.

SQL> alter database rename file
  2  '/oracle/oradata/ora10g/sysaux01.dbf' to
  3  '/oracle/oradata/imsy/sysaux01.dbf';

Database altered.

SQL> alter database rename file
  2  '/oracle/oradata/ora10g/undotbs01.dbf' to
  3  '/oracle/oradata/imsy/undotbs01.dbf';

Database altered.

SQL> alter database rename file
  2  '/oracle/oradata/ora10g/system01.dbf' to
  3  '/oracle/oradata/imsy/system01.dbf';

Database altered.

SQL> alter database rename file
  2  '/oracle/oradata/ora10g/example01.dbf' to
  3  '/oracle/oradata/imsy/example01.dbf';

Database altered.

SQL> col member format a40
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                    IS_
---------- ------- ------- ----------------------------------------  ---
         3         ONLINE  /oracle/oradata/ora10g/redo03.log          NO
         2         ONLINE  /oracle/oradata/ora10g/redo02.log          NO
         1         ONLINE  /oracle/oradata/ora10g/redo01.log          NO


SQL> alter database rename file
  2  '/oracle/oradata/ora10g/redo01.log' to
  3  '/oracle/oradata/imsy/redo01.log';

Database altered.

SQL> alter database rename file
  2  '/oracle/oradata/ora10g/redo02.log' to
  3  '/oracle/oradata/imsy/redo02.log';

Database altered.

SQL> alter database rename file
  2  '/oracle/oradata/ora10g/redo03.log' to
  3  '/oracle/oradata/imsy/redo03.log';

Database altered.

SQL> alter database open;

Database altered.

SQL> select name, status from v$datafile;

NAME                                     STATUS
---------------------------------------- -------
/oracle/oradata/imsy/system01.dbf        SYSTEM
/oracle/oradata/imsy/undotbs01.dbf       ONLINE
/oracle/oradata/imsy/sysaux01.dbf        ONLINE
/oracle/oradata/imsy/users01.dbf         ONLINE
/oracle/oradata/imsy/example01.dbf       ONLINE

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         3         ONLINE  /oracle/oradata/imsy/redo03.log          NO
         2         ONLINE  /oracle/oradata/imsy/redo02.log          NO
         1         ONLINE  /oracle/oradata/imsy/redo01.log          NO

SQL> !rm -rf /backup/archive1/*

SQL> !rm -rf /backup/archive2/* 

SQL>