Received the error while starting the database service.
[oracle@host01 (tstdbp1) ~]$ srvctl start service -d tstdbp -s tstdb_haWhen I had a look at clusterware resources I could see what was happening
PRCD-1084 : Failed to start service tstdb_ha
PRCR-1079 : Failed to start resource ora.tstdbp.tstdb_ha.svc
CRS-2800: Cannot start resource 'ora.tstdbp.db' as it is already in the INTERMEDIATE state on server 'host02'
CRS-2632: There are no more servers to try to place resource 'ora.tstdbp.tstdb_ha.svc' on that would satisfy its placement policy
CRS-2800: Cannot start resource 'ora.tstdbp.db' as it is already in the INTERMEDIATE state on server 'host01'
[oracle@host01 (tstdbp1) ~]$
[grid@host01 ~]$ crsctl stat res -tLooks like the archiver is stuck and alert log explains it.
ora.tstdbp.db
1 ONLINE INTERMEDIATE host01 Stuck Archiver,STABLE
2 ONLINE INTERMEDIATE host02 Stuck Archiver,STABLE
ora.tstdbp.tstdb_ha.svc
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE STABLE
alert log says
ORA-19815: WARNING: db_recovery_file_dest_size of 21474836480 bytes is 100.00% used, and has 0 remaining bytes available.
added a bit of space and then ran a full backup to clear the archive logs.
You can look at show all under RMAN to see what will work for you.
2 comments:
Thanks Bro. the same error i could also faced. after purging the archives from FRA, the services automatically begins.
Thanks a lot. I got the same error and took me a bit to discover the db_recovery area filled up. In my case it was filled up till 99.76% so database is up and running but the service would not start. After increasing the dest_size, it resolved immediately.
Best Regards
Post a Comment