ora.xxx.db resource missing on Oracle 11.2/Linux after RMAN recovery
518459Jun 10 2010 — edited Jun 11 2010Hello all,
I have Oracle 11gR2 running under RedHat Linux. The datafiles are stored under ASM. Oracle Grid is also installed on the machine.
I performed an RMAN backup and saved also the oratab file, the password file for ASM, the password file for my instance and the listener.ora and tnsnames.ora configuration files (the spfile and controlfile are backed up by RMAN's autobackup).
The RMAN procedure I use for restore is the following:
- drop the instance with "dbca -deleteDatabase -sourceDB ${ORACLE_SID}"
- creation of directories present for spfile parameters (for instance adump)
- copy of the config files above to their respective locations
- startup force nomount / recover the spfile from autobackup / shutdown;
- startup nomount / recover the controlfile from autobackup / shutdown;
- startup mount / restore/recover database / open db resetlogs.
The above operations are OK, but when I'm trying to stop/start the DB instance with srvctl start/stop database -db ${ORACLE_SID}, I get the error that the ora.${ORACLE_SID}.db resource is missing. The resource is indeed not displayed by crs_stat.
Where are the information about the Oracle resources stored? In the Oracle Local Registry? Should I have made a backup of OCR also?
Thank you,
Adrian