LOG_ARCHIVE_DEST 和 LOG_ARCHIVE_DEST_n
来源:互联网 发布:qq刷图软件 编辑:程序博客网 时间:2024/06/04 18:11
LOG_ARCHIVE_DEST 和 LOG_ARCHIVE_DEST_n 只能取其一。当LOG_ARCHIVE_DEST设置为非空的时候,那LOG_ARCHIVE_DEST_n就不起作用。反之,如果LOG_ARCHIVE_DEST没有设置,则LOG_ARCHIVE_DEST_n的设置才能生效。如果两类参数均未设定,则系统在启动之后启用缺省值
归档日志不能直接归档到磁带或者裸设备上。
LOG_ARCHIVE_DEST is applicable only if you are running the database in ARCHIVELOG mode or are recovering a database from archived redo logs. LOG_ARCHIVE_DEST is incompatible with the LOG_ARCHIVE_DEST_n parameters, and must be defined as the null string ("") or (' ') when any LOG_ARCHIVE_DEST_n parameter has a value other than a null string. Use a text string to specify the default location and root of the disk file or tape device when archiving redo log files. (Archiving to tape is not supported on all operating systems.) The value cannot be a raw partition.
If LOG_ARCHIVE_DEST is not explicitly defined and all the LOG_ARCHIVE_DEST_n parameters have null string values, LOG_ARCHIVE_DEST is set to an operating system-specific default value on instance startup.
To override the destination that this parameter specifies, either specify a different destination for manual archiving or use the SQL*Plus statement ARCHIVE LOG START filespec for automatic archiving, where filespec is the new archive destination. To permanently change the destination, use the statement ALTER SYSTEM SET LOG_ARCHIVE_DEST = filespec, where filespec is the new archive destination.
Neither LOG_ARCHIVE_DEST nor LOG_ARCHIVE_FORMAT have to be complete file or directory specifiers themselves; they only need to form a valid file path after the variables are substituted into LOG_ARCHIVE_FORMAT and the two parameters are concatenated together.
归档日志不能直接归档到磁带或者裸设备上。
LOG_ARCHIVE_DEST is applicable only if you are running the database in ARCHIVELOG mode or are recovering a database from archived redo logs. LOG_ARCHIVE_DEST is incompatible with the LOG_ARCHIVE_DEST_n parameters, and must be defined as the null string ("") or (' ') when any LOG_ARCHIVE_DEST_n parameter has a value other than a null string. Use a text string to specify the default location and root of the disk file or tape device when archiving redo log files. (Archiving to tape is not supported on all operating systems.) The value cannot be a raw partition.
If LOG_ARCHIVE_DEST is not explicitly defined and all the LOG_ARCHIVE_DEST_n parameters have null string values, LOG_ARCHIVE_DEST is set to an operating system-specific default value on instance startup.
To override the destination that this parameter specifies, either specify a different destination for manual archiving or use the SQL*Plus statement ARCHIVE LOG START filespec for automatic archiving, where filespec is the new archive destination. To permanently change the destination, use the statement ALTER SYSTEM SET LOG_ARCHIVE_DEST = filespec, where filespec is the new archive destination.
Neither LOG_ARCHIVE_DEST nor LOG_ARCHIVE_FORMAT have to be complete file or directory specifiers themselves; they only need to form a valid file path after the variables are substituted into LOG_ARCHIVE_FORMAT and the two parameters are concatenated together.
- LOG_ARCHIVE_DEST 和 LOG_ARCHIVE_DEST_n
- log_archive_dest_n 和log_archive_dest和 log_archive_duplex_dest
- log_archive_dest&log_archive_dest_n&db_recovery_file_dest
- log_archive_dest与log_archive_dest_n区别
- log_archive_dest与log_archive_dest_n区别
- log_archive_dest与log_archive_dest_n区别
- 参数db_recovery_file_dest,log_archive_dest,log_archive_dest_n
- db_recovery_file_dest与log_archive_dest、log_archive_dest_n
- db_recovery_file_dest与log_archive_dest、log_archive_dest_n
- 归档日志路径三个参数DB_RECOVERY_FILE_DEST和LOG_ARCHIVE_DEST和LOG_ARCHIVE_DEST_n
- 归档日志路径三个参数DB_RECOVERY_FILE_DEST和LOG_ARCHIVE_DEST和LOG_ARCHIVE_DEST_n
- 归档日志路径三个参数DB_RECOVERY_FILE_DEST和LOG_ARCHIVE_DEST和LOG_ARCHIVE_DEST_n
- 详解LOG_ARCHIVE_DEST与log_archive_dest_n区别
- 归档日志路径三个参数DB_RECOVERY_FILE_DEST和LOG_ARCHIVE_DEST和LOG_ARCHIVE_DEST_n 2012-06
- LOG_ARCHIVE_DEST与log_archive_dest_n区别---Oracle基础
- Oracle10g自动归档(archive)及其路径设置(log_archive_dest、log_archive_dest_n)
- standby_archive_dest和log_archive_dest_n区别
- log_archive_dest_n和standby_archive_dest
- 揭秘排毒妙法瘦身减肚腩
- 营养偏差当心被恶性肿瘤钻空子
- Ruby on rails开发从头来(windows)(六)-美化你的列表页面(修正原版错误)
- vs1003的linux驱动调试
- 浏览器窗口关闭事件
- LOG_ARCHIVE_DEST 和 LOG_ARCHIVE_DEST_n
- 绝对有用的二十条使用电脑的超级技巧
- Samba的三种典型配置
- HIbernate缓存机制
- 各数据类型取值范围介绍
- 六级单词天天记(11.10)
- Samba的简介
- 程序员的感慨!
- 一个上下左右都居中的非table的纯CSS实现代码