ORA-38500: USING CURRENT LOGFILE option not available without stand
来源:互联网 发布:北京java学费 编辑:程序博客网 时间:2024/05/22 20:06
今天执行下面语句报错(实时应用日志):
SQL> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
第 1 行出现错误:
ora-35800: USING CURRENT LOGFILE option not available without stand
这个错误说明,在standby库没有standby logfile,在maxmize pretection,maxmize availability中必须
要有standby logfile,为了避免数据的损失最少,maxmize performance 也最好创建standby logfile,考虑角色切换
primary库也要创建standby logfile,
standby logfile创建的要求, 与primary的redo logfile的大小相同,个数要至少多一个
SQL> shutdown immeidate;
SP2-0717: 非法的 SHUTDOWN 选项
SQL> shutdown immediate;
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/REDO03.LOG
D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/REDO02.LOG
D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/REDO01.LOG
SQL> alter database add standby logfile group 4 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/stdREDO01.LOG' size 50m;
数据库已更改。
SQL> alter database add standby logfile group 5 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/stdREDO02.LOG' size 50m;
数据库已更改。
SQL> alter database add standby logfile group 6 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/stdREDO03.LOG' size 50m;
数据库已更改。
SQL> alter database add standby logfile group 7 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCLDG1/stdREDO04.LOG' size 50m;
数据库已更改。
现在,再启用实时应用, 就ok了!!!
SQL> alter database recover managed standby database using current logfile disconnect from session;
数据库已更改。
- ORA-38500: USING CURRENT LOGFILE option not available without stand
- ORA-38500: USING CURRENT LOGFILE option not available without stand
- ORACLE dataguard 主备库延迟 using current logfile
- 使用using current logfile实现DG备库实时更新
- ORA-1034 ORACLE not available
- ORA-1034 ORACLE not available
- ora-01034:oracle not available
- ora-01034 oracle not available
- ORA-01034:oracle not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ora-01034:oracle not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- url参数和map之间的转换
- 新手必看初学51单片机几个不易掌握的概念
- 匈牙利命名法
- Google Maps Android API V2使用及问题解决
- HDOJ 1261
- ORA-38500: USING CURRENT LOGFILE option not available without stand
- 基于jQuery的弹出框(背景同时灰掉)【原创】
- 把数组排成最小的数
- android adb问题整理解决:The connection to adb is down和ADB server didn't ACK * failed to start daemon
- flex中调用webservice的两种方法
- 第十二章 Java IO
- poj1251(prim)
- Delphi程序自删除的几种方法
- 苹果电脑MAC 在Finder里面显示隐藏文件方法