Oracle: 启用Oracle档案日志模式问题描述
如何启用Oracle档案日志模式？
配置信息
操作系统 - HP-UX
版本 - 10.20
硬件系统 - HP9000
系列 - K580
应用程序 - Oracle和OpenView IT/Operations (IT/O) 5.0
解决方法
按下面的步骤启用Oracle档案日志模式：
1. 关闭所有已打开的IT/O会话。
2. 终止ovw进程。
3. 关闭数据库。
4. 在“init.ora”文件中设置档案日志参数。
a. 取消对下面一行的注释，启动档案进程：
log_archive_start = true
b. 取消对下面一行的注释，指定档案目录：
log_archive_dest = //arch
注：提供相应的和值。
对于Oracle 8，记住在目录路径上附加一个向前的斜线(/)，例如：
//arch/
如果不附加斜线，Oracle将使用错误的档案日志目录名。
c. 取消对下面一行的注释，定义存档日志文件名：
log_archive_format = "T%TS%S.ARC"
5. 启动数据库，启用档案日志模式：
以用户“oracle:svrmgrl”身份输入下面的命令：
SVRMGRconnect internal
SVRMGRstartup mount
SVRMGRalter database archivelog
SVRMGRalter database open
SVRMGRexit
6. 关闭数据库。
7. 进行完全的脱机数据库备份，用作将来联机备份的基础。
.........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'.
SVRMGRconnect internal
SVRMGRstartup mount
SVRMGRalter database archivelog
SVRMGRalter database open
SVRMGRexit
6. Shutdown the database.
7. Perform a full off-line database backup to use as a foundation for future online backups.
