故障现象:
为了查看硬盘的型号,系统工程师对AIX小机进行了关机,重启后系统工程师lsdev -Cc disk查看硬盘状态OK了,告知系统已经恢复。
可ORACLE启动报错,提示控制文件损坏。
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.2885E+10 bytes
Fixed Size 2106024 bytes
Variable Size 6006246744 bytes
Database Buffers 6861881344 bytes
Redo Buffers 14667776 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL>
因为之前数据库服务是正常SHUTDOWN的,便怀疑文件系统存在问题,用df -g查看发现/oradata不见了,
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 10.00 8.00 21% 2182 1% /
/dev/hd2 4.00 1.66 59% 50260 12% /usr
/dev/hd9var 1.00 0.33 67% 569 1% /var
/dev/hd3 10.00 5.49 46% 141887 10% /tmp
/dev/hd1 1.00 0.54 47% 874 1% /home
/proc – – – – – /proc
/dev/hd10opt 2.00 1.53 24% 7221 2% /opt
/dev/weblogiclv 10.00 9.47 6% 47 1% /weblogic
/dev/weblogic9lv 10.00 1.85 82% 93440 18% /weblogic9
/dev/tsmdb 7.50 2.92 62% 7918 2% /tsmdb
/dev/oraclelv 30.00 23.02 24% 30441 1% /home/oracle
/dev/archive_lv 100.00 53.33 47% 787 1% /archivelog
尝试MOUNT不成功
P560A:/#mount /oradata
mount: 0506-324 Cannot mount /dev/oradata_lv on /oradata: There is a request to a device or address that does not exist.
在看PV状态,VG没有ACTIVE
P560A:/#lspv
hdisk0 00c3ee9e3439bc67 rootvg active
hdisk1 00c3ee9e5033384d rootvg active
hdisk2 00c3ee9eae48cc48 datavg
hdisk3 00c3ee9eb6975c7e datavg
运行varyonvg后再看VG状态已经ACTIVE
P560A:/#varyonvg datavg
P560A:/#lspv
hdisk0 00c3ee9e3439bc67 rootvg active
hdisk1 00c3ee9e5033384d rootvg active
hdisk2 00c3ee9eae48cc48 datavg active
hdisk3 00c3ee9eb6975c7e datavg active
尝试MOUNT正常
P560A:/#mount /oradata
P560A:/#
在看df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 10.00 8.00 21% 2182 1% /
/dev/hd2 4.00 1.66 59% 50260 12% /usr
/dev/hd9var 1.00 0.33 67% 569 1% /var
/dev/hd3 10.00 5.49 46% 141887 10% /tmp
/dev/hd1 1.00 0.54 47% 874 1% /home
/proc – – – – – /proc
/dev/hd10opt 2.00 1.53 24% 7221 2% /opt
/dev/weblogiclv 10.00 9.47 6% 47 1% /weblogic
/dev/weblogic9lv 10.00 1.85 82% 93440 18% /weblogic9
/dev/tsmdb 7.50 2.92 62% 7918 2% /tsmdb
/dev/oraclelv 30.00 23.02 24% 30444 1% /home/oracle
/dev/archive_lv 100.00 53.33 47% 787 1% /archivelog
/dev/oradata_lv 400.00 47.62 89% 163 1% /oradata
P560A:/#
在启动数据库(DG)
SQL> alter database mount standby database;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL>