ORA-01147: SYSTEM tablespace file 1 is offline after RMAN recovery
830322Jan 31 2011 — edited Feb 3 2011Hi,
I have a valid backup of my database created via RMAN. I have been able to restore multiple times with no problem from the same backup set. Recently after a restore process, my database will not open anymore. All I get is the below error. I don't think its possible to bring a tablespace online unless the database is started, but as you all probably know, you can't start the database without the system tablespace. How do I fix this?
I am in a 3 node Oracle RAC 11.2.0.2.0 on AIX, all of my datafiles are managed via ASM.
bash-3.00$ srvctl start db -d vwdb
PRCR-1079 : Failed to start resource ora.vwdb.db
CRS-5017: The resource action "ora.vwdb.db start" encountered the following error:
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '+DATAGRP/vwdb/datafile/system.271.740157237'
CRS-2674: Start of 'ora.vwdb.db' on 'hqpsiaix26' failed
CRS-2632: There are no more servers to try to place resource 'ora.vwdb.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.vwdb.db start" encountered the following error:
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '+DATAGRP/vwdb/datafile/system.271.740157237'
CRS-2674: Start of 'ora.vwdb.db' on 'hqpsiaix19' failed
CRS-5017: The resource action "ora.vwdb.db start" encountered the following error:
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: '+DATAGRP/vwdb/datafile/system.271.740157237'
CRS-2674: Start of 'ora.vwdb.db' on 'hqpsiaix28' failed
bash-3.00$