控制文件与参数文件不同步和控制文件版本不一致导致数据库mount失败及其解决办法
来源:互联网 发布:java 多线程返回结果 编辑:程序博客网 时间:2024/05/22 06:48
1.参数文件与控制文件不同步(这里我们通过修改控制文件名字,模拟控制文件丢失,造成二者之间不同步)
[oracle@redhat ~]$ ls /u01/app/oracle/oradata/jiagulun/ //控制文件1位置
control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
[oracle@redhat ~]$
[oracle@redhat ~]$ ls /u01/app/oracle/flash_recovery_area/jiagulun/ //控制文件2位置
control02.ctl
[oracle@redhat ~]$
[oracle@redhat ~]$ ls /u01/app/oracle/product/11.2.0.1/db_1/dbs/ //参数文件位置
hc_DBUA0.dat initjiagulun.ora orapwjiagulun
hc_jiagulun.dat lkJIAGULUN spfilejiagulun.ora
[oracle@redhat ~]$
[oracle@redhat ~]$ cat /u01/app/oracle/product/11.2.0.1/db_1/dbs/initjiagulun.ora
processes = 150
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 440M //目前参数文件里,有2个控制文件,这里我们修改第1个
control_files = "/u01/app/oracle/oradata/jiagulun/control01.ctl"
control_files = "/u01/app/oracle/flash_recovery_area/jiagulun/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area"
db_recovery_file_dest_size= 3882M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=jiagulunXDB)"
audit_file_dest = "/u01/app/oracle/admin/jiagulun/adump"
audit_trail = "DB"
db_name = "jiagulun"
open_cursors
[oracle@redhat ~]$ ls /u01/app/oracle/oradata/jiagulun/
control01.ctl
example01.dbf
[oracle@redhat ~]$
[oracle@redhat ~]$ ls /u01/app/oracle/flash_recovery_area/jiagulun/
control02.ctl
[oracle@redhat ~]$
[oracle@redhat ~]$ ls /u01/app/oracle/product/11.2.0.1/db_1/dbs/
hc_DBUA0.dat
hc_jiagulun.dat
[oracle@redhat ~]$
[oracle@redhat ~]$ cat /u01/app/oracle/product/11.2.0.1/db_1/dbs/initjiagulun.ora
processes