Home » RDBMS Server » Backup & Recovery » Learning RMAN, requesting initfile during startup DB (RMAN, RDBMS 10.2.0.5, RHEL6)
Learning RMAN, requesting initfile during startup DB [message #516204] Fri, 15 July 2011 08:36 Go to next message
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 #516206 is a reply to message #516204] Fri, 15 July 2011 08:40 Go to previous messageGo to next message
BlackSwan
Messages: 21978
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Learning RMAN, requesting initfile during startup DB [message #516208 is a reply to message #516204] Fri, 15 July 2011 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Where can this information be stored?

What does "this information" refer to?

Regards
Michel
Re: Learning RMAN, requesting initfile during startup DB [message #516212 is a reply to message #516208] Fri, 15 July 2011 08:52 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Michel Cadot wrote on Fri, 15 July 2011 08:43
Quote:
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 #516213 is a reply to message #516212] Fri, 15 July 2011 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 21978
Registered: January 2009
Senior Member
ls -ltr /opt/oracle/product/10.2.0/dbs/*
Re: Learning RMAN, requesting initfile during startup DB [message #516214 is a reply to message #516212] Fri, 15 July 2011 09:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if the ORACLE_SID is set to TEST01, then Oracle by default will look for
init.ora file named as init<ORACLE_SID>.ora in $ORACLE_HOME/dbs.
Re: Learning RMAN, requesting initfile during startup DB [message #516216 is a reply to message #516214] Fri, 15 July 2011 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 21978
Registered: January 2009
Senior Member
on *NIX, ORACLE_SID is CaSe SenSiTiVe.
"TEST01" is different from "test01"
Re: Learning RMAN, requesting initfile during startup DB [message #516226 is a reply to message #516204] Fri, 15 July 2011 10:42 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
ls -ltr /opt/oracle/product/10.2.0/dbs/* shows only init.ora (default init)
There are no initTEST01.ora as I deleted it after I dropped the old database.
Re: Learning RMAN, requesting initfile during startup DB [message #516227 is a reply to message #516226] Fri, 15 July 2011 10:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
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 Go to previous messageGo to next message
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.
Re: Learning RMAN, requesting initfile during startup DB [message #516231 is a reply to message #516229] Fri, 15 July 2011 11:25 Go to previous messageGo to next message
BlackSwan
Messages: 21978
Registered: January 2009
Senior Member
>So, the question remains why my new DB suddenly requests an initfile (well, an initTEST01.ora) for its very first startup.
ORACLE_SID=TEST01
Re: Learning RMAN, requesting initfile during startup DB [message #516232 is a reply to message #516229] Fri, 15 July 2011 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it needs one.

Regards
Michel
Re: Learning RMAN, requesting initfile during startup DB [message #516234 is a reply to message #516232] Fri, 15 July 2011 11:42 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Sorry to have disturbed you with my stupidity, this is what I was looking for:

STARTUP FORCE NOMOUNT; # RMAN starts instance with dummy parameter file


Regards
H
Re: Learning RMAN, requesting initfile during startup DB [message #516237 is a reply to message #516234] Fri, 15 July 2011 11:48 Go to previous message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This has to do with RMAN (in RMAN prompt) and in your previous posts you were trying to do with sql*plus?
We can only work with what we can see Smile
Previous Topic: Routine to corrupt a block
Next Topic: RMAN Incremental Backup
Goto Forum:
  


Current Time: Thu Apr 24 16:07:05 CDT 2014

Total time taken to generate the page: 0.15371 seconds