原因如题
环境LINUX6,ORACLE11G,HA,JAVA应用(简化了一些信息)
Last login: Wed Mar 13 11:24:07 2013 from 175.152.33.179
[root@hnoracle2 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda5 48G 15G 31G 32% /
/dev/sda1 4.9G 49M 4.6G 2% /boot
none 2.0G 0 2.0G 0% /dev/shm
/dev/sdb1 1.6T 11G 1.5T 1% /oradata
[root@hnoracle2 ~]#
至此,从主复制冷备到备机,使之同步,问题解决。
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/dba/system01.dbf
/oradata/dba/undotbs01.dbf
/oradata/dba/sysaux01.dbf
/oradata/dba/users01.dbf
/oradata/dba/megaspace.db