SunCluster集群在用户导完数据后,不能正常启动。首先将该组托管,尝试手工单节点启动数据库,有如下错误信息:
Total System Global Area 2516582400 bytes
Fixed Size 1980744 bytes
Variable Size 570427064 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14794752 bytes
Database mounted.
ORA-16038: log 2 sequence# 83 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/database/ora10gdata/ora10g/redo02.log'
Fixed Size 1980744 bytes
Variable Size 570427064 bytes
Database Buffers 1929379840 bytes
Redo Buffers 14794752 bytes
Database mounted.
ORA-16038: log 2 sequence# 83 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/database/ora10gdata/ora10g/redo02.log'
从ORA-16038错误看,不能为归档模式
从ORA-19809错误看,恢复文件超过限制
查看原先的安装记录,数据库启用了归档模式,恢复文件目录为默认的2GB,与用户沟通后得知,原有数据库没启用归档模式,并可将恢复区调整为8GB。
1 禁用归档模式
$ sqlplus /nolog
SQL> startup mount;
SQL> alter database noarchivelog;
退出
2 更改pfile文件,增加恢复区空间
$ vi $ORACLE_HOME/dbs/initora10g.ora
#db_recovery_file_dest_size=2147483648
db_recovery_file_dest_size=8589934592
重新启动后服务正常!
by the way ,如果允许其它用户对Oracle有操作权限,最好将该用户加入Oracle用户属组,并chmod -R $ORACLE_HOME