Learning RMAN, requesting initfile during startup DB [message #516204] |
Fri, 15 July 2011 08:36 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
Im playing around using RMAN.
I dropped the database and removed the initfile and other files which where left efterwards.
Now I sat my environment and SID. I run SQLPLUS and type in: STARTUP.
Now the my new DB wants the old initfile during startup (the SID is the same as the old one).
Before the old DB said that I did not have a initfile and instead used a dummy initfile (when I started it the first time).
After that I could restore the spfile from backup.
Where can this information be stored? Anyone seen this before?
Regards
H
[Updated on: Fri, 15 July 2011 08:49] Report message to a moderator
|
|
|
|
|
Re: Learning RMAN, requesting initfile during startup DB [message #516212 is a reply to message #516208] |
Fri, 15 July 2011 08:52 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 15 July 2011 08:43Quote:Where can this information be stored?
What does "this information" refer to?
Regards
Michel
The information that tells my new DB to look for an old initfile. Some how the information about this initfile must be stored some where?
[oracle@myhost ~]$ test01
[myhost:test01:~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fr Jul 15 15:23:19 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/dbs/initTEST01.ora'
SQL>
[Updated on: Fri, 15 July 2011 08:55] Report message to a moderator
|
|
|
|
|
|
|
Re: Learning RMAN, requesting initfile during startup DB [message #516227 is a reply to message #516226] |
Fri, 15 July 2011 10:54 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
That is expected and is what we already said.
You have to create the init<ORACLE_SID>.ora
Edit:
quoting myself in previous post.
>>Oracle by default will look for init.ora file named as init<ORACLE_SID>.ora in $ORACLE_HOME/dbs.
oracle@eddie#echo $ORACLE_HOME
/u01/home
oracle@eddie#export ORACLE_SID=thisIsJunk
oracle@eddie#sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 15 11:47:46 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/home/dbs/initthisIsJunk.ora'
[Updated on: Fri, 15 July 2011 10:57] Report message to a moderator
|
|
|
Re: Learning RMAN, requesting initfile during startup DB [message #516229 is a reply to message #516227] |
Fri, 15 July 2011 11:23 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Very strange as I have done this before and then the new DB used an dummy initfile instead.
I then restored my spfile and created an pfile to edit (some paths were different from my PROD db).
So, the question remains why my new DB suddenly requests an initfile (well, an initTEST01.ora) for its very first startup.
|
|
|
|
|
|
|