ORACLE ARCHIVE LOG Mode 筆記

ORACLE DATABASE 切換到 Archive LOG 或 NO ARCHIVE LOG 模式必須關閉、重新啟動資料庫。

切換到ARCHIVE LOG 模式並不表示系統會自動執行 ARCHIVE LOG，必須下指令執行，如果希望一開機就自動執行必須在 spfile 中作設定。

切換到ARCHIVE LOG 模式後應立即作備份的動作，如果使用之前的備份回復資料，資料只能回復至 NOARCHIVE LOG Mode 時的狀況。

檢查是否為 Archive Log 模式
SQL>select archiver select * from v$log;
SQL>archive log list;

更改 ARCHIVE/NOARCHIVE LOG 模式步驟：
1.SQL>shutdown immediate
2.SQL>startup mount
3.SQL>alter database archivelog/noarchivelog;
4.SQL>alter database open;
5.backup full database and control file;

啟動 Archive LOG Mode
SQL>alter system archive log start/stop;

變更啟動 Parameter，讓資料庫一啟動就自動執行 ARCHIVE LOG
SQL>alter system set log_archive_start=true scope=spfile;
或是在 pfile 中加入 log_archive_start=true

查詢 ARCHIVE LOG 狀況
SQL>Archive Log List

其它一些相關的設定參數和查詢
SQL>show parameter log_archive_format
SQL>alter SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=3 scope=spfile sid='*';;
SQL>alter SYSTEM SET log_archive_dest_1 = "location=C:Oracleoradataoradbarchive" scope=spfile sid='*';
SQL>alter SYSTEM SET log_archive_format = %%ORACLE_SID%%T%TS%S.ARC scope=spfile sid='*';

Windows XP停用USB裝置自動播放功能

可以採用以下任一方法：

一、[開始]->[執行]->[在開啟欄中輸入 gpedit.msc]，然後，參考下圖，設定完成後，重新開機。

二、USB 裝置插入電腦時，一直按著「Shift」鍵，直到系統已經連結此裝置 (作業系統將不會執行 autorun.inf)。

三、修改登錄機碼

機碼名稱	名稱	資料值
HKEY_CURRENT_USER->Software->Microsoft->Windows->CurrentVersion->Policies->Explorer	NoDriveTypeAutoRun	0×00000095
HKEY_USERS->.DEFAULT->Software->Microsoft->Windows->CurrentVersion->Policies->Explorer	NoDriveTypeAutoRun	0×00000095

那些ORACLE 物件支援重新命名

物件	支援	說明
CLUSTER	X	-
CONSTRAINT	O	ALTER TABLE table_name RENAME CONSTRAINT old_name TO new_name
CONTROL FILE	o	Alter the control_files parameter using the ALTER SYSTEM comamnd. Shutdown the database. Rename the physical file on the OS. Start the database.
COLUMN	O	ALTER TABLE table_name RENAME COLUMN old_name TO new_name
DATAFILE	O	Shutdown the database. Rename the physical file on the OS. Start the database in mount mode. Issue the ALTER DATABASE RENAME FILE command to rename the file within the Oracle dictionary. Open the database.
DATABASE NAME	O	SQL>alter system switch logfile; SQL>alter database backup controlfile to trace; SQL>shutdown Modify (and optionally rename) the created trace file: create new controlfile modify db_name in init.ora SQL>STARTUP
FUNCTION	X	-
INDEX	O	ALTER INDEX old_name RENAME TO new_name;
INDEX PARTITION	O	ALTER INDEX index_name RENAME PARTITION ptn_name TO new_name
INDEX SUB PARTITION	O	ALTER INDEX index_name RENAME SUBPARTITION ptn_name TO new_name
INSTANCE	O	SQL>SHUTDOWN change ORACLE_SID (方法參考DATABASE NAME 更名) SQL>STARTUP
LOB	O	ALTER TABLE T MOVE LOB(lob_column) STORE AS newlogseg_name;
LOGFILE	X	Shutdown the database. Rename the physical file on the OS. Start the database in mount mode. Issue the ALTER DATABASE RENAME FILE command to rename the file within the Oracle dictionary. Open the database.
OUTLINE	O	ALTER OUTLINE old_name RENAME TO new_name
PACKAGE	X	-
PACKAGE BODY	X	-
PROCEDURE	X	-
SEQUENCE	O	RENAME oldseq_name TO newseq_name;
SYNONYM	X	-
SCHEMA	X	-
TABLE	O	RENAME old_table TO new_table;
TABLE PARTITION	O	ALTER TABLE table_name RENAME PARTITION ptn_name TO new_name;
TABLE SUB PARTITION	O	ALTER TABLE table_name RENAME SUBPARTITION ptn_name TO new_name
TRIGGER	O	ALTER TRIGGER old_name RENAME TO new_name
TABLESPACE	O	ALTER TABLESPACE old_name RENAME TO new_name [10g new]
VIEW	O	RENAME old_table TO new_table;