exit
SYS@ORCL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ORCL>!
[oracle@tyger ORCL]$ mv tyger1_01.dbf tyger1_01.dbf.bak
[oracle@tyger ORCL]$ mv tyger2_01.dbf tyger2_01.dbf.bak
[oracle@tyger ORCL]$ exit
exit
SYS@ORCL>startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 150996560 bytes
Database Buffers 130023424 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/u01/app/oracle/oradata/ORCL/tyger1_01.dbf'
SYS@ORCL>alter database datafile 6 offline;
Database altered.
SYS@ORCL>alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/app/oracle/oradata/ORCL/tyger2_01.dbf'
SYS@ORCL>alter database datafile 7 offline;
Database altered.
SYS@ORCL>alter database open;
Database altered.
SYS@ORCL>select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
-------------------- ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
TYGER1 ONLINE
TYGER2 ONLINE
8 rows selected.
SYS@ORCL>!
[oracle@tyger ORCL]$ mv tyger1_01.dbf.bak tyger1_01.dbf
[oracle@tyger ORCL]$ mv tyger2_01.dbf.bak ../tyger2_01.dbf
[oracle@tyger ORCL]$ cd ..
[oracle@tyger oradata]$ ls
ORCL tyger2_01.dbf
[oracle@tyger oradata]$ pwd
/u01/app/oracle/oradata
[oracle@tyger oradata]$ exit
exit
SYS@ORCL>alter tablespace tyger1 online;
Tablespace altered.
SYS@ORCL>alter tablespace tyger2 online;
alter tablespace tyger2 online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/app/oracle/oradata/ORCL/tyger2_01.dbf'
SYS@ORCL>alter database rename file '/u01/app/oracle/oradata/ORCL/tyger2_01.dbf' to '/u01/app/oracle/oradata/tyger2_01.dbf';
Database altered.
SYS@ORCL>alter tablespace tyger2 online;
Tablespace altered.
SYS@ORCL>conn tu1/tu1
Connected.
TU1@ORCL>select count(*) from tu1_t1;
COUNT(*)
----------
14
TU1@ORCL>conn tu2/tu2
Connected.
TU2@ORCL>select count(*) from tu2_t2;
COUNT(*)
----------
14