配置归档日志双路径
来源:互联网 发布:手机吓人软件大全 编辑:程序博客网 时间:2024/06/05 02:40
今天想改一下归档路径,配置成双路径备份归档日志,但是配置的时候,除了一点小问题
SQL> alter system set log_archive_dest_1='LOCATION=/oracle10/product/10.2/dbs/arch/';
alter system set log_archive_dest_1='LOCATION=/oracle10/product/10.2/dbs/arch/'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST
SQL>
在选择第二个归档路径log_archive_dest_1时报错,查看归档参数:
SQL> show parameter arch_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string /dsg/oracle10/cxf/DBF
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string /dsg/oracle10/cxf/DBF
SQL>
把默认归档log_archive_dest删掉:
SQL> alter system set log_archive_dest=" ";
System altered.
SQL>
SQL> show parameter arch_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string /dsg/oracle10/cxf/DBF
SQL>
SQL> alter system set log_archive_dest_1='LOCATION=/oracle10/product/10.2/dbs/arch';
System altered.
SQL> alter system set log_archive_dest_2='LOCATION=/dsg/oracle10/cxf/DBF';
System altered.
SQL>
SQL> show parameter arch_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=/oracle10/product/10.2/dbs/arch
log_archive_dest_10 string
log_archive_dest_2 string LOCATION=/dsg/oracle10/cxf/DBF
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string /dsg/oracle10/cxf/DBF
SQL>
- 配置归档日志双路径
- 归档 及 日志 路径
- 更改归档日志路径
- 归档日志路径
- 开启归档 修改归档日志路径
- 开启归档 修改归档日志路径
- oracle归档日志配置查询
- 归档路径丢失后,归档日志写进了哪里
- ORACLE 开启归档日志及更改归档路径
- 查看oracle归档日志路径1
- 查看oracle归档日志路径2
- oracle 归档日志文件路径设置
- 更改rac oracle归档日志路径
- 查看oracle归档日志路径1
- RMAN 配置归档日志删除策略
- RMAN 配置归档日志删除策略
- log4j 日志路径配置
- log4j 日志路径配置
- what is the difference between jpa and hibernate
- 定时发送短信之AlarmManage,SmsManger的使用
- What To Do When The Boss Begs You To Stay
- 省市县联动
- Eclipse maven工程 Missing artifact com.sun:tools:jar:1.6.0:system 解决方法
- 配置归档日志双路径
- java源码阅读
- Android EditText样式
- Uva 10047 The Monocycle
- [ACM]Let the Balloon Rise
- wireshark过滤使用
- Android的使用ViewPager简单实例【类似tab翻页】
- 谈谈Java的优点
- iOS学习笔记18—iOS应用本地化