1
Use operating system or hardware mirroring for the control file. All copies of the control file multiplexed at the database level must be available at all times, or the instance will crash. If you use operating system or hardware mirroring for your control file, your database can continue to operate even if one copy of the control
file mirrored at the operating system level is unavailable due to a disk failure.Damage to any control file, whether it is multiplexed or not, halts database operation when the database attempts to read or write to the damaged control file (which happens frequently, for example at every checkpoint and log switch).
我怎么觉得上面这两段话有点矛盾,当然,肯定没有矛盾,只是我自己没理解正确。请大家纠正一下。
第一句话后面说即使controlfile mirrored at the operating system level不可访问了,数据库仍然可以正常运行。
而第二句说不管控制文件是否有多份,只要一个失效了,那么数据库就停止了。
按我这么理解的话好像就有点不对了,我觉得可能是我对controlfile mirrored at the operating system level和control file multiplexed at the database level 这两个LEVEL没理解透彻,希望哪位可以讲讲。2
我在RMAN提示符下shutdown immediate了以后,SQL*PLUS中是以SYS登陆的,此时在SQL*PLUS中输入startup不成功,错误如下
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
而回到RMAN中startup是成功的
为什么呢?难不成因为在RMAN里优先权高?
Use operating system or hardware mirroring for the control file. All copies of the control file multiplexed at the database level must be available at all times, or the instance will crash. If you use operating system or hardware mirroring for your control file, your database can continue to operate even if one copy of the control
file mirrored at the operating system level is unavailable due to a disk failure.Damage to any control file, whether it is multiplexed or not, halts database operation when the database attempts to read or write to the damaged control file (which happens frequently, for example at every checkpoint and log switch).
我怎么觉得上面这两段话有点矛盾,当然,肯定没有矛盾,只是我自己没理解正确。请大家纠正一下。
第一句话后面说即使controlfile mirrored at the operating system level不可访问了,数据库仍然可以正常运行。
而第二句说不管控制文件是否有多份,只要一个失效了,那么数据库就停止了。
按我这么理解的话好像就有点不对了,我觉得可能是我对controlfile mirrored at the operating system level和control file multiplexed at the database level 这两个LEVEL没理解透彻,希望哪位可以讲讲。2
我在RMAN提示符下shutdown immediate了以后,SQL*PLUS中是以SYS登陆的,此时在SQL*PLUS中输入startup不成功,错误如下
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
而回到RMAN中startup是成功的
为什么呢?难不成因为在RMAN里优先权高?
解决方案 »
- linux下使用sqlldr导入数据该如何操作???谢谢鸟
- 如何提高查询速度:有个查询晚上运行只要1分钟,但白天要1个多小时(此时并发用户50多个)?
- oracle select min() into 问题
- 富有挑战的SQL,请大家来看一下绝对不后悔,同时可以挽救一个绝望中的人,谢谢了~~!
- 【请教】聚合函数与update
- ORACLE范围分区如何创建
- oracle817有没有一种用户能看到所有用户的procedure,job等?
- 如何查询表中一个字段包含几个数据的内容
- sos:oracle 8 ora-01562 等错误,请指教.
- regexp_substr匹配字符串
- 帮解释下这个建表语句下面几个参数含义
- 建了一个Oracle10gKDD交流群,有意者加。
你退出sqlplus以后,然后再进来试试。
就是用操作系统去复制一份CONTROLFILE吗?这样的话数据库并不会往这个复制出来的控制文件写内容吧
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 19 00:16:31 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdba
Connected.
SQL> select * from dual;D
-
XSQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
退出再次登录进来
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 19 00:18:23 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> show user
USER is ""
SQL> conn / as sysdba
Connected to an idle instance.
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> startup
ORACLE instance started.Total System Global Area 176160768 bytes
Fixed Size 1247948 bytes
Variable Size 88081716 bytes
Database Buffers 83886080 bytes
Redo Buffers 2945024 bytes
Database mounted.
Database opened.
SQL>
我的理解是这样的,系统级的备份,就是单独备份而已,如果没有在启动参数把这个control加入到控制文件里,这个就是个普通的备份文件而已。
还是文档呗
backup and recovery basics
这个稍微短点 220多页
下个月各个公司的校园招聘就开始了 我得抓紧每个方面都了解了解
以前一直在学其他的
最近才发现对ORACLE很有兴趣
就开始学了