|
復旧方法
下記手順を行うことにより、MSE サービスを起動することができます。
(1) MSE サービスの停止
[root@MSE ~]# /etc/init.d/msed stop
Stopping MSE Platform
Shutting down framework and services ...
Shutting down framework and services .................
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: nat filter [ OK ]
Unloading iptables modules: [ OK ]
(2) MSE サービス停止に伴い、Oracle も停止していることを確認
[root@MSE ~]# ps -ef | grep oracle
root 7998 4806 0 23:40 pts/1 00:00:00 grep oracle
(3) Oracle のみをスタート
[root@MSE ~]# oracleDBStartStop.sh start mseorcl mount
Starting Listener and Database for SID: mseorcl
Config files modified.
Wed Nov 20 23:41:29 JST 2013 Cleaning up any left over oracle shared memory and IPC semaphores
IPC Resources for ORACLE_SID "mseorcl" :
Shared Memory
ID KEY
No shared memory segments used
Semaphores:
ID KEY
:
Database mounted.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
SQL> Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
(4) "source /opt/mse/install/oracleenv" 実行
[root@MSE ~]# source /opt/mse/install/oracleenv
(5)su --command="sqlplus / as sysdba" oracle 実行
[root@MSE ~]# su --command="sqlplus / as sysdba" oracle
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 23:44:22 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
(6) SQL> プロンプトにて、Oracle のアーカイブログの出力先のサイズを上げる
SQL> alter system set db_recovery_file_dest_size=90G scope=both;
System altered.
(7) SQL> プロンプトから抜ける
SQL> quit;
(8) Oracle を停止
[root@MSE ~]# oracleDBStartStop.sh stop mseorcl
Stopping Listener and Database ...
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 23:54:56 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SQL> ORA-01109: database not open
:
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-NOV-2013 23:55:01
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MSE.cisco.com)(PORT=
1521)))
The command completed successfully
(9) MSE サービス起動
[root@MSE ~]# /etc/intit.d/msed start
Starting MSE Platform
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
Starting Health Monitor, Waiting to check the status.
Health Monitor successfully started
Starting Admin process...
Started Admin process.
Starting database ...
Database started successfully. Starting framework and services ..................
Framework and services successfully started
(10) Oracle アーカイブログの削除
[root@MSE ~]# sudo -u nobody /opt/mse/framework/bin/deleteArchiveLogs.sh `getdat
abaseparams` normal mseorcl
※改行は不要です
(11) Oracle アーカイブログが削除されていることを確認
[root@MSE ~]# more /opt/mse/logs/framework/archiveLogsDeletion_mseorcl.log
Thu Nov 21 01:02:01 JST 2013 : Invoking archive logs cleanup task
normal - mseorcl
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Nov 21 01:02:01 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: MSEORCL (DBID=3829940647)
RMAN>
using target database control file instead of recovery catalog
:
Recovery Manager complete.
Thu Nov 21 01:02:02 JST 2013 : Archivelog cleanup complete
ここのタイムスタンプが、(10)実行時の時刻になっていれば、Oracle アーカイブログは削除されていると判断できます。
恒久的な解決策
CSCue67286 の修正バージョンを使用することにより、この問題は発生しなくなります。
|
