Tuesday, June 16, 2015

RAC One Failed because archivelog is full


$ srvctl start database -d RACTST
PRCR-1079 : Failed to start resource ora.ractst.db
CRS-5017: The resource action "ora.ractst.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 3208
Session ID: 577 Serial number: 1
. For details refer to "(:CLSN00107:)" in "/u01/11.2.0/grid/log/gw6/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.ractst.db' on 'gw6' failed
CRS-5017: The resource action "ora.ractst.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 3200
Session ID: 253 Serial number: 1
. For details refer to "(:CLSN00107:)" in "/u01/11.2.0/grid/log/gw8/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.ractst.db' on 'sun08' failed
CRS-2632: There are no more servers to try to place resource 'ora.ractst.db' on that would satisfy its placement policy


Trouble Shooting
$ srvctl start database -d RACTST -o mount

$ rman target sys/********@scan-name:1521/RACTST
RMAN> list archivelog all;
RMAN> delete archivelog all;

$ srvctl stop database -d RACTST
$ srvctl start database -d RACTST

No comments:

Post a Comment