| ALTER TABLESPACE TABLESPACE_NAME COALESCE
注意:如果TABLESPACE的值為100就沒有必要作此命令.
9. 移動TABLE INDEX 到另一個TABLESPACE
1> SPOOL C:\MV_INDEX.SQL
2> SELECT ‘ALTER INDEX ‘||TRIM(OBJECT_NAME)||’ REBUILD TABLESPACE FOXMOLD1;’ FROM USER_OBJECTS WHERE OBJECT_TYPE=’INDEX’
3> 將此命令生成MV_INDEX.SQL文件
4> @C:\MV_INDEX.SQL
10. MAINTAINING THE CONTROLFILE
1> SVRMGRL
2> CONNECT INTERNAL
3> SHUTDOWN
4> EXIT
5> CP /U/PRODUCT/ORADATA/FOXMOLD/CONTROL01.CTL
/DB4/ORADATA/CONTROL01.CTL
6> CHMOD 660 /DB4/ORADATA/CONTROL01.CTL
7> 修改INIT.ORA CONTROL_FILES=……
8> STARTUP MOUNT FOXMOLD
11. MAINTAINING REDO LOG FILE
1> SHUTDOWN
2> EXIT
3> CP /DISK1/*.RDO /DISK4/*.RDO
4> CHMOD 660 /DISK4/*.RDO
5> STARTUP MOUNT FOXMOLD
12. RECOVER SYNTAX
A. RECOVER A CLOSED DATABASE
1> RECOVER DATABASE
2> RECOVER DATAFILE ‘/DISK1/DF2.DBF’
3> ALTER DATABASE RECOVER DATABASE
B. RECOVER AN OPEN DATABASE
1> RECOVER TABLESPACE USER_DATA
2> RECOVER DATAFILE 2
3> ALTER DATABASE RECOVER DATAFILE 2 注意﹕ALTER DATABASE一定在RECOVER后執行。
上一页 [1] [2] [3] | 
