為了查看硬盤的型號,系統工程師對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>