linux改变数据库的权限,一次修改权限导致数据库崩溃的处理

环境描述:操作系统为AIX5.3,数据库版本为:oracle10.2.0.4

问题描述:数据库关闭状态下重新创建了ORACLE用户,导致数据文件,/home/oracle等等的一些原为oracle的文件变为了204用户的文件以及目录(204为以前ORACLE用户的ID号);后重新启动数据库,正常.为了使文件的属主变回现在的ORACLE用户所有，在数据库打开的状态下改变文件属主.后来数据库down掉,重新startup,问题出现:

-...................................................................

ORA-00321: log 5 of thread 1, cannot update log file header

ORA-00312: online log 5 thread 1: '/dev/rorcl_g5_m2_127'

查看数据库启动的状态:

SQL> select status from v$instance;

STATUS

------------

MOUNTED

确认日志组:

SQL> select group#,member from v$logfile;

GROUP#

----------

MEMBER

--------------------------------------------------------------------------------

...........................................

此处有日志组5,6的日志损坏,清除日志:

SQL>alter database clear unarchived logfile group 5;

ORA-00321: log 5 of thread 1, cannot update log file header

ORA-00312: online log 5 thread 1: '/dev/rorcl_g5_m2_127'

ORA-27091: unable to queue I/O

ORA-27041: unable to open file

SQL>alter database clear unarchived logfile group 6;

ORA-00321: log 6 of thread 1, cannot update log file header

ORA-00312: online log 6 thread 1: '/dev/rorcl_g6_m1_127'

ORA-27091: unable to queue I/O

ORA-27041: unable to open file

删除日志组:

SQL>alter database drop logfile group 5;

成功

SQL>alter database drop logfile group 6;

成功

打开数据库:

SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL>