婓Oracle杅擂踱笢痄雄杅擂恅璃腔撿极源楊

▽?舜厙ㄜIT撮扲惆耋▼珨.痄雄杅擂恅璃ㄩ

每 褫眕蚚ALTER DATABASEㄛALTER TABLESPACE謗笱源楊痄雄杅擂恅璃﹝

1. ALTER DATABASE源楊˙

每 蚚森源楊ㄛ褫眕痄雄?睡桶諾潔腔杅擂恅璃﹝

↑STEP 1. 狟杅擂踱ㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> SHUTDOWN;

SQL> EXIT;

↑STEP 2.蚚紱釬炵苀韜鍔痄雄杅擂恅璃ㄩ

每 蔚杅擂恅璃 ＆test.ora＊ 植/ora/oracle/data1醴翹痄雄善/ora/oracle/data2醴翹狟ㄩ

$ mv /ora/oracle/data1/test.ora /ora/oracle/data2

↑STEP 3. Mount杅擂踱ㄛ蚚ALTER DATABASE韜鍔蔚杅擂恅璃蜊靡ㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE RENAME FILE ＆/ora/oracle/data1/test.ora＊ TO ＆/ora/oracle/data2/test.ora＊;

↑STEP 4. 湖羲杅擂踱ㄩ.

SQL> ALTER DATABASE OPEN;

SQL>SELECT NAME,STATUS FROM V$DATAFILE˙

2. ALTER TABLESPACE源楊ㄩ

每 蚚森源楊ㄛ猁?森杅擂恅璃暫祥扽衾SYSTEM桶諾潔ㄛ珩祥扽衾漪衄ACTIVE隙幗僇麼還奀僇腔桶諾潔﹝

↑STEP1. 蔚森杅擂恅璃垀婓腔桶諾潔OFFLINEㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> ALTER TABLESPACE test OFFLINE;

SQL> EXIT;

↑STEP2. 蚚紱釬炵苀韜鍔痄雄杅擂恅璃ㄩ

蔚杅擂恅璃 ＆test.ora＊ 植/ora/oracle/

data1醴翹痄雄善/ora/oracle/data2醴翹狟ㄩ

$ mv /ora/oracle/data1/test.ora /ora/oracle/data2

↑STEP3. 蚚ALTER TABLESPACE韜鍔蜊杅擂恅璃靡ㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> ALTER TABLESPACE test RENAME DATAFILE ＆/ora/oracle/data1/test.ora＊ TO ＆/ora/oracle/data2/test.ora＊;

↑STEP4. 蔚森杅擂恅璃垀婓腔桶諾潔ONLINEㄩ

SQL> ALTER TABLESPACE test ONLINE;

SQL> SELECT NAME,STATUS FROM V$DATAFILE˙

媼. 痄雄諷秶恅璃ㄩ

每 諷秶恅璃 婓 INIT.ORA恅璃笢硌隅﹝痄雄諷秶恅璃眈勤掀誕潠等ㄛ狟杅擂踱ㄛ

每 晤憮INIT.ORAㄛ痄雄諷秶恅璃ㄛ笭?雄杅擂踱﹝

↑STEP 1. 狟杅擂踱ㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> SHUTDOWN;

SQL> EXIT;

↑STEP 2.蚚紱釬炵苀韜鍔 痄雄諷秶恅璃ㄩ

每蔚諷秶恅璃＊ctl3orcl.ora＊ 植/ora/oracle/data1醴翹痄雄善/ora/oracle/data2醴翹狟ㄩ

$ mv /ora/oracle/data1/ctrlorcl3.ora /ora/oracle/data2

↑STEP 3. 晤憮INIT.ORA恅璃ㄩ

INIT.ORA恅璃腔婓$ORACLE_HOME/dbs醴翹狟ㄛ

党蜊統杅 ※control_files§ㄛ?笢硌隅痄雄綴腔諷秶恅璃ㄩ

control_files = (/ora/oracle/data1/ctrlorcl1.ora,/ora/oracle/data1/ctrlorcl2.ora,/ora/oracle/data2/ctrlorcl3.ora)

↑STEP 4. 笭?雄杅擂踱ㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> STARTUP;

SQL>SELECT name FROM V$CONTROLFILE;

SQL> EXIT;

?. 痄雄薊儂?祩恅璃ㄩ

↑STEP 1. 礿杅擂踱ㄩ

$ sqlplus /nolog

SQL> CONNECT INTERNAL;

SQL> SHUTDOWN;

SQL> EXIT;

↑STEP 2. 蚚紱釬炵苀韜鍔痄雄薊儂?祩恅璃ㄩ

每蔚薊儂?祩恅璃＊redolog1.ora＊ 植/ora/oracle/data1醴翹痄雄善/ora/oracle/data2醴翹狟ㄩ

$ mv /ora/oracle/data1/redolog1.ora /ora/oracle/data2

↑STEP 3. Mount杅擂踱ㄛ蚚ALTER DATABASE 韜鍔蜊薊儂?祩恅璃靡ㄩ.

$ sqlplus /nolog

SQL> CONNECT INTERNAL;