ORACLE在HP-UX下的系列問(wèn)題處理(9)
2024-08-29 13:39:48
供稿：網(wǎng)友
Oracle: 啟用Oracle檔案日志模式問(wèn)題描述
如何啟用Oracle檔案日志模式？
配置信息
操作系統(tǒng) - HP-UX
版本 - 10.20
硬件系統(tǒng) - HP9000
系列 - K580
應(yīng)用程序 - Oracle和OpenView IT/Operations (IT/O) 5.0
解決方法
按下面的步驟啟用Oracle檔案日志模式：
1. 關(guān)閉所有已打開(kāi)的IT/O會(huì)話。
2. 終止ovw進(jìn)程。
3. 關(guān)閉數(shù)據(jù)庫(kù)。
4. 在“init.ora”文件中設(shè)置檔案日志參數(shù)。
a. 取消對(duì)下面一行的注釋?zhuān)瑔?dòng)檔案進(jìn)程：
log_archive_start = true
b. 取消對(duì)下面一行的注釋?zhuān)付n案目錄：
log_archive_dest = //arch
注：提供相應(yīng)的和值。
對(duì)于Oracle 8，記住在目錄路徑上附加一個(gè)向前的斜線(/)，例如：
//arch/
假如不附加斜線，Oracle將使用錯(cuò)誤的檔案日志目錄名。
c. 取消對(duì)下面一行的注釋?zhuān)x存檔日志文件名：
log_archive_format = "T%TS%S.ARC"
5. 啟動(dòng)數(shù)據(jù)庫(kù)，啟用檔案日志模式：
以用戶“oracle:svrmgrl”身份輸入下面的命令：
SVRMGR>connect internal
SVRMGR>startup mount
SVRMGR>alter database archivelog
SVRMGR>alter database open
SVRMGR>exit
6. 關(guān)閉數(shù)據(jù)庫(kù)。
7. 進(jìn)行完全的脫機(jī)數(shù)據(jù)庫(kù)備份，用作將來(lái)聯(lián)機(jī)備份的基礎(chǔ)。
.........following with all English text ....
PRoblem Description
How do I enable the Oracle archive-log mode?
Configuration Info
Operating System - HP-UX
Version - 10.20
Hardware System - HP9000
Series - K580
applications - Oracle and OpenView IT/Operations (IT/O) 5.0
Solution
Perform the following steps to enable the Oracle archive-log mode:
1. Close all open IT/O sessions.
2. Kill the ovw process.
3. Shutdown your database.
4. Set the archive log parameters in the 'init.ora' file:
a. Uncomment the following line to start the archive process:
log_archive_start = true
b. Uncomment the following line to specify the archive Directory:
log_archive_dest = //arch
Note: Supply the corresponding values for
and .
For Oracle 8, remember to append a forward slash (/) to the directory path. For example:
//arch/
If you do not append the slash, Oracle will use the wrong archive-log directory name.
c. Uncomment the following line to define the names of the
archived log files:
log_archive_format = "T%TS%S.ARC"
5. Start the database and enable archive-log mode:
Enter the following commands as user 'oracle:svrmgrl'.
SVRMGR>connect internal
SVRMGR>startup mount
SVRMGR>alter database archivelog
SVRMGR>alter database open
SVRMGR>exit
6. Shutdown the database.
7. Perform a full off-line database backup to use as a foundation for future online backups. right">（出處：清風(fēng)軟件下載學(xué)院）
