1. datafile path 변경
1.1. database shutdown
gSQL> \connect as sysdba; gSQL> gSQL> \shutdown Shutdown success |
1.2. datafile의 이동
[sundb@cheroky db]$ ll 합계 389124 -rw-r--r--. 1 sundb sundb 14 2014-04-03 16:19 README -rw-rw-r--. 1 sundb sundb 209715200 2014-04-08 12:36 system_data.dbf -rw-rw-r--. 1 sundb sundb 134217728 2014-04-08 12:36 system_dict.dbf -rw-rw-r--. 1 sundb sundb 33554432 2014-04-08 12:36 system_undo.dbf -rw-rw-r--. 1 sundb sundb 10485760 2014-04-08 12:36 tbs_data_user_00.dbf -rw-rw-r--. 1 sundb sundb 10485760 2014-04-08 12:36 tbs_data_user_01.dbf [sundb@cheroky db]$ [sundb@cheroky db]$ [sundb@cheroky db]$ [sundb@cheroky db]$ mv tbs* ../db2/ [sundb@cheroky db]$ ll 합계 368644 -rw-r--r--. 1 sundb sundb 14 2014-04-03 16:19 README -rw-rw-r--. 1 sundb sundb 209715200 2014-04-08 12:36 system_data.dbf -rw-rw-r--. 1 sundb sundb 134217728 2014-04-08 12:36 system_dict.dbf -rw-rw-r--. 1 sundb sundb 33554432 2014-04-08 12:36 system_undo.dbf [sundb@cheroky db]$ [sundb@cheroky db]$ [sundb@cheroky db]$ cd .. [sundb@cheroky sundb_home]$ cd db2 [sundb@cheroky db2]$ ll 합계 20480 -rw-rw-r--. 1 sundb sundb 10485760 2014-04-08 12:36 tbs_data_user_00.dbf -rw-rw-r--. 1 sundb sundb 10485760 2014-04-08 12:36 tbs_data_user_01.dbf [sundb@cheroky db2]$ |
1.3. database startup mount
gSQL> \connect as sysdba; gSQL> gSQL> \startup mount; Startup success gSQL> gSQL> select * from x$datafile; TABLESPACE_ID PATH STATE DATAFILE_ID SIZE CREATION_TIME SHM_SEGMENT_ID SHM_STATE ------------- ---------------------------------------------- ------- ----------- --------- -------------------------- -------------- --------- 0 /home/sundb/sundb_home/db/system_dict.dbf CREATED 0 134209536 2014-04-08 00:16:32.828409 0 null 1 /home/sundb/sundb_home/db/system_undo.dbf CREATED 0 33546240 2014-04-08 00:16:33.525903 0 null 2 /home/sundb/sundb_home/db/system_data.dbf CREATED 0 209707008 2014-04-08 00:16:33.767216 0 null 3 system_temp CREATED 0 209707008 2014-04-08 03:48:00.354123 1 ALLOCATED 4 /home/sundb/sundb_home/db/tbs_data_user_00.dbf CREATED 0 10477568 2014-04-08 00:27:45.355213 0 null 4 /home/sundb/sundb_home/db/tbs_data_user_01.dbf CREATED 1 10477568 2014-04-08 00:28:13.686041 0 null 6 rows selected. gSQL> |
1.4. alter tablespace
gSQL> alter tablespace TBS_DATA_USER rename datafile '/home/sundb/sundb_home/db/tbs_data_user_00.dbf' to '/home/sundb/sundb_home/db2/tbs_data_user_00.dbf'; Tablespace altered. gSQL> select * from x$datafile; TABLESPACE_ID PATH STATE DATAFILE_ID SIZE CREATION_TIME SHM_SEGMENT_ID SHM_STATE ------------- ----------------------------------------------- ------- ----------- --------- -------------------------- -------------- --------- 0 /home/sundb/sundb_home/db/system_dict.dbf CREATED 0 134209536 2014-04-08 00:16:32.828409 0 null 1 /home/sundb/sundb_home/db/system_undo.dbf CREATED 0 33546240 2014-04-08 00:16:33.525903 0 null 2 /home/sundb/sundb_home/db/system_data.dbf CREATED 0 209707008 2014-04-08 00:16:33.767216 0 null 3 system_temp CREATED 0 209707008 2014-04-08 03:48:00.354123 1 ALLOCATED 4 /home/sundb/sundb_home/db2/tbs_data_user_00.dbf CREATED 0 10477568 2014-04-08 00:27:45.355213 0 null 4 /home/sundb/sundb_home/db/tbs_data_user_01.dbf CREATED 1 10477568 2014-04-08 00:28:13.686041 0 null 6 rows selected. |
1.5. database startup open
gSQL> alter system open database; System altered. gSQL> |
